2012年8月15日
DatabaseOperation_DBM - Kill inactive connection
摘要： DECLARE cConnections CURSOR READ_ONLY FAST_FORWARD FOR SELECT spid FROM master..sysprocesses p INNER JOIN master..syslogins l ON p.sid = l.sid WHERE l.loginname LIKE 'MSDOMAIN1\%' AND l.loginname NOT IN ('MSDOMAIN1\xzhang3', 'MSDOMAIN1\ouli', 'MSDOMAIN1\atian1') AND p 阅读全文
posted @ 2012-08-15 10:26 Alex Tian 阅读(261) 评论(0) 推荐(0)