August 1, 2005 at 2:29 pm
Hello,
I just did an upgrade from Sql Server 6.5 to 2000 using the migration
wizard.
I don't know if it had anything to do it. But now when I try to look at the
alerts or create jobs in 2000 I get this error message:
Error 207: Invalid column name 'job_id'
Invalid column name'category_id'
""
How can I resolve this? Thanks very much.
Are there any other issues that I should be concerned with after the
migration?
Thanks.
August 3, 2005 at 4:46 am
Hello,
I don't know an answer strict to your question. I had myself, months ago, problems with upgrading from 6.5 to 2000. And I found that wery few were 'in my shoes', since SQL 7 was on the market 'years' ago.
The short story is this: I 'transfered' the tables and reviewed the procedures.
Important:
1. I was not bound to transfer the logins & passwords!
2. You should not apply any SPs. Although the sp4 was not released and 'maybe' works...
Good luck,
E. Ionescu
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply