SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.
By Nakul Vachhrajani
2015/10/02 (first published: 2013/08/29)