Page 3 of 3
Re: Error using check_mssql
Posted: Fri Sep 06, 2019 12:49 pm
by scottwilkerson
nelsonw wrote: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.
Re: Error using check_mssql
Posted: Fri Sep 13, 2019 6:35 am
by 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
Re: Error using check_mssql
Posted: Fri Sep 13, 2019 6:47 am
by scottwilkerson
nelsonw wrote: This has resolved my issue, I can now use IF or CASE statements in the SQL file
Glad to hear you found a workaround!