Solved

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

Posted on 2006-10-21
2
655 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:aduboisintech
2 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 250 total points
ID: 17783456
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.
0
 

Author Comment

by:aduboisintech
ID: 17783591
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.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now