Menu
Are there any free, or cheap plug-ins/add-ons for SQL Management Studio that provide intellisense and (less importantly) some auto-formatting? I've recently tried Redgate's product and really like it for these features, but I'm wondering if there are any alternatives.
789
Go to Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense -> Enable IntelliSense, as shown in the snippet below. Open New Query Window -> Go to Edit -> Expand IntelliSense -> Click Refresh Local Cache or press the shortcut key (CTRL + SHIFT + R) to refresh the local cache as shown in the snippet below.
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.
Select the Edit menu, select IntelliSense, then select Refresh Local Cache. Use the CTRL+Shift+R keyboard shortcut.
Open SSMS – Click on Tools, Options, Expand Text Editor, Transact – SQL, and then uncheck the box next to Intellisense. That's it. We are done.
Late answer, but might be interesting to the thread visitors
Have you heard of ApexSQL Free tools - ApexSQL Complete and ApexSQL Refactor? These might be just what you need.
ApexSQL Complete autocompletes SQL keywords, and has a ton of other SQL Server productivity features for SSMS and Visual Studio, and it is completely free.
ApexSQL Refactor is SQL formatter with over 160 formatting options - it is too completely free.
Both of these are SQL Server Management Studio and Visual Studio plugins, so you can use them directly from within SSMS and VS.
54
Check out our dbForge SQL Complete. It is an add-in for SSMSthat offers autocompletion and formatting of T-SQL code and supports SQL Server 2000, 2005 and 2008
Recently we have released a new major version (2.00) which includes much more new features.
There's two editions – Express, which is free and has basic autocomplete and formatting functionality, while Standard Edition offers more features, has 30-days free trial and costs only $49.95.
33
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
