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
Aramid,
Does the proc exist?
Try:
USE MASTER
GO
IF OBJECT_ID('SP_MS_REPLICATION_INSTALLED') IS NULL
PRINT 'PROC NOT INSTALLED'
ELSE
PRINT 'PROC INSTALLED'
Also, you may want to post this to:
http://www.microsoft.com/technet/com...replica tion
HTH
Jerry
"Aramid" <aramid@.hotmail.com> wrote in message
news:6t8sl19hf5c6mbgphm3nubjhim3b6ncg7b@.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

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.

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.
AramidAramid,
Does the proc exist?
Try:
USE MASTER
GO
IF OBJECT_ID('SP_MS_REPLICATION_INSTALLED')
IS NULL
PRINT 'PROC NOT INSTALLED'
ELSE
PRINT 'PROC INSTALLED'
Also, you may want to post this to:
http://www.microsoft.com/technet/co...ver.replication
HTH
Jerry
"Aramid" <aramid@.hotmail.com> wrote in message
news:6t8sl19hf5c6mbgphm3nubjhim3b6ncg7b@.
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

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.
AramidAramid,
Does the proc exist?
Try:
USE MASTER
GO
IF OBJECT_ID('SP_MS_REPLICATION_INSTALLED') IS NULL
PRINT 'PROC NOT INSTALLED'
ELSE
PRINT 'PROC INSTALLED'
Also, you may want to post this to:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.replication
HTH
Jerry
"Aramid" <aramid@.hotmail.com> wrote in message
news:6t8sl19hf5c6mbgphm3nubjhim3b6ncg7b@.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