SQL Server Performance Forum – Threads Archive

NOT FOR REPLICATION Option for Snapshot only?

Hi All; I am working on replication, I just want to do snapshot replication, I have tables which have IDENTITY Columns. Does it require to create the tables manually on Subscriber, right now I am not creating tables at Subscriber and it will be created at the time of replication. My questions are : 1- Should I create tables on Subscriber manually using NOT FOR REPLICATION in create table syntax, I am doing Snapshot replication not transactional or merge? I tried that without NOT FOR REPLICATION but I am getting that Error "Insert Error: Column name or number of supplied values does not match table definition." 2- I have so many tables, so How can I generate a script to create tables with the option NOT FOR REPLICATION automatically. Thanks.
Essa, M. Mughal
Software Engineer

---

]]>