Answer Questions

• Jacobus SQL Server 2005 - TCP "Keep Alive" problem / not working

  We tested this new feature ("Keep Alive" for orphant connections to automatically close) with no success - neither the standard properties nor slightly changed properties worked. We tested like this: SQL Server 2005 - ADO.NET Client The client established an explicit lock on one row at one database. Afterwards we disconnected the client by pulling out the network-cable. We waited about 35 sec for the sessios to close - but nothing ha ...Show All

• Randa Maher Use a dataset as source of another data set

  Dear Anyone, Would it be possible in RS2005 to use an existing data set as the source of another data set We have a scenario of which we have several parameters whose data comes from a single table. We would want to limit the queries on the database. Is this possible at all Thanks, Joseph There is no simple way to use one DS as source for another. But. There is one direction you can explore. If you have a case when ...Show All

• Ayres I encountered problem after .NET framework upgraded to 2.0 in the server

  I posted the question below to this website 6 hours ago, the subject was "SQL server registration failed". I couldn't find this question just now. This is my first time to post a question to microsoft website. Please let me know the related website if the question shouldn't be posted here.(I think it 's related to this site) URGENT, I need help, thanks. I installed .Net framework 2.0 in a Window 2003 Server and VS2005 in my PC a fe ...Show All

• Surindra Index on bit fields in SQL Server Management Studio

  I noticed that I can put a bit field in an index in a SQL Server 2000 database, while using the SQL Server Management Studio (shipped with SQL Server 2005). In SQL Enterprise Manager this wasn't possible. Does SQL Server 2000 support indexes on bit fields and doesn't Enterprise Manager support it, or doesn't SQL Server 2000 support indexes on bit fields and is it a 'bug' of the SQL Server Management Studio Thanks. ...Show All

• Neha_roy Excel pivot table

  Hi, I have created an OLAP Cube in SQL Server 2005 CTP2 and can browse it fine in the Analysis Studio / Browse tab. When I use the pivot table feature in Excel (2003) I get: XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a value. Any help is appreciated. Cheers, Adam Hi. As you can see on my other post, I had the same problems but after scratcing my head f ...Show All

• HMoutawakkil SQL Server Setup failed to retrieve the SSL Certificate Name

    When I try to install SQL 2005 Developer September CTP on Windows XP Professional  it returns an error "SQL Server Setup failed to retrieve the SSL Certificate Name" . I was using a certificate from SelfSSL but removed it. Still no luck This appears to be an issue with SQL Reporting Services. If I don't install Reporting Services then I can install SQL 2005. I'm guessing that Reporting Services is now requiring a certificate a ...Show All

• Robert Beaubien Issue in setting up the database Mirrioring environment for SQL Server 2005.

  Environment : SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS. I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING. I got the error message. Please find the Message below. An error occured whi ...Show All

• Russell Hunter How can I create more instances of the Analysis services server?

  Hi, all here, I now have a question about how can I create more instances of the analysis services server Currently I only have one instance of the analysis services server. Thanks a lot for in advance for any guidance and help. Yes, as far as I know. From Books Online: To install an additional instance of Analysis Services Run Setup either by using the SQL Server Installation Wizard or from the command pro ...Show All

• PhilMan99 Adding Reference and Importing .NET into Script Transformation

  I have a .NET component that I want to import into a Script Transformation of a Data Flow. Going into the script code (editing Script transformation and clocking "Design Script" button), I try to "Add Reference" to the component (Add Reference selection under "Project" menu), but I do not see it - nor do I have the option to Browse for the component. How do I establish a reference to an external .NET component so I can use it in my transformati ...Show All

• stanford Is Metadata Report Tool Ready for SSIS

  We were promissed a tool to view, report, export or save metada information such as tranformation properties -- tables and columns used or mapped. Names of transformations, tasks control objects, etc. Is this tool available and why is Microsoft taking so long to deliver such a critical tool.  To add to Thomas' post, here is a whitepaper that discusses how to use the tool: http://www.microsoft.com/downloads/details.aspx Famil ...Show All

• virtualrush difference between the versions of SQL server

  Do you find that there is a big difference between the different versions of SQL server (6.5, 7, 2000, 2005) as is between Microsoft programming languages (VB.4, VB5, VB6, .Net and now .Net 2) Or is the difference in SQL server minimal and very small compared to the programming languages I mentioned. Thanks a lot The change from SQL 6.5 to 7 is pretty big and the change from 7/2000 to 2005 is pretty big. However it all depends what ...Show All

• psc161 SQL Server Connectivity Problem

  Hi there, I am facing sql server connection problem. can any one help Problem Details: I had install sql server in my local computer and i want to use the tables that i had create in my VBA. I tried to build many connection string but the error "[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied" always appear. how can i solve this problem can anyone help Hi, Noora 1) If you ...Show All

• shjuspea Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• englishw create user only with permissions, to select, insert, update, delete, and exec sps

  Hello, I recently view a webcast of sql injection, and at this moment I created a user, and give dbo to this user, and this same user, is the one I have in the connection string of my web application, I want to create a user to prevent sql injection attacks, I mean that user wont be able to drop or create objects, only select views, tables, exec insert,update, deletes and exec stored procedures. Is any easy way to do this A database role a ...Show All

• Jacques 316 Users in limbo

  SQL Server Management Studio Express CTP Nov 9.00.1399 I create a user called "appx" (uses SQL Server Authentication). I attach a database (created with SQL 2000), that contains a user called appx. I get "cannot open database. the login failed" when I try to connect to the database from a client app. Note: I can connect as "sa". When I use the Management Studio Express to see the user's properties for the database, the user name ...Show All