Post SP3 ERROR

upgraded a server last night to SP3 and all of my push subscriptions
disappeared, but all the publications remained. When I go to recreate
them, the push subscriptions, I receive the following message...
Error 2812: Could not find stored procedure
'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
Distributor or the distribution database for the local server. The
Distributir may not be installed, or the local server may not be
configured as a Publisher at the Distributor.
What does this mean? Can I create the push subscriptions?
TIA,
Larry...
Is this proc in the distribution database? Can you post your sqlsp.log and
your sqlsp.logs here? You can find them in %windir%
Also can you give us some history of your server? Is this the first time you
applied SP 3 to them? What was on these servers before you applied SP3?
This problem occasionally occurs on SQL Servers - I'd like to try to get to
the bottom of it.
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
<lreames@.gmail.com> wrote in message
news:1108653185.903933.16440@.c13g2000cwb.googlegro ups.com...
> upgraded a server last night to SP3 and all of my push subscriptions
> disappeared, but all the publications remained. When I go to recreate
> them, the push subscriptions, I receive the following message...
>
> Error 2812: Could not find stored procedure
> 'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
> Distributor or the distribution database for the local server. The
> Distributir may not be installed, or the local server may not be
> configured as a Publisher at the Distributor.
>
> What does this mean? Can I create the push subscriptions?
>
> TIA,
> Larry...
>
|||Hilary,
You responded to me via email, this was a repost.
Larry....