データベースは現在「問題解決」を使用しているため削除できません.
3500 ワード
USE MASTER
GO
DECLARE @dbname SYSNAME
SET @dbname = 'EducationManagementSystem' --
DECLARE @s NVARCHAR( 1000)
DECLARE tb CURSOR LOCAL
FOR
SELECT s = 'kill ' + CAST( spid AS VARCHAR)
FROM MASTER ..sysprocesses
WHERE dbid = DB_ID(@dbname )
OPEN tb
FETCH NEXT FROM tb INTO @s
WHILE @@fetch_status = 0
BEGIN
EXEC (@s )
FETCH NEXT FROM tb INTO @s
END
CLOSE tb
DEALLOCATE tb
EXEC ('drop table[' + @dbname + ']')