Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Dear all,
I want to add a new server as a publisher to an existing distributor,
but each time I try, I get this error:
Could not find stored procedure 'dbo.sp_MS_replication_installed'.
I also tried making this machine it's own distributor, but the same
error comes up.
Thanks in advance.
Aramid
Reapply the latest sp. There seems to be a problem with the sp setup program
where it drops all the replication related procs, but somehow occasionally
forgets to reinstall them.
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
"Aramid" <aramid@.hotmail.com> wrote in message
news:cs5sl1lm2mh8bso89aujduaii1gjpovpn4@.4ax.com...
> Dear all,
> I want to add a new server as a publisher to an existing distributor,
> but each time I try, I get this error:
> Could not find stored procedure 'dbo.sp_MS_replication_installed'.
> I also tried making this machine it's own distributor, but the same
> error comes up.
> Thanks in advance.
>
> Aramid
|||Thanks so much Hillary, I will try this one.
Aramid
On Tue, 25 Oct 2005 11:05:45 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>Reapply the latest sp. There seems to be a problem with the sp setup program
>where it drops all the replication related procs, but somehow occasionally
>forgets to reinstall them.