Viewing post 1 (of 2 total)
DECLARE @sql VARCHAR(8000)
SELECT @sql=COALESCE(@SQL, '') + 'KILL ' + CAST(SPID AS VARCHAR(10)) + '; '
FROM SYS.SYSPROCESSES
SELECT @sql
EXEC(@SQL)
December 7, 2009 at 1:00 am
#1088397