BUS7 Consulting

USE master

go

DECLARE @dbname sysname

SET @dbname = 'yourdbname'

DECLARE @spid int

SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname)

WHILE @spid IS NOT NULL

BEGIN

EXECUTE ('KILL ' + @spid)

SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid > @spid

END

-- DROP THE DATABASE

ALTER DATABASE @dbname  SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DROP DATABASE  @dbname