Posted by ozpom on 01/23/06 17:59

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

• Next in forum: Web based sql server connection
• Prev in forum: Re: Default value: ISNULL()
• Thread view: 6.5 to 2000 upgrade problems

[Reply to this message]