Limit on number of savepoints in a transaction

• sadana_vishal

  Valued Member

  Points: 63

  More actions

  November 2, 2010 at 11:56 am

  #388150

  My question is --- is there a limit on number of savepoints that can be created in a single transaction?

  Thanks in advance

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  November 2, 2010 at 1:02 pm

  #1245666

  I am not aware of the restrictions on the number of Save points. This article states that there can be "multiple" save points in a transaction.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga