hi

i have a merge publication which is then republished at the subscriber with trans publication. i am now impementing indexed views at both subscribers, and though it is ok with trans, the merge replciation fails when delievering records with the following error:

The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
---------------------------------------------------------------------------------------------------------------
DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS.'.
(Source: xxxx(Data source); Error number: 1934)
---------------------------------------------------------------------------------------------------

I now about the ANSI settings:
ARITHABORT : ON
CONCAT_NULL_YIELDS_NULL : ON
QUOTED_IDENTIFIER : ON
ANSI_NULLS : ON
ANSI_PADDING : ON
ANSI_WARNINGS : ON
NUMERIC_ROUNDABORT : OFF

I tried recreating the base table with these options & ran the update statement with them set & still failed (though recreating isnt an option anyway since they are live dbs)

how can i specify what ANSI setting the merge agent connects with?
of is their another solution??

any hlp much apprec.
thx
des