sqlserver断开所有连接
sql server 断开所有连接
DECLARE @sql VARCHAR(4000)
SET @sql= ''
SELECT @sql = @sql + ' kill ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM master.sys.sysprocesses WHERE dbid = db_id( 'CMDK_DEV')
EXEC(@sql)
EXEC sp_executesql @sql
DECLARE @sql VARCHAR(4000)
SET @sql= ''
SELECT @sql = @sql + ' kill ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM master.sys.sysprocesses WHERE dbid = db_id( 'CMDK_DEV')
EXEC(@sql)
EXEC sp_executesql @sql