1874931 - Error 'Could not find stored procedure sap_get_freespace' in SAP Solution Manager system

You are monitoring SAP systems based on SQL Server 2005 < service pack 2 with a Solution Manager system and see the following error messages in System Log monitor (transaction SM21) of the Solution Manager system:

SM_EFWK    BY  2 Database error 50000 at OPC
SM_EFWK    BY  0 > Could not find stored procedure
SM_EFWK    BY  0 > 'SAPMonitor.sap_get_freespace'.
SM_EFWK    BY  1 Database error 50000

The developer traces reveal that the error occurs while being connected to the database of one of the monitored systems and contains:

C  ERROR: -1 in function StartSelect (execute)
C  (50000) [42000] [Microsoft][SQL Server Native Client 10.0]
   [SQL Server]Could not find stored procedure 'SAPMonitor.sap_get_freespace
C  dbdsmss: DBSL99 SQL50000
C  Could not find stored procedure 'SAPMonitor.sap_get_freespace'.
B  ***LOG BY2=> sql error 50000      performing OPC  
B  ***LOG BY0=> Could not find stored procedure 'SAPMonitor.sap_get_freespace'.
B  ***LOG BY1=> sql error 50000

An attempt to create stored procedure sap_get_freespace in the remote database fails with:

SQL error  195: 'OBJECT_SCHEMA_NAME' is not a recognized built-in function

SAP Solution Manager

Monitored system is running on Microsoft SQL Server 2005 database with a Service Pack level < SP2

Microsoft SQL Server 2005, SP2, Service Pack 2, Solution Manager, monitoring, DBACockpit, Could not find stored procedure, SAPMonitor.sap_get_freespace, sql error 50000

, KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , How To