--杀掉sleeping的进程
USE master
go
DECLARE cur1 CURSOR FOR
SELECT spid FROM sysprocesses
WHERE dbid=15 and status='sleeping'
OPEN cur1
declare @id varchar(10)
FETCH NEXT FROM cur1
INTO @id
WHILE @@FETCH_STATUS = 0
BEGIN
exec('kill '+@id)
FETCH NEXT FROM cur1
INTO @k_spid
END
CLOSE cur1
DEALLOCATE cur1
GO