Post reply

SET XACT_ABORT, etc.

  • March 31, 2008 at 3:59 pm

    #70155

    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!

  • March 31, 2008 at 4:18 pm

    #796198

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

    _____________
    Code for TallyGenerator

  • March 31, 2008 at 4:24 pm

    #796200

    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