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...
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,...
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...
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...
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...
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...
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.
