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!