Unable to run script sp_helparticle or sp_????article on a merge publication

aduboisintech
aduboisintech used Ask the Experts™
on
When trying from EM to execute sp_helparticle or sp_droparticle, the result is :
'syspublications : invalid object name.'
I have no syspublications table
I ran a script to generate it, but is still empty.
How can I make those script run ?
I have a dedicaded W2K3 server with SQL2000 and from replication (merge) a W2K with MSDE (all latest sp applied).
Any help appreciated
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
What SP version are you running?

There are documented instances of the latest SP not being applied correctly, resulting in missing stored procedures (e.g. sp_MSestimatesnapshotworkload). To identify missing procedures you can run SQL Profiler and see what the process is trying to execute.

Alternatively, re-apply the latest service pack, and all subsequent hotfixes.

Author

Commented:
I have already re-applied the sp4 on sql2k, but I found what was wrong, the sp_helpmergearticle is to be used since it's a merge publication. all the procedures to be used are sp_???mergearticle.
Have a good day.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial