Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL Server Agent

Author  Topic  g-mny Starting Member 9 Posts Posted - 2000-10-12 : 11:47:12 I Recently upgraded from SQL 6.5 to 7.0, all is well ... Except when I try to use SQL Server Agent. If I try to schedule a new task In SQL Enterprise manager It Produces an "Error 207 Invalid Column Name Catagory_Id....". The SQL Agent service starts with no error messages and nothing shows up in error logs. However, I was able to schedule a backup using the Backup Wizard and that job appears in the list of tasks. If I try to view the properties of the Backup job I get a similar Error 207 message and it won't let me view/modify the job. I also get Error 207 Messages when I try to view Alerts or Operators under SQL Server Agent ... Any Ideas? -g