We are using the 5.42 version of the sqlserver probe and have set up a query that we have already confirmed to be working
in MS SQL Server Management Studio. However when we use the same query in the probe the result set is empty.
Why is this?
Release: MSPNSP99000-9.0.2-Unified Infrastructure Mgmt-Server Pack-on Prem MSP
The custom query was a multi-line query comprising of individual sql statements.
For such a query the first line in the probe must be
SET NOCOUNT ON
this is then followed by the actual query.
This directs the probe that what follows is a multi-line custom query with the last line of the query providing the
the result set.