Re: Transaction span stored procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: J (j_at_h.com)
Date: 02/05/05 

Date: Fri, 4 Feb 2005 19:48:51 -0600

Thank you for this reply. Question: is this an often used technique for
spanning a transaction over multiple stored procedures?

"Max" <maxl@msn.com> wrote in message
news:1107561854.264951.108980@g14g2000cwa.googlegroups.com...
> See "Rollbacks in Stored Procedures and Triggers" and "Transaction
> Savepoints" in SQL BOL.
>
> It is @@trancount and you have to use savepoints to manage nested
> transactions inside stored procedures.
>

Relevant Pages

  • Re: Transaction span stored procedures
    ... See "Rollbacks in Stored Procedures and Triggers" and "Transaction ... Savepoints" in SQL BOL. ... It is @@trancount and you have to use savepoints to manage nested ...
    (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)