I am running SQL 2005 standard SP2 and I cannot save maintenance plans. Using the wizard I create the plan but it always fails with the following error messages:
An exception occurred while executing a Transact_SQL statement or batch
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server , Error: 207)
Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error: 207)
Thanks
Todd
The column names you mention were added in SP2. This indicates that there is a mix of SP2 and earlier functionality involved in this problem.
Bring all elements up to SP2. If you have done so already, inspect installler logs to see if sp2 setup ran without error.
Good luck,
jkh
No comments:
Post a Comment