Invalid column name 'idx'

dcoyle

After update of SQL Monitor to version 6.0.15 from 6.0.1 when I am redirected back to the SQL Monitor website I now get the error:

Unable to connect to the data repository
Invalid column name 'idx'

Any thoughts regarding why this is occurring and how to resolve?

Alex B

Hi dcoyle,

This is due to a having a Case Sensitive Collation (CS or BIN) on the SQL Server housing the SQL Monitor data repository. I have found and fixed the issue (one of the update scripts has 'idx' instead of 'Idx') and it will be out in the next release.

In the meantime please roll back to your previous version until this is available!.

Kind regards,
Alex

dcoyle

Thanks Alex. Fantastic work. Look forward to next hotfix.

Alex B

Hi dcoyle,

SQL Monitor 6.0.16 has been released and you should be able to get this by going to Configuration > About and clicking on "get latest version" next to where it indicates the current version.

Kind regards,
Alex