MSSQL query interpreted as a stored procedure

[alexmar000]

Hello. I am using KEDA through Azure and specifying a custom mssql trigger. However i am getting the error:

"error inspecting mssql: mssql: Could not find stored procedure 'SELECT COUNT(*) FROM [dbo].[Test] WHERE State = 0;'."

I have checked that i have a proper connection string with the correct initial catalogue. It is my understanding that both SPs and queries are to be supported without needing any flag. Any ideas?

[alexmar000]

I figured out the answer. I needed to place my column name (e.g 'State') in square brackets.