CONCAT_NULL_YIELDS_NULL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


hi there,
is there a way to set CONCAT_NULL_YIELDS_NULL to off for all the connections? thanks!
alter database is ok. some other ideas?
As far I know the only choise is via sp_dboption, but wait for others members oppinions. Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.
What is the problem with setting this option to ON.
BOL recommends:
SET CONCAT_NULL_YIELDS_NULL must be ON when creating or manipulating indexes on computed columns or indexed views. If SET CONCAT_NULL_YIELDS_NULL is OFF, CREATE, UPDATE, INSERT, and DELETE statements on tables with indexes on computed columns or indexed views will fail. For more information about required SET option settings with indexed views and indexes on computed columns, see Considerations When Using SET Statements in SET topic.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.