Home Forums SQL Server 2005 Administering Maintenance Plan failing RE: Maintenance Plan failing
John Mitchell-245523
SSC Guru
Points: 148809
More actions
March 22, 2016 at 6:48 am
#1866751
You could write something that will loop through active connections and kill any that haven't done anything for longer than a particular period of time. Make sure you test thoroughly before doing anything like that in live.
John