Reprint: SQL Server 2005 cannot delete the database "#Test" because the database is currently in use

The database "#Test" cannot be deleted because the database is currently in use

--The following statement is executed in the Query Analyzer.

Use master
Go

declare @dbname sysname
Set @dbname = ' DB1 '-this is the name of the database library to be deleted

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 to @s
While @ @fetch_status =0
Begin
EXEC (@s)
FETCH NEXT from TB to @s
End
Close TB
Deallocate TB
EXEC (' drop database [' [email protected]+ '] ')

Reprint: SQL Server 2005 cannot delete the database "#Test" because the database is currently in use