[SQL-码农]SQL SERVER 断开所有连接（转）

最新推荐文章于 2021-01-20 01:24:46 发布

妹子把我们叫二货

最新推荐文章于 2021-01-20 01:24:46 发布

阅读量782

点赞数

分类专栏：数据库-SQL-码农

数据库-SQL-码农专栏收录该内容

47 篇文章 0 订阅

订阅专栏

DECLARE @d VARCHAR(8000) 
DECLARE @DataBase VARCHAR(8000) 
SET @d = ' ' 
set @DataBase='你的数据库'

SELECT 
    @d = @d + '   kill   ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM   
    MASTER.sys.sysprocesses
WHERE  
    dbid = DB_ID(@DataBase)
 
select   (@d)
exec   (@d)



USE [master]
GO

/****** Object:  StoredProcedure [dbo].[KillTheDateBaseLink]    Script Date: 03/14/2014 11:05:55 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[KillTheDateBaseLink]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[KillTheDateBaseLink]
GO


-- ================================================

-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
--升级版
-- =============================================
CREATE PROCEDURE KillTheDateBaseLink
@DataBase VARCHAR(8000) 
AS
BEGIN
DECLARE @d VARCHAR(8000) 
--DECLARE @DataBase VARCHAR(8000) 
SET @d = ' ' 
--set @DataBase='你的数据库'

SELECT 
    @d = @d + '   kill   ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM   
    MASTER.sys.sysprocesses
WHERE  
    dbid = DB_ID(@DataBase)
 
select   (@d)
exec   (@d)


END
GO



GO

exec master.dbo.KillTheDateBaseLink 'model'