Missing replication stored procedure in msdb

[NathanGriffiths]

I've trying to configure a SQL Server 2000 SP4 standard edition for replication to act as a publisher and distributor. When I use the new publication wizard to create the publication I get an error:

Could not find stored procedure 'msdb.dbo.sp_add_jobstep_internal'.

I've looked about on the internet and it appears this proc was added during a service pack (possibly SP3). The server was set up by a third party and I think it was originally RTM and they have applied subsequent service packs to it up to SP4. I suspect something may have gone wrong with the service pack updates, but I don't know a way to fix up missing system objects as there could also be problems with the schema as well. Will re-running SP4 update fix the problem? Any help much appreciated!

cheers, Nathan

 

[mrdenny]

Rerunning the SP4 installer will probably fix the issue.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[NathanGriffiths]

thanks denny, I'll let you know how we get on.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com