USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''
///杀掉该进程SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID) FROM master..sysprocessesWHERE dbid=DB_ID('Test');
EXEC(@SQL);
///改成多用户ALTER DATABASE Test SET MULTI_USER;
搜索
复制