SQL Complete is designed to increase productivity. Developers and DBAs working with SQL become much faster thanks to our tool, as it provides smart prompts based on the code context, selected database, etc. The application takes the smallest hint to guess what you are trying to write. Coding standards.

Published 10 October 2017. His page explains how to search for objects using SQL Search, how to narrow the scope. Search in Management Studio, click SQL Search in the Redgate toolbar. SQL Server Management Studio; Visual Studio. I have SSMS 2016 and 2017 installed. My red gate tools are installed on SSMS 2016, how can I install then on my 2017 SSMS as well? Install on SSMS 2017. Jleiser Posts: 1. May 8, 2017 2:24PM in SQL Prompt. Connecting to SQL Server 2017 you might see some hiccups.

What are your favorite SSMS addons?

I've recently started delving into SSMS Addons.

I'm really loving RedGate SQL Prompt 5 (refactoring/better intellisense), though it's spendy.. the trial is going swimmingly. http://www.red-gate.com/products/sql-development/sql-prompt/

With that I like RedGate SQL Search (Free) http://www.red-gate.com/products/sql-development/sql-search/

and

RedGate Tab Magic: http://www.red-gate.com/products/sql-development/sql-prompt/entrypage/sqltabmagic also free and a godsend.

That said, other nice tools:

SSMS Tools Pack: http://www.ssmstoolspack.com/

Or as free (but not as nice as RedGate's offerings, IMHO)(They 'seemed' slower and I like RedGate's code formatting better, I never could tune Apex Complete's to be just how I wanted it...even though there were vastly more options...) are the ApexSQL Free tools:

http://www.apexsql.com/products.aspx (Apex Complete, Apex Refactor, Apex Search)

Does anyone else have any 'must have' tools for SSMS they'd like to share?

Compare Microsoft SQL Server versions

• Not supported
• Fully supported