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

  • May 7, 2013 at 5:00 pm

    #1613172

    Have you even tried it? If yes, what values you have passed? Waittime is value passes in millisecond so you have to convert hours in ms.