删除数据库（避免正在使用发生的错误）

use master
declare @dbname sysname set @dbname='AAA' --这个是要删除的数据库库名
IF EXISTS (SELECT * FROM SYSDATABASES WHERE name=@dbname)
BEGIN
        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+']')
END
GO

转载于:https://www.cnblogs.com/the7stroke/archive/2011/11/10/2245023.html