Replication question

Using the "Pull New Subscription" wizrd in the enterprise manager, I can
create a subscription without a problem.
Howwever using TSQL I cannot do the same thing:
Using this sequence:
sp_addSubscription (on publisher)
sp_addPullSubscription (on subscriber)
sp_addPullSubscription_Agent (on subscriber)
The error I get is:
the "Subscription is not active"
Any hints on what I'm doing wrong will be most appreciated
when you created your publication you have to set @.status='active'
to check to see if you forgot to do this, expand your database, right click
on your publication and see if the push new susbcription menu option is
enabled.
If it is disabled do this
sp_changepublication 'publicationname','status','active'
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Ernesto" <mathematicus@.yahoo.com> wrote in message
news:4v2dnTB4KNHDF4bcRVn-jw@.speakeasy.net...
> Using the "Pull New Subscription" wizrd in the enterprise manager, I can
> create a subscription without a problem.
> Howwever using TSQL I cannot do the same thing:
> Using this sequence:
> sp_addSubscription (on publisher)
> sp_addPullSubscription (on subscriber)
> sp_addPullSubscription_Agent (on subscriber)
> The error I get is:
> the "Subscription is not active"
> Any hints on what I'm doing wrong will be most appreciated
>
>
|||As I check the status is saya that it is active. yet I still get the error
when doing things via VB code/
Is there any kind of detail I can provide that may halp figure this out?
Thanks for your help
ps too bad your book is not available now!
|||what is the error number you are getting?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Ernesto" <mathematicus@.yahoo.com> wrote in message
news:4bOdnd3Jr_C8e4bcRVn-pA@.speakeasy.net...
> As I check the status is saya that it is active. yet I still get the error
> when doing things via VB code/
> Is there any kind of detail I can provide that may halp figure this out?
> Thanks for your help
> ps too bad your book is not available now!
>