Intelli sense for linked server objects

agepeder 271 Reputation points
2021-02-23T21:42:03.307+00:00

Hi,

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

thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,122 questions
{count} votes

Accepted answer
  1. Erland Sommarskog 104.2K Reputation points MVP
    2021-02-23T22:46:01.093+00:00

    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?

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-02-24T06:49:35.727+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments