SET XACT_ABORT, etc.

  • If I call a stored proc that has a switch to turn XACT_ABORT ON, do I have to explicitly turn it back off at the end of the proc, or will it immediatley pick up the default setting if not specified? Is that the same for NOCOUNT, and other options?

    Thank you!

  • Topic "SET (described)" in BOL has the answer on your question and a lot of other useful information.

    _____________
    Code for TallyGenerator

  • Perfect, thank you!

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

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