SQL Error 37000: Active Save Point

• martin 81121

  SSC Veteran

  Points: 217

  More actions

  April 1, 2015 at 7:32 am

  #302711

  Hi

  Hopefully someone can help,

  I have a piece of software which is returning a SQL Error:

  37000: Cannot Promote the transaction to a distributed transaction because there is an active save point in this transaction.

  How can I find and/or clear this Active Save Point?

  I have tried running dbcc opentran but it returns No active open transactions.

  Many Thanks in Advance!!

  Martin

• SoHelpMeCodd

  SSCertifiable

  Points: 5871

  More actions

  August 6, 2015 at 11:40 pm

  #1818019

  This is the wrong forum for that question :). There are many potential answers on MSDN: https://social.msdn.microsoft.com/Search/en-US?query=Cannot%20Promote%20the%20transaction%20to%20a%20distributed%20transaction%20because%20there%20is%20an%20active%20save%20point%20in%20this%20transaction.&emptyWatermark=true&ac=5