>>Dan,
>>
>>SET ANSI_NULL is for the current session. To set ANSI NULL option for DB use sp_dboption system stored procedure.
>
>Thanks for the quick response Sergey!
>
>That worked. Sort of, DATABASEPROPERTYEX([database],'IsAnsiNullsEnabled') now returns 1, but the Merge Agent still returns an error that "SET options have incorrect settings 'ANSI_NULL'" I think this must mean that the agent is still connecting to the subscriber with ANSI_NULL OFF.
>
>Well, the next thing I can try is re-creating the publication, but that will have to wait for the weekend.
Didn't play with replication yet so cannot help ypu.
--sb--