Post reply

Scope question

  • June 24, 2005 at 12:51 am

    #76353

    Can I assume that statements within a transaction in a sp is a single scope and single session?

    Thanks and Regards,

    Dinuj Nath

  • June 24, 2005 at 1:21 am

    #568186

    Within a stored procedure itself is single scope even without a transaction.

    External calls, Call another stored procedure and triggeres are out of scope even within a transaction.

    Data modified or inserted is within scope of the transaction.

    Regards,
    gova

  • June 24, 2005 at 2:21 am

    #568199

    Thank you qovinn

    Thanks and Regards,

    Dinuj Nath

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply