use master

go

DECLARE @SQL VARCHAR(MAX);

SET @SQL=''

SELECT @SQL=@SQL+'; KILL ' + RTRIM(SPID)

FROM master..sysprocesses

WHERE dbid=DB_ID('AIS20181207174817_zhengshi');

EXEC(@SQL);

Go

ALTER DATABASE AIS20181207174817_zhengshi set MULTI_USER


标签: none

添加新评论