Drop connections

				
--**************************************
-- Name: Drop connections
-- Description:PLEASE VOTE! This script drops all connection of a database. If you have installed SQL 2k client tools, you must copy this script to:
..\Program Files\MS SQL Server\80\Tools\Templates\Query Analyzer\Drop_Connection.tql!
Then you can use this template anytime from Query analyzer! (Click to "Object Browser", drag and drop the script, press "Replace Template Parameters" button and specify a database name)
-- By: Zoltan Tamas, Toth
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=478&lngWId=5--for details.--**************************************

DECLARE
@p_SPID int,
@p_SQL nvarchar(2000)
 DECLARE #cur_Processes CURSOR FOR
SELECT
 p.SPID
FROM 
 master.dbo.sysprocesses AS p
 JOIN master.dbo.sysdatabases AS d ON( d.dbid = p.dbid )
WHERE
 d.Name = '<Database Name, , Name>'
 OPEN #cur_Processes
 FETCH NEXT FROM #cur_Processes INTO @p_SPID
 WHILE @@FETCH_STATUS = 0 
 begin
SET @p_SQL = 'KILL ' + CONVERT( nvarchar(30), @p_SPID )
PRINT @p_SQL
EXECUTE( @p_SQL )
FETCH NEXT FROM #cur_Processes INTO @p_SPID
 end
 CLOSE #cur_Processes
 DEALLOCATE #cur_Processes