Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nakul Vachhrajani SQL Server Stored Procedures and SET options RE: SQL Server Stored Procedures and SET options
tom.w.brannon
Hall of Fame
Points: 3956
More actions
August 29, 2013 at 7:09 am
#1645961
Thank you for this post! I found a small problem in the first block of code. PRINT 'ANSI_WARNINGS is OFF'
is not executed because SELECT @userOptions = @@OPTIONS; is executed before ANSI_WARNINGS is reset.