SQL Server Performance Forum – Threads Archive
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
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
What is the problem with setting this option to ON.
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.