Intellisense breaks on re-opening SSMS with multi database scripts

Joelg

Hi
Since a couple of weeks I have issues with the intellisense suggestions not applied correctly. part of the code is red squigglies and "invalid object" errors. Even though the code is runnable

To reproduce
1. Create a new script that
a. selects using three point notation from different database (select * from database.schema.table)
b. selects using two point notation from current database (select * from schema.table)
2. Close SSMS and re-open
3. Intellisense now squiggly lines everything for the second statement (even though current database is selected)
4 Ctrl+Shift+D does not fix the errors
5 . Closing and Re-opening  the window fixes the errors
6. Adding a explicit use statement (for the already current database) fixes the squigglies. This indicates parsing logic is broken.

Dan_J

Hi there @Joelg

Thanks for reaching out to us regarding this!

Just to ensure I can reproduce exactly what you are seeing here, would it be possible for you to provide an example script for the scenario you are describing?

Joelg

Hi @Dan_J
Thanks for responding.
As I was about to create the script, I could no longer reproduce the issue. Which is good of course!
I recently updated my version so It may have been solved by that
Best regards
Joel

Joelg

Never mind this post. It was broken code due to my bad :-)

Dan_J

Hi @Joelg

Thanks for your update on this, and no problem at all.

I'm glad you were able to get to the bottom of the issue.

Thanks again for reaching out to us.