How can we help you today? How can we help you today?

Updated to 10.16.3 and now SSMS showing many incorrect errors.

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.
Dwaine
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hi Dwaine,

    Thanks for reaching out to Redgate Software and sorry to hear you are having some SQL Prompt issues after upgrading. In this case, could I kindly request that you include your SQL Prompt logs for review here?

     

    Additionally, I am curious if you would be willing to uninstall and reinstall the version prior to 10.16.3 and see if this issue goes away. If there are any snippets or information you want to backup I believe the path is in Appdata/local/redgate/SQLPrompt.

     

    You can find all publicly available versions of Prompt Here: http://download.red-gate.com/checkforupdates/SQLPrompt/

    Christian Perez

Add comment

Please sign in to leave a comment.