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