DECLARE @d VARCHAR(8000) SET @d = ‘ ‘
SELECT @d = @d + ‘ kill ‘ + CAST(spid AS VARCHAR) + CHAR(13)FROM MASTER.sys.sysprocessesWHERE dbid = DB_ID(‘ATMS ‘) EXEC (@d)
断开所有远程连接（sql server）
原文：http://www.cnblogs.com/GerryOfZhong/p/5219710.html
