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