Check and kill the session connected in SQL Server Database
SQL Server Management Studio 2005
When you right click on a database and click Tasks and then click Detach Database, it brings up a dialog with the active connections.
By clicking on the hyperlink under “Messages” you can kill the active connections.
You can then kill those connections without detaching the database.
- Right-click the server in Object Explorer and select ‘Activity Monitor’.
- When this opens, expand the Processes group.
- Now use the drop-down to filter the results by database name.
- Kill off the server connections by selecting the right-click ‘Kill Process’ option.