SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER

Chat now with support

SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER_NAME()" (4375069)

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER_NAME()"
Beschreibung
1. Add a server and database for auditing using Extended event data collection
2. Connect to the audited server in SSMS and make sure that the current user (the user which is currently logged in) is mapped to the database you are auditing.
3. In the context of the db that is being audited, run the following command: EXECUTE AS USER = SUSER_NAME();
4. On the audited server, restart the Distributed process to force Trace processing
5. The logs show a parsing error and the Trace is moved to the Quarantine folder
2024-02-29 09:15:41.566 DEBUG [QDQ6X6Y2]: SQL Parser exited with code 1
2024-02-29 09:15:41.566 DEBUG [QDQ6X6Y2]: syntax error, state:1292(10101) near: SUSER_NAME(1,19)

2024-02-29 09:15:41.566 DEBUG [QDQ6X6Y2]: SQL Query: EXECUTE AS USER = SUSER_NAME()

Expected result: The EXECUTE AS USER = SUSER_NAME(); query is processed without issues.
Lösung
- WORKAROUND
None.
- STATUS
Waiting for a fix in the future version of ApexSQL Audit
Fehler-ID

231197

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER_NAME()" (4375069)