Msg 3971 ... The server failed to resume the transaction ... The transaction active in this session has been committed or aborted by another session.

• mphilippopoulos

  SSC Eights!

  Points: 846

  More actions

  August 31, 2010 at 11:52 am

  #223284

  While running a SELECT query on a SQL-2008 server instance I get the following error:

  Msg 3971, Level 16, State 1, Line 1

  The server failed to resume the transaction. Desc:6200000004.

  The transaction active in this session has been committed or aborted by another session.

  Any ideas what's wrong?

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  August 31, 2010 at 10:58 pm

  #1214727

  Your instance might be using begin transactions or use your select query with(nolock),

  and try with DBCC opentran is there any active transactions being in process and kill them by manually