- USE master
- go
- IF EXISTS ( SELECT *
- FROM dbo.sysobjects
- WHERE id = OBJECT_ID(N'[dbo].[P_KillConnections]')
- AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
- DROP PROCEDURE [dbo].[P_KillConnections]
- GO
- CREATE PROC P_KillConnections @dbname VARCHAR(200)
- AS
- DECLARE @sql NVARCHAR(500)
- DECLARE @spid NVARCHAR(20)
- DECLARE #tb CURSOR FOR
- SELECT spid=CAST(spid AS VARCHAR(20)) FROM master..sysprocesses WHERE dbid=DB_ID(@dbname)
- OPEN #tb
- FETCH NEXT FROM #tb INTO @spid
- WHILE @@fetch_status = 0
- BEGIN
- EXEC('kill '+@spid)
- FETCH NEXT FROM #tb INTO @spid
- END
- CLOSE #tb
- DEALLOCATE #tb
- go
- --修改一下
- EXEC P_KillConnections '修改成自己的数据库'
- --该片段来自于http://www.codesnippet.cn/detail/0604201614643.html
来源: http://www.codesnippet.cn/detail/0604201614643.html