SQL Transactions...

Results 1 to 2 of 2

Thread: SQL Transactions...

  1. #1
    Join Date
    Dec 1969

    Default SQL Transactions...

    In this scenario, are the events that occur in sproc2 and sproc 3 included in my transaction and able to be rolled back?<BR><BR>Thanks in advance,<BR>Mitch<BR><BR>Start Sproc1<BR><BR>Begin Tran<BR><BR>do stuff...<BR><BR>exec sproc2<BR><BR>do stuff..<BR><BR>exec sproc3<BR><BR>do stuff..<BR><BR>if @ErrorsHappened = true<BR>BEGIN<BR> Rollback Tran<BR>END<BR>else<BR>BEGIN<BR>Commit Tran<BR>END<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Transactions...

    Yes, they are included.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts