Dienstag, 22. September 2009

Prozesse beenden

declare @str varchar(8000)
set @str=''
select @str=@str+'kill '+cast(spid as varchar)+char(13)+char(10)+'go'++char(13)+char(10)
from sysprocesses where dbid=id_your_db
exec(@str)