Help Me: SP Transaction within .Net Transaction - is it good.

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  January 16, 2012 at 2:48 am

  #1433948

  From my point of view, SP level transactions are preferable to .Net ones. I would only use a .Net transaction in my code if I needed to execute a number of stored procedures in a batch and ensure they completed.

  If there was no detrimental effects to having a failed SP call I wouldst use one at all and handle the error in code.

• Paul White

  SSC Guru

  Points: 150468

  More actions

  January 16, 2012 at 2:52 am

  #1433951

  SQL Server allows transactions to be nested for exactly this sort of situation. See http://msdn.microsoft.com/en-us/library/ms189336.aspx

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi