Hi, All
During my SQL 2000 upgrading test, I got an error message:
Error running script: sp_vupgrade_replication(1)
I look at sp_vupgrade_replication.out, here is message:
Upgrading publication settings and system objects in database [model].
Upgrading publication settings and system objects in database
[Northwind].
Upgrading publication settings and system objects in database [pubs].
Msg 21376, Level 11, State 1, Server SMSZZZ, Procedure sp_vupgrade_publisher, Line 79
Could not open database [SMS_ZZZ]. Replication settings and system
objects could not be upgraded. If the database is used for
replication, run sp_vupgrade_replication in the [master] database when
the database is available.
Upgrading subscription settings and system objects in database
[model].
Upgrading subscription settings and system objects in database
[Northwind].
Upgrading subscription settings and system objects in database [pubs].
Msg 21373, Level 11, State 1, Server SMSZZZ, Procedure sp_vupgrade_subscription_databases, Line 42
Could not open database [SMS_ZZZ]. Replication settings and system
objects could not be upgraded. If the database is used for
replication, run sp_vupgrade_replication in the [master] database when
the database is available.
this SQL server 7.0 standard edition upgrade to SQL 2000 enterprise, the server is SMS site server with SMS_sitecode database, it seem the server with publishing configured (on EM, tools, replication, disable publishing is in dark), anyone see this type message before? search MS site but not much help.
thanks!!