USE master;
GO
DECLARE @SQL VARCHAR(MAX);
SET @SQL=''
SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)
FROM master..sysprocesses
WHERE dbid=DB_ID('databaseName');
EXEC(@SQL);
GO
ALTER DATABASE databaseName SET MULTI_USER;
数据库右侧显示(单个用户)
最新推荐文章于 2024-05-30 14:06:09 发布