Search code examples
sql-serversql-server-2008ssmslinked-server

SQLSMS Intellisense on linked server

I'm trying to work Microsoft SQL Server Management Studio 10.0.5538.0 (latest right now) with Intellisense on linked servers, for example:

SELECT Column FROM [LinkedServer].DatabaseName.dbo.Table WITH(NOLOCK)

But I couldn't find a way to make intellisense show results as I write SQL code (it works fine with non-linked servers)

Things I've tried:

  • Look for answers in SQLSMS docs.
  • Look for specific config option in the application.
  • Update local cache in Edit -> IntelliSense -> Refresh local cache.

Thanks for your help,

Solution

  • Apparently this isn't supported.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ef973d28-6450-451c-840f-9d14c7ae4ed1/intellisense-invalid-object-name-on-linked-database-runs-fine?forum=sqldatabaseengine

    One reason given is that this linked server could be Oracle, Excel... anything, and to support that is unfeasible