Hello Kumaran,

I almost have same replication issues when I tried to disable Publishing and Distribution through Wizard in SQL Server 2000.

My replication environment are:

-- Publisher (MS SQL Server 2000 SP3)

-- A remote distributor (MS SQL Server 2008 SP1)

-- A Subscriber (MS SQL Server 2008 SP1)

The first error is

Invalid object name ‘syspublications’

Invalid object ‘syssextendedarticlesview’ (Microsoft SQL Server, Error 208).

Then, I clicked OK.

The second error is

Invalid object name ‘syssubscriptions’ Change database context to ‘master’. (Microsoft SQL Server, Error 208).

I noticed that the MSDB is missing both table [MSdistributiondbs] and [MSdistpublishers]. I applied your suggestion on this forums by adding those missing table in MSDB.

Then, I started to disble Publishing and Distribution via Wizard and got the same errors.

I have spend a lot of time and searched the solutions on internet posting. End up with no luck.

Can anyone help and provide me a solution.

Thanks in advance.

TJ