we upgraded to Sql 2008 standard edition last night from 2000 and our replication is now failing, cannot delete it or enter new ones. I found one article saying the following stored procedures need to be run to upgrade the replcation:
however the first one throws and error and the second one seems not to exists. does anyone have any insight into this. or how to delete the replications?
the error from the stored proc sp_vupgrade_replication is :
Upgrading subscription settings and system objects in database [SoxAuditSystem].
Attempting to copy article resolvers from SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\Replication\ArticleResolver
Msg 25026, Level 16, State 1, Procedure sp_registercustomresolver, Line 82
The proc sp_registercustomresolver cannot proceed because it is not run in the context of the distribution database, or the distribution database is not properly upgraded.
View Complete Post