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

"Ernesto" <mathematicus@yahoo.com> wrote in message news:<kdOdnfRu4PPlCYfcRVn-jA@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

I have no idea, but if you want to know what Enterprise Manager is
doing, then you can use Profiler to trace the TSQL it uses to create
the subscription. If that doesn't help, then you might want to
consider posting in microsoft.public.sqlserver.replication.

Simon