Month: May 2010

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)