reseting 'allow new subscriptions to be created by attaching..."

1st question: can this value be changed from 'false' to 'true' after a
publication is up and running?
2nd question: can this be accomplished without re-initializing the
subscribers?
3rd question: if #1 & #2 are true what steps must be done to do this?
Note: I have already tried the sp_changeMergePublication sp with no
success:
exec sp_changeMergePublication
@.publication = 'rep_test_hub',
@.property = allow_subscription_copy,
@.value = true
Thanks.
1) I am able to do it with a pull subscription.
2) Yes
3) I ran the same command to allow this.
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
"astro" <astro@.bcmn.com> wrote in message
news:N38Bf.42034$7S.25014@.tornado.rdc-kc.rr.com...
> 1st question: can this value be changed from 'false' to 'true' after a
> publication is up and running?
> 2nd question: can this be accomplished without re-initializing the
> subscribers?
> 3rd question: if #1 & #2 are true what steps must be done to do this?
> Note: I have already tried the sp_changeMergePublication sp with no
> success:
> exec sp_changeMergePublication
> @.publication = 'rep_test_hub',
> @.property = allow_subscription_copy,
> @.value = true
>
> Thanks.
>
|||hummm...time to turn trace on and check the logs i guess...
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%230rE$5IIGHA.1124@.TK2MSFTNGP10.phx.gbl...
> 1) I am able to do it with a pull subscription.
> 2) Yes
> 3) I ran the same command to allow this.
> --
> 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
> "astro" <astro@.bcmn.com> wrote in message
> news:N38Bf.42034$7S.25014@.tornado.rdc-kc.rr.com...
>
|||BTW - you know that after you have enabled this setting, you have to pull
your subscription to another database using an anonymous pull, and then do
the copy subscription database from this subscriber database, right?
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
"astro" <astro@.bcmn.com> wrote in message
news:OlqBf.42145$7S.2470@.tornado.rdc-kc.rr.com...
> hummm...time to turn trace on and check the logs i guess...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%230rE$5IIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>