I'd like to set ANSI NULLs and quoted identifier properties on a stored procedure after it has been created. Is this possible?
For some context, I'm using Visual Studio Database Projects / SSDT, and it appears these values can only be set at the database level, not on the procedure level. However, we're using an existing database with inconsistently created procedures, so I'd like to preserve the current behavior until we can normalize them.
Best Answer
Haven't tested this on other versions of Visual Studio, but with version 12.0.3 (Update4) there is an option to override the ANSI Nulls config at the database-level specification for a single procedure in an SSDT project.
Just right-click the procedure in solution explorer and choose properties...