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

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 (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 Fri Jun 07 14:22:40 2013
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 a SQL Server 2005 database with a service pack level < SP2

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