Vlad Drumea changes some settings:
You might have noticed when scripting out stored procedures in SSMS that it prepends two SET options before the CREATE PROCEDURE statement.
These are:
- ANSI_NULLS
- QUOTED_IDENTIFIER
Read on to learn more about how these behave and why it’s important to set them in a specific way.