This post helped me to turn off some junk databases in MS-SQL server!
mssql
MS-SQL
Errors, mssql
Cannot open database requested in login ‘database name’. Login fails
This is a nasty error I got when I was doing a critical upgrade. We tried to connect to a […]
mssql, sql
add user query in ms-sql
just for reference. to create a user in ms-sql sp_addlogin @loginame = ‘bugtracker’, @passwd = ‘bugtracker123’,@defdb = ‘bugtracker’ defdb refers […]
mssql, sql
Specify a Maximum Cost for a Query in SQL Server 7
Ever had a user accidentally create a query that resulted in aCartesian product of your two largest tables? Of course, […]
mssql, sql
Determining Table sizes in MS-SQL
Hi, I was searching for a query that will give me the size of the table in MS-SQL, here it […]