-
Title
"Failed to execute initialization procedure X:sql server_spotlight$work database:- SQL Server Error -
Description
When trying to monitor a SQL Server instance in Spotlight with a discrepancy in compatibility between databases (Master and Networked), for example compatibility changed from 90 to 80. A Connection is set up but an alarm is raised with below error:
'Severity Alarm Raised Message:
High: SQL Server instance date time SQL Server instance is in an unscheduled outage: Failed to execute initialization procedure X_sql server:sql server_spotlight$work database:- SQL Server Error(102) Incorrect syntax near .. SQL Server Error(102) Incorrect syntax near ..' -
Resolution
First check for database compatibility using the stored procedure sp_dbcmptlevel
sp_dbcmptlevel DatabaseName
To change compatibility level, run
sp_dbcmptlevel DatabaseName, 90/80
Recreate the connection to the instance.