Symptom
- SAP system does not work due to the following error in the developer trace:
(102) [42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'execute.'.
<if user_name() != '<sid>' execute as login = suser_sname(suser_sid('<sid>')) with no revert> failed -- connect terminated
- The <sid> in the error is lower case
Read more...
Environment
- Netweaver
- MS SQL Sever database
Product
SAP ERP 6.0
Keywords
lower case, Incorrect syntax near 'execute.' , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.