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.