Answer Questions

• Dan_Seattle Max connections in sql server 2000 MSDE

  Hi ! What is the max number of connections in sql server 2000 MSDE I have found three opinions on the web: 5,8 and unlimited(32,768...) Which is true /hakan I don't think there is any limit to the number of connections. . . there is a throttle on performance based on number of concurrent connections. the actual number that triggers the throttle i beleive depends on build/sp. that being said. . . if you ...Show All

• Peter Stiff "Cannot open user default database"

  [2005 Developer Edition] In Management Studio I changed my default database to a user db. I subsequently unselected that db as the default leaving me with no default db (I think - it's been awhile and I may not have this exactly right). But regardless, I can no longer Connect to Server using Management Studio (Windows authentication) - I get Cannot open user default database. Login failed. Login failed for user 'DANA\Administrator'. (Microsof ...Show All

• ChrisWall Common Password

  Hi, I would like to setup a common password for all the MS SQL Server Users. Is there any generalized script for the same Thanks In Advance. If you are an administrator and you want to reset a user's password, then you can just execute: ALTER LOGIN user WITH PASSWORD = 'new_password' See the ALTER LOGIN topic in BOL for more info on this statement. Is this what you were looking for Laurentiu Thanks Lots Laurentiu. In SQ ...Show All

• Math Nerd RDA Pull with existing table

  Hi Forum, I am currently implementing RDA Pulls and Pushes. Both worked fine for me, except when I try to pull a certain table twice. I read that in order to pull the table a second time I must drop it on the client. My original approach was to use a select statement with a where criterium in the pull statement (e.g. SELECT * from tblPhonebook where Pulled = 0), then set Pulled to 1 and pull again later. My understanding of RDA was that I use th ...Show All

• kapicou Rights assigned to Windows\Power Users in SQL Express.

  Hi, In SQL Server Express Edition, what are the rights that are assigned to a Normal Windows User and PowerUser by default When I install SQL Express on a clean machine and login as Power User I can add/edit/delete data but when I login as Normal Windows User I can see the data but not change it. Please help me in this regard. Thanks and Regards, Gautham. What do you mean exactly by the ability to add/edit ...Show All

• ShaulB What is faster: DataReader or DataSet or something else?

  Hi, I need to read 250,000 records and show this information. I am using DataReader and it takes 8 seconds. I need to raise it to 0.8 seconds atleast. What is faster: DataReader or DataSet or something else Thank's Alexei Can you post the table structure and query you are running If you really need all the data than I cannot see how to speed up your task. One thing yo may do is to perform data load/processing in a separate thread, but ...Show All

• NickNelson How to make a SELECT with a field name inside a variable??

  I have a table (for example PERSONS) with several fields (NIF NAME AGE). I have a cursors than read the differents fiels tat have this table inside a trigger fron another table that contain all the fields of the tables. This cursor save the name of the fiels inside the variable @FIELD. I need to read the value of the several records of the table like: @FIELD='NIF'   <--(CURSOR) SELECT @FIELS FEOM INSERTED   --> select nif f ...Show All

• mark baran SQL 2005 Time Sensitive Question

  I have a problem installing sp 1 for sql 2005 express. How can I check if I have sql server or the sql 2005 express edtion and if it is a beta or not. I want ot install the SP1 OF SQL 2005 When I go to the add/remove program section I see sql 2005 edition and not sql 2005 express edition, very confusing because it indicates to look for sql 2005 express edition in the add/remove program and remove it. I don't even know if I have a beta release or ...Show All

• Shawn Burke - MS SQL Server 2005 Reporting Serivces: XML Datasource problem

  Hi, I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing: 1. I created a webservice at the following location: http://localhost/myWebDirectory/myService.asmx . this webservice has a method called " GetXMLDocument" that has 1 parameter (sql). This method uses the sql st ...Show All

• Jan Hrudka Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get th ...Show All

• Chris Harshman SQL reporting services 2005 with CLR

  Hi, I am trying to use reporting services 2005 with a VB SQL stored procedure that i created in visual studio using CLR. The stored procedure was created successfuly in SQL server but while linking the report to the stored procedure, i am receiving the following message "An error occurred while retrieving the parameters in the query. The stored procedure 'mysp' doesn't exist.   Thanxs in advance       ...Show All

• Aleth Analysis Services Cube Browser utility opening extremely slow

  I have a relatively large cube that when I try to open it up via the cube browser utility in SQL Server Management Studio, it takes approximately 25 minutes for the cube browser utility to open up.  If I want to query the database via MDX, the MDX writing utility (right-click on the database->New Query->MDX) comes back really fast (within a second). What does the browser utility do differently that requires it to take so long versu ...Show All

• Naethe Manning Sql Express Installation problem setting sql account to ="NT AUTHORITY\SYSTEM"

  Hello, I am having trouble installing sql express from a command line on an XP o/s other than English, I know French and German have the problem I suspect this is caused by setting the sql account to ="NT AUTHORITY\SYSTEM" my guess is that this is a localized string. I get the following error SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services be ...Show All

• Johan Fourie Active Directory access in SSIS

  Does anyone have any examples of setting up a connection manager in SSIS to read information from Microsoft Active Directory  I would like to retrieve a list of users and populate them into a SQL Server table. Thanks! Harry  BOL has an example for a script task but it should be fairly straight forward to convert it to a script component.  There is also an OLEDB driver for active directory that should be able t ...Show All

• Monkey Boy Transactions/Client-Side Redirect issue

  Hi there. With Client-Side Redirect, connections can be dinamically redirected in case of failover. But if a long transaction is running on the principal, when it fails the redirect doesn’t work with the current ado.net connection, connected to the database running that transaction. So if the principal fails, current running transaction will be lost right    Thanks in advance. ...Show All