SAP ABAP Message Class SMMSS_ALERTS Message Number 016 (This alert shows a configuration required in SQL Server has not been done)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-MSS (Application Component) Microsoft SQL Server
     STUN_MSS (Package) Package for new SQL Server monitoring objects
Attribute
Message class SMMSS_ALERTS  
Short Description Message class for MSSQL rz20 messages    
Message Number 016  
Documentation status       Space: object requires documentation
Authorization check Error Message      
Changed On 20130531   
Message Text
This alert shows a configuration required in SQL Server has not been done
Help Document

Diagnosis

This alert will show a variety of messages depending upon the monitored SQL Server setup conditions.

System Response

Procedure

You can use query analyzer to look at stored procedure sap_mon_sqlsetup. This stored procedure checks SQL Server settings that the SAP development group working on the port to SQL Server deems important. A text string, along with a flag of "Y' for yellow or "R' for red is returned to the SAP server. This stored procedure checks database server settings only.

Procedure for System Administration

History
Last changed on/by 20130531  SAP 
SAP Release Created in