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)
Stuff
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)