"Rob Gilchrist" <anonymous@discussions.microsoft.com> wrote in message
news:BB606C10-520E-4164-8441-469B517FCA23@microsoft.com...
> Hi
> We have recently applied SP3a to two of our SQL SERVER 2000 servers. Both

>
> Once SP3a was installed the replication failed with the error message
>
> Could not find stored procedure 'sp_mergemetadataretentioncleanup'.
>
> On closer inspection there are approximately 30 Stored Procedures missing

>
> Does anybody know how I can replace these SP's or find out why they where
deleted?
>
> Cheers
> Rob
>
>
> sp_createmergepalrole
> sp_execresultset
> sp_getqueuedarticlesynctraninfo
> sp_getsqlqueueversion
> sp_mergemetadataretentioncleanup
> sp_MSchunkgeneration
> sp_MScleanup_zeroartnick_genhistory
> sp_MScreatedupkeyupdatequery
> sp_MSdelete_specifiedcontents
> sp_MSenumschemachange_80sp3
> sp_MSfixupbeforeimagetables
> sp_MSgetmakegenerationapplock
> sp_MSisnonpkukupdateinconflict
> sp_MSispulldistributionjobnamegenerated
> sp_MSispullmergejobnamegenerated
> sp_MSpurgecontentsorphans
> sp_MSreleasemakegenerationapplock
> sp_MSrepl_FixPALRole
> sp_MSrepl_PAL_rolecheck
> sp_MSscriptdelconflictfinder
> sp_MSscriptinsertconflictfinder
> sp_MSscriptupdateconflictfinder
> sp_MSscriptviewproc
> sp_MSsethighestversion
> sp_MSupdate_mqserver_distdb
> sp_MSupdate_mqserver_subdb
> sp_populateqtraninfo
> sp_repldeletequeuedtran
> sp_replincrementlsn
> sp_replpostsyncstatus
> sp_replscriptuniquekeywhereclause
> sp_replsetoriginator
> sp_replsetoriginator_pal
> sp_repltablehasnonpkuniquekey
> sp_script_insertforcftresolution
> sp_scriptdynamicupdproc
> sp_scriptpublicationcustomprocs
> sp_scriptpubwinsrefreshcursorvars
> xp_execresultset
>
>
>
>
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:uc6OujuzDHA.2180@TK2MSFTNGP12.phx.gbl...
> I've seen this myself. It is most troubling. Everyone blamed me.
>
> We fixed it by re-applying the sp.
> "Rob Gilchrist" <anonymous@discussions.microsoft.com> wrote in message
> news:BB606C10-520E-4164-8441-469B517FCA23@microsoft.com...
> > Hi
> > We have recently applied SP3a to two of our SQL SERVER 2000 servers.
Both
> machines are running on Win 2000 and neither had any previous Service
Packs
> applied. Both machines are Publishers in merge replication.
> >
> > Once SP3a was installed the replication failed with the error message
> >
> > Could not find stored procedure 'sp_mergemetadataretentioncleanup'.
> >
> > On closer inspection there are approximately 30 Stored Procedures
missing
> from the master DB's on both machines, compared to a successfully patched
> SQL Server. The following is a list of some of the SP's that are missing.
> >
> > Does anybody know how I can replace these SP's or find out why they
where
> deleted?
> >
> > Cheers
> > Rob
> >
> >
> > sp_createmergepalrole
> > sp_execresultset
> > sp_getqueuedarticlesynctraninfo
> > sp_getsqlqueueversion
> > sp_mergemetadataretentioncleanup
> > sp_MSchunkgeneration
> > sp_MScleanup_zeroartnick_genhistory
> > sp_MScreatedupkeyupdatequery
> > sp_MSdelete_specifiedcontents
> > sp_MSenumschemachange_80sp3
> > sp_MSfixupbeforeimagetables
> > sp_MSgetmakegenerationapplock
> > sp_MSisnonpkukupdateinconflict
> > sp_MSispulldistributionjobnamegenerated
> > sp_MSispullmergejobnamegenerated
> > sp_MSpurgecontentsorphans
> > sp_MSreleasemakegenerationapplock
> > sp_MSrepl_FixPALRole
> > sp_MSrepl_PAL_rolecheck
> > sp_MSscriptdelconflictfinder
> > sp_MSscriptinsertconflictfinder
> > sp_MSscriptupdateconflictfinder
> > sp_MSscriptviewproc
> > sp_MSsethighestversion
> > sp_MSupdate_mqserver_distdb
> > sp_MSupdate_mqserver_subdb
> > sp_populateqtraninfo
> > sp_repldeletequeuedtran
> > sp_replincrementlsn
> > sp_replpostsyncstatus
> > sp_replscriptuniquekeywhereclause
> > sp_replsetoriginator
> > sp_replsetoriginator_pal
> > sp_repltablehasnonpkuniquekey
> > sp_script_insertforcftresolution
> > sp_scriptdynamicupdproc
> > sp_scriptpublicationcustomprocs
> > sp_scriptpubwinsrefreshcursorvars
> > xp_execresultset
> >
> >
> >
> >
> >
> >
>
>