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)

How to Change Publication on Local Network to Publish on Internet

Please Help me with this problem , I am working with merge replication , i
have got publication for local network and i want to chage it to publish the
articles on internet without creating new publication.
Please Reply
Thanks
Abulla Fatiya
drop all subscriptions
run the below script - change the name of pubs5 to your publication name
sp_changemergepublication 'pubs5','allow_pull','true'
go
sp_changemergepublication 'pubs5','allow_anonymous','true'
go
sp_changemergepublication 'pubs5','alt_snapshot_folder','c:\inetpub\ftproot'
go
sp_changemergepublication 'pubs5','compress_snapshot','true'
go
declare @.str varchar(200)
set @.str='sp_changemergepublication
''pubs5'',''ftp_address'',''ftp://'+@.@.ServerName+''''
print @.str
exec (@.str)
go
sp_changemergepublication 'pubs5','ftp_port','21'
go
sp_changemergepublication 'pubs5','ftp_subdirectory','ftp'
go
sp_changemergepublication 'pubs5','ftp_login','anonymous'
go
sp_changemergepublication 'pubs5','ftp_password','password'
go
sp_changemergepublication 'pubs5','enabled_for_internet','true'
go
sp_changemergepublication 'pubs5','snapshot_ready','true'
go
Hilary Cotter
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
"Fatiya" <Fatiya@.discussions.microsoft.com> wrote in message
news:7464DC4B-3760-4DD2-95E3-280ACB8E898C@.microsoft.com...
> Please Help me with this problem , I am working with merge replication , i
> have got publication for local network and i want to chage it to publish
the
> articles on internet without creating new publication.
> Please Reply
> Thanks
> Abulla Fatiya
>
>
|||Fatiya,
my comments re VPN are OK, but Hilary's change script is
extremely neat and avoids the need for reinitialization,
so please disregard my later comments.
Rgds,
Paul Ibison

>--Original Message--
>drop all subscriptions
>run the below script - change the name of pubs5 to your
publication name
>sp_changemergepublication 'pubs5','allow_pull','true'
>go
>sp_changemergepublication 'pubs5','allow_anonymous','true
'
>go
>sp_changemergepublication 'pubs5','alt_snapshot_folder','
c:\inetpub\ftproot'
>go
>sp_changemergepublication 'pubs5','compress_snapshot','tr
ue'
>go
>declare @.str varchar(200)
>set @.str='sp_changemergepublication
>''pubs5'',''ftp_address'',''ftp://'+@.@.ServerName+''''
>print @.str
>exec (@.str)
>go
>sp_changemergepublication 'pubs5','ftp_port','21'
>go
>sp_changemergepublication 'pubs5','ftp_subdirectory','ftp
'
>go
>sp_changemergepublication 'pubs5','ftp_login','anonymous'
>go
>sp_changemergepublication 'pubs5','ftp_password','passwor
d'
>go
>sp_changemergepublication 'pubs5','enabled_for_internet',
'true'
>go
>sp_changemergepublication 'pubs5','snapshot_ready','true'
>go
>--
>Hilary Cotter
>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
>"Fatiya" <Fatiya@.discussions.microsoft.com> wrote in
message
>news:7464DC4B-3760-4DD2-95E3-
280ACB8E898C@.microsoft.com...[vbcol=seagreen]
merge replication , i[vbcol=seagreen]
chage it to publish
>the
>
>.
>