To kill active connections in SQL Management Studio 2008 do this:
1. Right-click the server in Object Explorer and select 'Activity Monitor'.
2. When it opens, expand the Processes group.
3. Now use the drop-down to filter the results by database name.
4. Kill off the server connections by selecting the right-click 'Kill Process' option.
If you are using SQL Management Studio 2005 it's a good advice to upgrade management studio to 2008 as it works with latest MSSQL2005 server updates.
1. Right-click the server in Object Explorer and select 'Activity Monitor'.
2. When it opens, expand the Processes group.
3. Now use the drop-down to filter the results by database name.
4. Kill off the server connections by selecting the right-click 'Kill Process' option.
If you are using SQL Management Studio 2005 it's a good advice to upgrade management studio to 2008 as it works with latest MSSQL2005 server updates.
No comments:
Post a Comment