Error using check_mssql

[scottwilkerson]

Thanks Scott. I will hold off on reverting to version 5. Please let me know how you progress with a possible work-around or if there is any other alternative

Will do.

I'm not a SQL SERVER expert but there may be a way to craft the query to just use the CASE statement instead of the IF it is choking on, just a suggestion.

[nelsonw]

Hi Scott,

I removed the IF statement and replaced with CASE. However, I still had the same issue.

I reverted to a previous version of check_mssql, 0.7.3. This has resolved my issue, I can now use IF or CASE statements in the SQL file


Thanks,
Nelson

[scottwilkerson]

This has resolved my issue, I can now use IF or CASE statements in the SQL file

Glad to hear you found a workaround!