Re: Transaction span stored procedures

Relevant Pages

• Re: Transaction span stored procedures
  ... spanning a transaction over multiple stored procedures? ... > Savepoints" in SQL BOL. ... > transactions inside stored procedures. ...
  (microsoft.public.sqlserver.programming)
• Re: Transaction Oriented Architecture (TOA)
  ... It had better be a transaction I already know about so I can record it properly and make sure your session gets credit. ... In that case the client-side Data Layer has the responsibility for mundane tasks like forming SQL queries and encoding/decoding SQL datasets. ... What I am talking about is analogous to that layer that decouples the Business Layer through an interface so the Business objects don't have to know about the specific mechanisms. ... TOA/TOP proposes the database and its application domain stored procedures are the only persistence mechanism necessary, and that the benefits of a focused, single, data-permeable gateway between application and database far exceed the benefits of O/R mappings--regardless of abstraction--and that its lightweight appearance shouldn't be dismissed as missing heavyweight kick. ...
  (comp.object)
• Re: multiple SP within transaction
  ... A transaction can span multiple batches, and multiple stored procedures. ... Wayne Snyder, MCDBA, SQL Server MVP ...
  (microsoft.public.sqlserver.programming)
• Re: multiple SP within transaction
  ... >A transaction can span multiple batches, and multiple stored procedures. ... > Wayne Snyder, MCDBA, SQL Server MVP ...
  (microsoft.public.sqlserver.programming)
• ADO.net or TSQL Transactions
  ... Should implement a transaction in both the stored procedure AND in ADO.net ... code or is doing it in one or the other good enough to protect against ... >>stored procedures, and the stored procedures are themselve quite quite ... >>protected from this by virtue of the ADO transaction object. ...
  (microsoft.public.sqlserver.programming)