kill sp id with all zeros

• pmadhavapeddi22

  SSCertifiable

  Points: 5306

  More actions

  October 27, 2009 at 4:11 am

  #211461

  When I try to kill this UOW using the guid of all zeroes, we get the

  following error:

  Msg 6110, Level 16, State 1, Line 1

  The distributed transaction with UOW {00000000-0000-0000-0000-000000000000}

  does not exist.

  Anybody familiar with killing orphaned transactions where the UOW

  GUID is all zeros

• Jay_dba

  Grasshopper

  Points: 17

  More actions

  October 27, 2009 at 4:55 am

  #1071109

  try this link:

  http://dbaspot.com/forums/sqlserver-server/367543-orphaned-transaction-sql-2005-a.html