Solution : https://service.sap.com/sap/support/notes/154844 (SAP Service marketplace login required)
Summary :
During the upgrade from SQL Server 6.5 to 7.0, the STRDBS.CMD file does not update, resulting in startup errors for SQLServerAgent and missing stored procedure 'sap_droptmpproc'. Users encounter error messages within the STDERR1 file and are unable to initiate the SQLServerAgent service using the command line. A simple solution involves replacing STRDBS.CMD with two specific command lines to initiate the required services, mitigating the issue and ensuring smooth operation post-conversion. Errors related to the missing procedure can be disregarded as they don't affect system operations.
Key words :
\usr\sap\ids\dvebmgs00\work>call net start sqlexecutivethe service, call net start mssqlservercall net start sqlserveragent, \usr\sap\<sid>\sys\exe\run\strdbs, \usr\sap\<sid>\<instance>\work\stderr1, additional key words strdbs, find stored procedure 'sap_droptmpproc', sqlserveragent service, file strdbs, sql server 6, error messages
Related Notes :
| 166861 | Analysis of DB13 problems |
| 104392 | Additional info: Conversion 6.5/7.0 MSSQL Server |