KBI 312019 Issue Addressed: When Running A Stored Procedure With Parameter At Argent for SQL Server Query Rule


Argent Advanced Technology 5.1A-2210-A and below


Friday, 4 Nov 2022


A “Syntax error or access violation” error occurs at the Query Rule

Technical Background

Argent for SQL Server throws an error message “syntax error or access violation”, when running a stored procedure with parameter at SQL Query Rule

This was a coding error and has been addressed in Argent Advanced Technology 5.1A-2210-T2 version

In order to configure the Rule, specify the procedure name and parameter with a space between

For example, to execute a stored procedure named GET_ALERTS_FIRED that accepts a string parameter alert name ‘ALARM_DEMO’, configure SQL Query Rule as shown below:

Multiple parameters should be separated by comma

For example, if the stored procedure GET_ALERTS_FIRED accepts two parameters, such as alert name ‘ALARM_DEMO’ and machine name ‘MFC-SQL’, the SQL command should be:



Upgrade to Argent Advanced Technology 5.1A-2301-A or above