Updated to 10.16.3 and now SSMS showing many incorrect errors.
Dwaine
Posts: 1 New member
in SQL Prompt
Updated to 10.16.3 and now queries showing many erroneous errors.
After updating, I now see many incorrect errors being highlighted in SSMS 20.2. For example, a sproc compiles and runs just fine, despite SQL prompt reporting things like:
The parameter xyz can not be declared READONLY since it is not a table-valued parameter
Cannot find either column "xyzcolumn" or the user-defined function or aggregate "sch.UDFName", or the name is ambiguous.
Invalid object name "sch.aVeryImportantTable"
Invalid object name "sch.aVeryImportantView"
Just these 4, and especially the last 2, are generating so many "errors" that I've had to turn sql prompt off.
Note that it isn't showing errors for ALL tables/views and there seems to be no pattern to the issue.
Any help would be greatly appreciated.
After updating, I now see many incorrect errors being highlighted in SSMS 20.2. For example, a sproc compiles and runs just fine, despite SQL prompt reporting things like:
The parameter xyz can not be declared READONLY since it is not a table-valued parameter
Invalid object name "sch.aVeryImportantTable"
Invalid object name "sch.aVeryImportantView"
Just these 4, and especially the last 2, are generating so many "errors" that I've had to turn sql prompt off.
Note that it isn't showing errors for ALL tables/views and there seems to be no pattern to the issue.
Any help would be greatly appreciated.
Tagged:
