USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('HO_1 '); --HO_1 数据库实例
EXEC(@SQL);
GO ALTER DATABASE HO_1 SET MULTI_USER;