Skip to content

Instantly share code, notes, and snippets.

@dagda1

dagda1/kill_connections.sql

Created March 28, 2011 10:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dagda1/890266 to your computer and use it in GitHub Desktop.
Save dagda1/890266 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
kill_connections.sql
USE [master]
DECLARE @DatabaseName nvarchar(50)
SET @DatabaseName = N'ncontinuity2'
DECLARE @SQL varchar(max)
SET @SQL = ''
SELECT @SQL = @SQL + 'Kill ' + Convert(varchar, SPId) + ';'
FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId
-- SELECT @SQL
EXEC(@SQL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment