SYMPTOMS
After you install the Microsoft Systems Management Server (SMS) 2003 site database on Microsoft SQL Server 2005, you may receive the following site server status error message:
Type Milestone
Severity: Warning
Message ID : 619
ProcessID: 722
Trhead ID: 6344
Component: SMS_STATUS_MANAGER
Microsoft SQL Server reported SQL message 102, severity 15:
[42000][102][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
'd'. : sp_InsStatusMessageAttribute
Additionally, new site status messages are not inserted into the site database. The Inboxes\Statmgr.box\Retry folder contains a backlog of .sql files.
The Statmgr.log file may contain the following entries:
*** exec sp_InsStatusMessageAttribute 63,14176,402,'CCP00013','date
time',14177,402,'sitecodecollection increment number','date
time',14178,402,'sitecodecollection increment number','datetime',14179,402,'sitecodecollection increment number','date
time',14180,402,'sitecodecollection increment number,'date
time',14181,402,'sitecodecollection increment number','date
--Entries omitted for space--
time',14236,402,'SMScollection ID',' date
time' SMS_STATUS_MANAGER date time 4144 (0x1030)
*** [42000][102][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax
near 'd'. : sp_InsStatusMessageAttribute SMS_STATUS_MANAGER date time 4144 (0x1030)
ERROR: Could not add a SQL command to the transaction. Most likely, there is a
problem with the SQL server or our connection to it. The transaction will be
rolled back. SMS_STATUS_MANAGER date time 4144 (0x1030)
Note To install the SMS 2003 site database on SQL Server 2005, you must have SMS 2003 Service Pack 2 installed.