[SQL] Disconnects all active connections of a database with an SQL statement

1 Use Master2 Go3 4IF EXISTS (SELECT *5 From dbo.sysobjects6WHERE id = object_id (N'[dbo]. [P_killconnections]')7and OBJECTPROPERTY (ID, N'isprocedure') =1 ) 8 DROP PROCEDURE [dbo]. [P_killconnections]9 GOTen  OneCREATE PROC p_killconnections @dbname VARCHAR ( $) A  as -DECLARE @sql NVARCHAR ( -) -DECLARE @spid NVARCHAR ( -) the  - DECLARE #tb CURSOR for -SELECT spid=cast (spid as VARCHAR ( -) from Master. sysprocesses WHERE dbid=db_id (@dbname) - OPEN #tb + FETCH NEXT from #tb into @spid -While @ @fetch_status =0  + BEGIN AEXEC ('Kill'+@spid) at FETCH NEXT from #tb into @spid - END - CLOSE #tb - deallocate #tb - Go -  in  ---Modify toEXEC p_killconnections'change to your own database'

[SQL] Disconnects all active connections to a database with an SQL statement