SMS SQL Monitor failed to execute database maintenance SQL command "%1".%12 Possible cause: The SQL command contains syntax ...

System Center Configuration Manager 2007

%11SMS SQL Monitor failed to execute database maintenance SQL command "%1".%12

Possible cause: The SQL command contains syntax errors.
Solution: Manually execute the command using the Microsoft SQL Server ISQL/w application, and fix any problems you discover. When you are satisfied the command runs successfully in ISQL/w, correct in the SMS Administrator console.

Possible cause: SQL Server problem.
Solution: 
1. Review the immediately preceding status messages from this component about SQL Server errors.
2. Verify that this computer can reach the SQL Server computer.
3. Verify that SQL Server services are running.
4. Verify that SMS can access the SMS site database.
5. Verify that the SMS site database, transaction log, and tempdb are not full.
6. Verify that there are at least 50 SQL Server user connections, plus 5 for each SMS Administrator console.

If the problem persists, check the Smsdbmon.log for SQL Server error logs.%0

SMS SQL Backup service on the SQL server %1 did not start the SMS database backup. SMS SQL Backup service might not be running ... SMS SQL Backup service on the SQL server %1 failed to backup the SMS database %2. The error reported by the service is %3. ... SMS SQL Monitor could not start the SMS Backup service on server %1.%12 Possible cause: You changed the service setting for ... SMS SQL Monitor failed to copy file smsxp.dll from the \SMS\bin\i386 directory (or \SMS\bin\alpha if this is an Alpha computer) ... SMS SQL Monitor failed to execute database maintenance SQL command "%1".%12 Possible cause: The SQL command contains syntax ... SMS SQL Monitor failed to execute database maintenance task "%1".%12 Possible cause: A SQL Server problem prevented this ... SMS SQL Monitor failed to install trigger "%1" in the SMS site database.%12 Possible cause: Either table "%2" or column "%3" ... SMS SQL Monitor is executing database maintenance SQL command/task "%1". You can configure the execution schedule for this ... SMS SQL Monitor is installing trigger "%1" for table "%2" and actions "%3" in the SMS site database. Server components such ...