Menu
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:
Thanks for your help,
538
How to Enable IntelliSense Feature in SSMS. Open SSMS, click Tools -> Options -> Expand Text Editor -> Expand Transact-SQL and click on IntelliSense as shown in the snippet below. Under Transact-SQL IntelliSense Settings ensure “Enable IntelliSense” checkbox is enabled.
IntelliSense is not available when the Query Editor is connected to earlier versions of the Database Engine. IntelliSense is turned off in the Database Engine Query Editor when the SQLCMD mode is set on.
1 Open SQL Server Management Studio, navigate to the Object Explorer pane, and select Server Objects > Linked servers > Providers. 2 Right-click mrOledb. Provider and select Properties. 3 Select allow in process, and then click OK.
The first step of troubleshooting IntelliSense is to check and make sure IntelliSense is enabled in the settings. Launch SSMS and go to menu Tools >> Options. In the Options window, expand TextEditor >> Transact-SQL >> IntelliSense. Make sure Enable IntelliSense is selected.
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
156
As an addendum to this answer by BenXvisual, in SSMS 17.9.1 (14.0.17289.0) hotkey for switching off Intellisense is Ctrl-B, Ctrl-I.
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
