November 27, 2005 at 8:34 pm
Hi i was wondering how i can change the property of allowing anonymous subscriptions.
ive been up and down bol for a sp that would help, but so far no luck?
would i need to drop and create the publication to set this option.?
Thanks ladies and gents for any help you can provide.
------------------------------
Life is far too important to be taken seriously
November 30, 2005 at 8:00 am
This was removed by the editor as SPAM
November 30, 2005 at 12:11 pm
In Enterprise Manager, Expand the replication folder and publications folder on the publisher. Right click on the publication and select properties. On the Subscription Options tab uncheck the "allow Anonymous Subscriptions" option.
Mark
November 30, 2005 at 2:41 pm
Exec sp_changepublication
@publication = 'yourpublication'
,@property = 'allow_anonymous'
,@value = 1
,@force_invalidate_snapshot = 1
,@force_reinit_subscription = 1
The key is to look at the @Property parameter value, in this case you want to change the allow_anonymous value from "true" to "false" or vice versa. This value has a bit mask of 1 0r 0 simply execute this stored procedure setting the @paublicaiton parameter value to 1 or 0 and you should be fine.
November 30, 2005 at 2:57 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply