USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('DataBaseName');EXEC(@SQL);GOALTER DATABASE DataBaseName SET MULTI_USER;
本文共 261 字，大约阅读时间需要 1 分钟。
USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('DataBaseName');EXEC(@SQL);GOALTER DATABASE DataBaseName SET MULTI_USER;
转载于:https://www.cnblogs.com/lishidefengchen/p/9103956.html