Skip to content
Advertisement

Invalid Object Name – Tried a few things

I have the following query:

It keeps telling me ‘invalid object name’. The table exists. I checked the drop-down to ensure the right database is connected. I refreshed Intellisense cache.

Not sure what else to do…

enter image description here

enter image description here

enter image description here

enter image description here

Advertisement

Answer

I think you are looking for linked server object names, if so then you need to call it :

So, after then SELECT Statement would looks :

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement