Max user connections works on per user basis or it would be the Total number of connections that can be opened at a time, including all the users....
We have a case where a user is using Excel sheet to connect the database on SQL2K and generally his connection runs in the upper 150 in numbers. He...
We have a SQL Server 6.5 table, with composite Primary Key, having the Duplicate Entry for the Key. I wonder how it got entered there? Now when we...
Do you think that restoring it from a good old backup or even the installation cd would correct it? Let me ask you this: Can I restore one model...
How do I change the Database owner for a MODEL database? When I open the properties for a Model database, it shows "UNKNOWN" as the database owner,...
I have downloaded and installed the Microsoft JDBC on the unix server and now I'm trying to connect to the SQL Server at the Unix Prompt using:<br...
Has anyone tried to connect to a SQL Server 2K running on Windows 2000 from a unix machine? If so then could you provide me some help? Thanks in...
In the morning I had changed the status of some of the databases to DBO Use Only/Offline and probably they were the ones causing the grief. Finally I...
All of a sudden all the databases under the SQL Server Enterprise Manager have disappeared. Any idea why and how to get them back? I 'm on SQL 2000...
Think about using SqlLite tool from dbassociate. They work great, not only they reduce the backup size by 50-80%, they also reduce the backuptime by...
We had a standby database on one of our SQL Server and we changed the name of the NT box where the Standby database was residing. After changing the...
What's the best tool avaliable in the market today for the purpose of Auditing SQL Server without adding too much of overhead on the server itself....
I tried changing the Logical file name for one of the User's database in SQL Server by running the Update command against the SYSFILES1 table. The...
I found that yesterday one Client was disconnected from the SQL Server, while it was still in the middle of a transaction, resulting in an Orphan...
Hi, From the last two days, I have noticed that I cannot Open the Current Activity List present in the SQL Enterprise Manager under the Management...
I have a very large table, around 54 millions rows, which is indexed properly and the performance is not an issue. Now we are planning to move it to...
The ServerB has to be RealTime and in Sync with ServerA.
The inserts are 24 x 7 operation and it happens almost every minute. Running sp_who doesn't reveal much information and I also checked the Locking...
I have two servers, Server A and B. Server B is linked to Server A as a linked Server and there is one table TableA on ServerA and ServerB. TableA...
Separate names with a comma.
