DECLARE @str VARCHAR(500);
SET @str = '';
SELECT @str = @str + 'KILL '+RTRIM(spid)+';'+CHAR(13)+CHAR(10)
FROM master.dbo.sysprocesses
WHERE dbid=DB_ID('库名');
EXEC(@str);
GO
DECLARE @str VARCHAR(500);
SET @str = '';
SELECT @str = @str + 'KILL '+RTRIM(spid)+';'+CHAR(13)+CHAR(10)
FROM master.dbo.sysprocesses
WHERE dbid=DB_ID('库名');
EXEC(@str);
GO