Kill all connections to SQL Server Database
To see who is connected, call EXEC sp_who or sp_who2 (more information) from a master database on the server.
To kill blocking/deadlocked connections, right click on the database - tasks - Detatch. Click the blue "users connected" warning and kill the processes.
To kill sleeping connections, execute "KILL x", where x is the spid you see from exec sp_who.
Created By: amos 12/5/2011 12:08:59 PM
Updated: 1/30/2018 3:55:07 PM