Tuesday, August 29, 2006

Error message after you install the Systems Management Server 2003 site database on Microsoft SQL Server 2005: "Message ID : 619"

For those of you that have been experiencing a backlog of .sql files in Inboxes\Statmgr.box\Retry and seeing the error below, take a look at KB923116. You will need to call Microsoft Support to get the necessary changes (or take a look at this thread). Microsoft has told me that a hotfix should follow shortly.

*** [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)

No comments: