You can identify the SQL server environments using various settings from the Sql server Management Studio 2008. a. Open Management studio b. Press Ctrl + Alt+ G (List of Registered Servers) c. Right Click on one of the Registered Servers –> Properties d. Go to the Connection Properties Section and voila you can see the [...]
May
26
2009
26
2009
May
18
2009
18
2009
Kill the Sql server process for a Database
When Doing database Restore sometimes we may need to kill the spid’s in the database so that the connections are not open. Going through the spids in sp_who or sp_who2 can sometimes be a tedious task if there are more connections to the database. The following TSQL should generate the list of kill statements for [...]
