POSTING IT AGAIN TO RESOLVE THE ERROR

Hi,
When i use the "sp_copysubscription" procedure, i am getting the following
error.
"Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line
64
The subscription(s) to Publisher 'CNS_SQL1' does not allow subscription copy
or it has not been synchronized.".
My subscription datbabase contains only PULL subscription.It worked
previously and now started to give the above error.
Any help would be appreciated?
NOTE:
I do have anonymous pull subscription.
Copy subscription was working earlier and it is not now.
How to enable my publication for the copy subscription option?
Thanks,
Vijay
just for kicks, lets try this, go to your subscription database which you
pulled using anonymous authentication. Run the merge agent until it stops or
stop and start it until it goes idle, then stop it again.
Then start up profiler to trace the commands.
Then right click on your database in EM, select all tasks, and copy
subscription database. Does it work now? Does profiler give a different set
of parameters than what you are using?
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
"Vijay" <vijay@.infosysusa.com> wrote in message
news:%23L$h4jWNFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When i use the "sp_copysubscription" procedure, i am getting the following
> error.
> "Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line
> 64
> The subscription(s) to Publisher 'CNS_SQL1' does not allow subscription
copy
> or it has not been synchronized.".
> My subscription datbabase contains only PULL subscription.It worked
> previously and now started to give the above error.
> Any help would be appreciated?
> NOTE:
> I do have anonymous pull subscription.
> Copy subscription was working earlier and it is not now.
> How to enable my publication for the copy subscription option?
> Thanks,
> Vijay
>
>
|||No, it doesn't work. I couldn't find any difference in the trace also.
..
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ewB10weNFHA.2136@.TK2MSFTNGP14.phx.gbl...
> just for kicks, lets try this, go to your subscription database which you
> pulled using anonymous authentication. Run the merge agent until it stops
or
> stop and start it until it goes idle, then stop it again.
> Then start up profiler to trace the commands.
> Then right click on your database in EM, select all tasks, and copy
> subscription database. Does it work now? Does profiler give a different
set[vbcol=seagreen]
> of parameters than what you are using?
> --
> 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
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:%23L$h4jWNFHA.1172@.TK2MSFTNGP12.phx.gbl...
following[vbcol=seagreen]
Line
> copy
>
|||what happens if you reinitialize, and resync. Can you do it now?
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
"Vijay" <vijay@.infosysusa.com> wrote in message
news:edD4fDhNFHA.3788@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> No, it doesn't work. I couldn't find any difference in the trace also.
> .
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ewB10weNFHA.2136@.TK2MSFTNGP14.phx.gbl...
you[vbcol=seagreen]
stops[vbcol=seagreen]
> or
> set
> following
> Line
subscription
>
|||Hi,
I reinitialized and resync it. It doesn't help.
Any other ideas?
Thanks,
Vijay
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxnXX2iNFHA.2556@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> what happens if you reinitialize, and resync. Can you do it now?
> --
> 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
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:edD4fDhNFHA.3788@.tk2msftngp13.phx.gbl...
> you
> stops
different[vbcol=seagreen]
sp_copysubscription,
> subscription
>
sql