Upgrading SQL 7.0 to SQL 2000  
Author Message
MohammadSH





PostPosted: Fri Oct 03 13:56:13 CDT 2003 Top

SQL Server >> Upgrading SQL 7.0 to SQL 2000

I have a SQL 7.0 server, when I run the upgrade to SQL
2000 I get the following error, "error running script:
message.sq1 (1)". Any thoughts?

JP

SQL Server290  
 
 
hk





PostPosted: Fri Oct 03 13:56:13 CDT 2003 Top

SQL Server >> Upgrading SQL 7.0 to SQL 2000 Hi, I've been working the same issue most of the morning.
I'm upgrading my SQL Server from SQL7.0 to SQL2000 and
have recv'd to same error msg. Some indication points me
to location of the upgrade.sql script used during the
upgrade process where it is erroring at a point of
procedure sp_msupg_upgradecatalog detected inconsistent
versioning!

We use Full Text catalogs in our DB's. Sorry I'm not much
help. I will post if I come across a solution. My next
step will be to restore back to 7.0 and disable cataloging
then re-run the upgrade. See what happens I guess.


>-----Original Message-----
>I have a SQL 7.0 server, when I run the upgrade to SQL
>2000 I get the following error, "error running script:
>message.sq1 (1)". Any thoughts?
>
>JP
>.
>