Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2013

    Unanswered: 2012 replication

    I have created a publication but when I try to synchronize i get the following error: Insert failed because the following SET options have incorrect settings: 'ANSI_PADDING'. (Source: MSSQLServer, Error number: 1934)
    When I look into the unc directory the files have Ansi_Padding ON for each table. I have dropped and recreated the publications and subscriptions many times. I installed sp1 over the weekend thinking that might solve my situation. There are not any columns with XML data, there are a few columns with varchar(max) but they are not over 250 characters.
    Last edited by shaleah; 03-05-13 at 08:25.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts