Synonyms that reference local database show as "Invalid object name 'mysynonym'" in intellisense in SSMS

kiln 11 Reputation points
2021-07-12T22:40:45.59+00:00

Synonyms that reference local database show as "Invalid object name 'mysynonym'" in IntelliSense with SSMS 18.9.1, at least they do for me. I have found mentions of this "bug" going back to at least 2011. There is still no fix for this or workaround, other than defeating IntelliSense ? The use of synonyms isn't exactly rare. Having the query window full of red squiggles more or less defeats the utility of IntelliSense . I've tried opening, closing, clearing the IntelliSense cache, nothing works. It's like this on all of the SSMS instances I have access to.

Developer technologies | Transact-SQL
SQL Server | Other
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. kiln 11 Reputation points
    2021-07-13T13:43:48.507+00:00

    In the original post I mention that refreshing the cache, etc didn't help. The synonyms work so obviously they refer to valid objects, if that's what you mean.

    1 person found this answer helpful.

  2. kiln 11 Reputation points
    2021-07-14T15:05:06.603+00:00

    Anyone out there have useful input on this?

    0 comments No comments

  3. Tom Phillips 17,771 Reputation points
    2021-07-14T17:49:19.45+00:00

    I use synonyms a lot and do not have that issue using SSMS v18.9.1. It must be something to do with your cache.

    I find Intellisense almost not worth bothering with. Some of the time it doesn't work at all.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.