This script will kill all current connections to a database in MSSQL. This is useful for detaching the database, restoring it or performing other tasks that require all connections dropped from the database.

kill_mssql_db_connections.sql

DECLARE @SQL VARCHAR(8000)

SELECT @SQL=COALESCE(@SQL,'')+'Kill '+CAST(spid AS VARCHAR(10))+ '; '
FROM sys.sysprocesses
WHERE DBID=DB_ID('<DATABASE_NAME>')

EXEC(@SQL)