ConfigMgr 2007: Status Message 2407 in SMS_SQL_MONITOR after upgrade from SMS 2003

Issue: After upgrading from SMS 2003 SP2 or SP3 to the Select version of Configuration Manager 2007 SP1, you may see the following status message:

SMS_SQL_MONITOR_SiteServer - 2407    SMS SQL Monitor failed to install trigger "SQLTaskStatus_upd" in the SMS site database.   
Possible cause: Either table "SQLTaskStatus" or column "TaskName,TaskType" of table "SQLTaskStatus" does not exist in the SMS site database. 
Solution: If you modified table "SQLTaskStatus", restore it to its original, unmodified state.   
Possible cause: SQL Server problem. 
Solution...

Continue reading at our new blog - http://www.dario.co.il/blog/?p=367