Hello,

While generating Intial snapshot all scripts are
keeping SET Quoted_Identifiers ON where my default setting
is OFF and I want to keep it OFF...How can I do it for
Replication.

Thanks

Expand your publisher database in EM, Right click on your
publication and select explore snapshot folder. Locate
all pertinent scripts and change the SET QUOTED_IDENTIFIER
ON to OFF for all pertinent scripts here.

You can use perl to do this.

Perl -p -i.bak -e "s/SET QUOTED_IDENTIFIER ON/SET
QUOTED_IDENTIFIER OFF/g" filename.txt"

[quoted text, click to view]