SDU Tools: Fixing ANSI Nulls and Quoted Identifier settings for Stored Procedures

added by DotNetKicks
8/19/2019 3:43:15 PM

1 Kicks, 187 Views

When you create a SQL Server stored procedure, some session-related settings are part of the configuration of the procedure. The two most common problems with this are related to ANSI_NULLS and QUOTED_IDENTIFIER. When procedures are scripted, SQL Server tools also script the settings for the session, but what often happens is that the person creating ...