- USE MASTER
- GO
- DECLARE @dbname SYSNAME
- SET @dbname = '修改此处数据库名' --这个是要删除的数据库库名
- 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 database [' + @dbname + ']')
"无法删除数据库,因为该数据库当前正在使用",删除数据库方法
最新推荐文章于 2024-03-18 12:11:03 发布