Tranactions in Sql server?

• subha.mcts2005

  SSC Eights!

  Points: 928

  More actions

  October 20, 2010 at 8:04 am

  #149040

  Hi,

  How many nested transaction can possible in sql server?

  Subha

  DBA

• hallidayd

  SSCrazy

  Points: 2490

  More actions

  October 20, 2010 at 8:10 am

  #1239707

  Have as many as you like it makes no difference - they are a mirage.

  http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%282630%29-nested-transactions-are-real.aspx