Thursday, March 8, 2012

Could not find stored procedure ''?

Hi
I recently recovered my SQL2000 Sp3 Merge Replication structure from a
failure after adding a few new articles to my publication. Everything was
going fine (getting everyone up again), until I noticed 5 out of the 100
sites with the following problem:
The merge process could not retrieve column information for table
'dbo.C_ClaimStatus'.
(Source: Merge Replication Provider (Agent); Error number: -2147201016)
Could not find stored procedure ''.
(Source: DAYMED\CC (Data source); Error number: 2812)
I tried re-initialising these subcriptions again, but the problem stayed.
What bugs me is that all my sites were restarted in exactly the same way
(re-initialise site with a pre and post snapshot script to run) and these
are the only 5 sites with this problem.
(All sites are running MSDE sp3 or SQL2000 sp3 and are pull subscriptions)
Has anybody had this before, and if so, how do I fix this?
Regards
Paul Kleynhans
Paul,
This may be due to a failed sp installation. Reapplying sp3a may fix it and
to get a bit more info, have a look at sqlsp.log file from the c:\windows
directory - this might shed some light on any failed actions during the sp
installation.
Regards,
Paul Ibison

No comments:

Post a Comment