Programming Merge Replication Agent using RMO on SQL Server 2000 -- sql server replication

Hilary Cotter
7/4/2006 12:00:00 AM

I don't think so, when I try it I get this message:

"Property \"SubscriberSecurity\" of \"Subscription\" object is only
available for Microsoft SQL Server version 9.0 or later."

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Tomasz Krupa
7/4/2006 1:51:02 AM

Hello,
I've got Publisher, Distributor and Subscriber running on SQL Server 2000.
Is it possible in this case to use MergeSynchronizationAgent class to
synchronize databases? I'm, asking because executing
subscription.SynchronizationAgent.Synchronize();
gives me an error "Procedure or function sp_MShelp_merge_agentid has too
many arguments specified." Is it true that a MergeSynchronizationAgent class
cannot be used with Distributors that are running on SQL Server 2000 ?

sql server replication : Programming Merge Replication Agent using RMO on SQL Server 2000