kill transactions with sp_id=-2

• pmadhavapeddi22

  SSCertifiable

  Points: 5306

  More actions

  May 14, 2009 at 9:48 am

  #204362

  Hi ,

  I am unable to clear the locks with req_transactionuow

  '00000000-0000-0000-0000-000000000000'

  I want to clear this. What does this indicate and how to clear this

  Thanks

  madhava

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  May 26, 2009 at 2:05 pm

  #1000176

  Read the attached doc:

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  May 26, 2009 at 4:12 pm

  #1000233

  I haven't read Manu's doc but -2 spid is related to MSDTC...

  I have had an orphaned spid (-2) previousl and it was related to a (MSDTC) transaction rolling back.

  read the article and see if it helps...

  Just had a quick scan of the doc and the problem i had was related to this section: Killing an MSDTC transaction

  I think the doc should should you out.

  Gethyn Elliswww.gethynellis.com