Post reply

Replication issue

  • April 11, 2012 at 7:47 am

    #256238

    Can we do replication between already existing tables on different servers??

    I tried to do it...............it deleted the entire table on subscriber?

    I got the error when I tried to view synchronization status on subscription.

    Error: Insert failed because the following SET options have incorrect settings: ANSI_PADDING ....etc

    I don't exactly remember the error .......sorry

  • April 11, 2012 at 10:25 am

    #1472025

    I believe that you have the option to either drop/create or truncate the subscriber table. The error may be related to having DDL triggers in the subscriber database and ansi padding off in the table creation script. We encounter that sometimes and have to disable the triggers or change the script.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply