我在网上找到一个C#数据库帮助类 http://www.fm0898.com/show.aspx?id=33624&cid=65 里面有一个kill连接的sql语句,不过我这里运行错误,请各位大神帮忙看一下declare hcforeach cursor global for select 'kill '+rtrim(spid) from master.dbo.sysprocesses where dbid=db_id(N'mytest') exec sp_msforeach_worker '?'
http://www.fm0898.com/show.aspx?id=33624&cid=65
里面有一个kill连接的sql语句,不过我这里运行错误,请各位大神帮忙看一下declare hcforeach cursor global for select 'kill '+rtrim(spid) from master.dbo.sysprocesses where dbid=db_id(N'mytest') exec sp_msforeach_worker '?'