We can use the SQL execution plan to view the current value of QUOTED_IDENTIFIER. Verify QUOTED_IDENTIFIER in the SSMS execution plan You should be careful about modifying this option in the production environment. Note: If we change the QUOTED_IDENTIFIER option SSMS tools, it turns off the QUOTED_IDENTIFIER for all client session. In the below screenshot, we can see that it has QUOTED_IDENTIFIER OFF now: If we want to turn off QUOTE_IDENIFIER, we can remove the tick from the checkbox:Д¬lick OK and restart the SSMS so that this setting can take effect. It is the default behavior of SQL Server: In this screenshot, we can see it has an option SET QUOTED_IDENTIFIER, and it is enabled. Search for keyword ANSI, and it gives you settings to control query execution behavior. It also has a search option in that we can filter out the required configuration. It gives various options to control SSMS behavior such as environment details, query execution, query results behavior: We can control this behavior using SSMS settings. Later, we generated the script, and it includes SET QUOTED_IDENTIFIER ON option.

SSMS property to control QUOTED_IDENTIFIERДЄt the beginning of the article, we created a new stored procedure without specifying QUOTED_IDENTIFIER.

Turn off keywords everywhere