Update:
My first impulse was to rebuild the master database.
However, after some research I found that the master database was missing
the following stored-procedures:
sp_get_distributor
sp_helpreplicationdboption
sp_MS_replication_installed
sp_MSinstance_qv
I created new versions of these in the master db from another server and
marked them all as system objects and it's all working fine now.
As to why these procs were missing in the first place - unknown.
[quoted text, click to view] "David Sullivan" wrote:
> Hi,
> I have an unusual problem.
> In short, the Transactional Replication option in the Create and Manager
> Publications wizard is greyed out (ie: not available at all).
>
> Ther server is SQL 2000 server, output of select @@version below:
>
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
> I have previously setup transactional replication from this server to
> another server with a remote distributor.
> On that occasion we rolled-back by removing the subscription and publication.
> At no stage did I disable publication on either server.
>
> Recently, I attempted to setup transactional replication again.
> On this occasion I got this error when selecting Tools-Configure Publishers,
> Subscribers and Distribution:
> Could not find stored procedure sp_get_distributor.
>
> Undaunted, I persevered and created a new copy of this proc (from another
> enterprise edition server) in the master database and marked it as a system
> object.
> I was then able to successfully configure distributors etc.
>
> Now, when running the Create and Manage Publications wizard the
> Transacational Replication option is not available. I've tried just about
> everything apart from manaully running sp_addpublication.
>
> Any insights greatly appreciated.
