sqlserver probe - No output from custom query

book

Article ID: 128973

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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?

Environment

Release: MSPNSP99000-9.0.2-Unified Infrastructure Mgmt-Server Pack-on Prem MSP
Component:

Resolution

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.