Script to kill inactive session

• Santhosh Kumar-258781

  Say Hey Kid

  Points: 669

  More actions

  March 15, 2006 at 9:09 pm

  #170931

  Hi

  Anyone got any script to kill all inactive sessions from SQL2000? I need ti kill those sleeping sessions that are inactive for more than 2 hrs...

   

  Pl help me

  Regards

  Santhosh

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  March 15, 2006 at 11:39 pm

  #626946

  There is this Steve Jones' article you can use:

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=82