Link to home
Start Free TrialLog in
Avatar of aduboisintech
aduboisintech

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of Nightman
Nightman
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of aduboisintech
aduboisintech

ASKER

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.