UIM sybase/sqlserver: Query returns error: Incorrect Syntax near 'go'.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I'm trying to create a custom checkpoint/Query in the sybase probe (or sqlserver probe) but when I validate the query i receive the following error:

UIM sybase/sqlserver: "Query returns error: Incorrect Syntax near 'go'."

 

 

Environment

Release : UIM 9.2.0 / 20.x

Component : UIM - SYBASE

Cause

The use of "GO" is not supported. 

"GO" is not a SQL keyword. It's a batch separator used by client tools (like SSMS) to break the entire script up into batches.

Resolution

The probe only supports SQL commands