SQL Server Performance

NOT FOR REPLICATION Option for Snapshot only?

Discussion in 'Performance Tuning for SQL Server Replication' started by essamughal, Feb 28, 2005.

  1. essamughal New Member

    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

Share This Page