Error Number: 46010

[CarlienM-discovery]

Hi there. Any idea why I get 100's of 46010 errors when running the dependency analyzer?

[keif888]

The Parser that is being used is Microsoft's Parser that SSDT uses.
There are a number of bugs within that Parser that have been fixed over time, but this project hasn't been updated to use the fixed parser.
eg.
https://developercommunity.visualstudio.com/t/ssdt-incorrectly-highlighting-syntax-issue-sql4601/790403
And this one is still open:
https://developercommunity.visualstudio.com/t/iif-in-codition-sql46010-incorrect-syntax-near/1578715

Without an example of an SQL Statement that is causing the issue to be raised, I'm unable to confirm this.

[keif888]

I've assumed that the issue is ODBC call's to stored procedures.
This is fixed in https://github.com/keif888/SQLServerMetadata/releases/tag/v0.28.0.0-beta

[CarlienM-discovery]

Thank you . I will check today. Have been just snowed under with work :-) Thanks again. Much appreciated.

[CarlienM-discovery]

Thank you. I have reinstalled - still getting some errors. Will look if i can do some analysis later today. From just watching the parsing - it might queries running on Oracle. Let me do some work on this. Thank you once again.

[CarlienM-discovery]

Checked - it seems it is an issue with our scripts. "SQL Server does not support CURRENT_DATE function" A lot of our devs are previous Oracle devs and use "current_date" everywhere :-) Thank you for all the effort on your side.