USE master

 go

 IF EXISTS ( SELECT  *

             FROM    dbo.sysobjects

             WHERE   id = OBJECT_ID(N'[dbo].[P_KillConnections]')

                     AND OBJECTPROPERTY(id, N'IsProcedure') =  )

     DROP PROCEDURE [dbo].[P_KillConnections]

 GO

 CREATE PROC P_KillConnections @dbname VARCHAR()

 AS

     DECLARE @sql NVARCHAR()

     DECLARE @spid NVARCHAR()

     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 =

         BEGIN

             EXEC('kill '+@spid)

             FETCH NEXT FROM #tb INTO @spid

         END

     CLOSE #tb

     DEALLOCATE #tb

 go

 --修改一下

 EXEC P_KillConnections '修改成自己的数据库'