DECLARE @SQL VARCHAR(MAX); SET @SQL=''  SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID) FROM master..sysprocesses WHERE dbid=DB_ID('數據庫名稱');  EXEC(@SQL);GO ALTER DATABASE '數據庫名稱' SET MULTI_USER;