I tried to follow the steps.
And was able to Upgrade the SQL6.5 to SQL2000.
I'm having issues with logins, that need to be migrated from the 6.5 to 2000.
1.As there is not a Sp_help_revlogin script, for login trasfer between 6.5 to 2000. I'm not able to migrate the logins.
2.Since, I have been able to Upgrade the DB's succesfully. I went ahead with the next step, to migrate it over to SQL2005.
I took the 2000 Backup and tried it on to 2005. It restored ok, but after restore, the DB comes with a message ( Pubs( SQL 6.5 Compatible)) and
the Database is completely unavailable. I cant do anything on it.
i.e: when I right click on the DB the options are greyed out.
And there is no expand(+) option.
Is there a reason for this?