Fix Intelisense alert "Invalid object name" with SSMS

Question

question

RH-2993 asked Jun 1, '20 RH-2993 edited Jun 2, '20

Fix Intelisense alert "Invalid object name" with SSMS

I'm writing SQL in SSMS.

I'm getting the value from the link server, but the [LINK SERVER].[DB].[dbo].[TABLE] string is marked with a red wavy under line.

※However, the execution itself is successful.

I want to get solution of this, but how do I do it?

Please any help will be appreciate, Thank you.

not-supported

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2020-06-02T02:19:12.057Z

RH-2993 answered Jun 2, '20 RH-2993 edited Jun 2, '20

I got a solution now.
"It is impossible to fix this behavior so far".

I decided to give up.

Thank you all.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2020-06-01T06:34:44.89Z

LeonLaude answered Jun 1, '20

Hi,

Q&A currently supports the products listed over here https://docs.microsoft.com/en-us/answers/products (more to be added later on).

You can reach the experts in the dedicated SQL Server forum over here:
https://social.technet.microsoft.com/Forums/en-US/home?category=sqlserver

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 3 · 2020-06-01T07:46:20.303Z

RH-2993 answered Jun 1, '20

Hi,

I see.

I posted a question to TechNet.
If I can get a solution, I'll include it here.

Thank you.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 4 · 2020-06-01T12:05:44.58Z

VaibhavChaudhari answered Jun 1, '20 RH-2993 edited Jun 2, '20

Try pressing Ctrl + Shift + R key and see if that's solves. This combination of keys refreshes intellisense.

If the response helped, do "Accept Answer" and upvote it - Vaibhav

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RH-2993 · Jun 02, 2020 at 02:23 AM

I tried it, but it didn't work...
Thank you for response.

0 ·

question