Home Forums SQL Server 2008 T-SQL (SS2K8) Possible to use tored proc to kill all queries running longer than 2 hours AND are blocking other queries RE: Possible to use tored proc to kill all queries running longer than 2 hours AND are blocking other queries
dndaughtery
SSChampion
Points: 11290
More actions
May 3, 2013 at 3:00 pm
#1612342
I agree but in this case its with an adhoc dev enviroment which its ok. If someone could explain to me how to go about it I would appreciate it