杀死所有进程
USE master
go
DECLARE @Sql NVARCHAR(max)
SET @Sql = ''
select @Sql = @Sql + 'kill ' + cast(spid as varchar(50)) + ';' from sys.sysprocesses where dbid = DB_ID('库名')
EXEC(@Sql)
改为多用户
USE master;
GO
DECLARE @SQL VARCHAR(MAX);
SET @SQL=''
SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)
FROM sysprocesses
WHERE dbid=DB_ID('库名');
EXEC(@SQL);
GO
ALTER DATABASE 库名 SET MULTI_USER;
标签:SET,多用户,数据库,Sql,SQLServer,库名,SQL
From: https://www.cnblogs.com/nuomibaibai/p/16734013.html