How to Change Subscriber Status in Merge Publication

Tony,
as a bit of background, what is your requirement? What is
ti you need to achieve by trying to change the status, as
there might be other more straightforward ways of
achieving the same ends.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Paul,
I have a .Net app that handles the creation and deletion of
subscriptions for all my clients. I need to have an administrator using
the application disable a specific user at anytime without having to go
into EM to perform the task.
hope this helps
Thanks!
Tony D
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Tony,
I'm not sure if this is possible using Stored Procs but using DMO there is a
status property of the mergeSubscription object that is read/write. As
you're handling things programatically anyway this should be ok. There's a
reference n BOL
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\sq
ldmo.chm::/dmoref_p_s_4w8i.htm) that might help.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)