Microsoft SQL Server forum - 6.5 to 2000 upgrade problems

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

6.5 to 2000 upgrade problems

ozpom

2006-01-23, 11:24 am

Hi there,

I'm looking into upgrading a client's 6.5 databases to 2000. I have two
VMs, one running Windows NT4 and SQL Server 6.5, the other Windows
Server 2003 and SQL Server 2000. I've got the upgrade wizard running
fine over the network but it's getting errors and I can't see why.

The errors are:
- Invalid column name (when the column is definitely in the 6.5 table)
- Invalid object name (when granting EXECUTE on a stored procedure
which exists in the 6.5 database)
- Granted privilege EXECUTE is not compatible with object (on a
trigger)

I'm also getting an "Access is denied" message from Export.exe

I'm very new to SQL Server and I'm learning everything as I go along so
forgive me if this is a dumb question but does anyone have any idea
what I've done wrong?

Cheers

Oz

Sponsored Links