Intelli sense for linked server objects

Question

Hi,

Will intelli sense work for linked server objects ? My searching indicates that its a no. Can someone confirm it ?

thanks

Answer 1

I don't use IIntellinonsense myself, but keep in mind that a linked server could be running Oracle or Postgreas, it could be an Excel file or a Hadooop cluster. It seems unlikely that SSMS would support all of that.

Yes, 90% of the linked servers in this world is another SQL Server instance, but I would not expect SSMS to handle this special case.

But why don't you test?

Answer 2

Hi @agepeder ,

>Will intelli sense work for linked server objects ?

Unfortunately, not all IIntellinonsense will work well. Please refer to Intellisense: Invalid Object Name on Linked Database, runs fine? to get more information, see below:
The Intellisense cache is built through the SMO connection to the SQL Server that SSMS uses. SSMS works through SMO. No SMO connection exists for a linked server. Further, a end user may not have the necessary rights on the linked server to get the metadata even if it could be queried through a standard request, and this would require that the type of linked server be checked, because we can link to Oracle, Access, XML, Excel, and other providers.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.