The other day I had an issue with sql 2005 running on Server 2008 cluster. This was a new cluster that was recently updated from RTM to SP3. After SP3 was applied you could no longer view or create any Maintenance Plans. The error in SSMS was that two columns were invalid from_msx and has_targets. After some research this seems to be fairly common but the work around was difficult to find. What I found was that these two new columns are added to msdb.dbo.sysmaintplan_plans. It seems that on a Server 2008 cluster the SP3 installer does not run the sysdbupg.sql script located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install folder. After manually running the script I was then able to fully utilize the maintenance plan feature in SSMS.
Of course this wasn’t the end of it and another issue sprang up. Once the maintenance plans were created the agent jobs gave an error. The message was that the SSIS subsystem failed to load. In order to fix this I ran the following code.
use msdb
go
delete from msdb.dbo.syssubsystems
exec msdb.dbo.sp_verify_subsystems 1
go
-Jeremy
no comment untill now