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)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER_NAME()"
Description
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.
Resolution
- WORKAROUND
None.
- STATUS
Waiting for a fix in the future version of ApexSQL Audit
Defect ID

231197

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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