I have created a MS SQL Database Server monitor and would like to alert based on the results of a query. For example:
select count(*) from [db].[queue];
The SQL Server Management page says "SQL server monitoring has the ability to connect to the database source, process any query received in the database..." which suggests that I should be able to run queries and therefore do what I would like to do.