Features list / SSMSBoost version comparison

This page lists all functionality, provided by SSMSBoost add-in for SQL Server Management Studio. Table below provides some digest descriptions. Clicking on the name of the specific feature you will get more details about it's functionality. Note, that there are some differences between functionality of Free and Professional versions. See table below for reference. Licensing terms are additionally described at the bottom of the table.

The best way to learn SSMSBoost functionality is to install it and study SSMSBoost menu, that will appear on the SSMS Menu bar. We also recommend checking SSMSBoost settings, as far as they contain settings almost on every function provided by SSMSBoost.

Features Community (Free) Professional
Preferred connections
  • Connection aliases
  • Connection coloring
  • Active and passive protection of important databases by visual warning and blocking of critical DML without WHERE clause
  • Fixed SSMS issue with "Additional connection parameters"
  • Automatically connect Object Explorer at startup
  • Automatically open empty script window at startup
  • Note, that in Community Edition the number of preferred connections is limited to 2
Checked Checked
Quick Connection Switch
Drop-down on toolbar, allowing to switch connections between servers
Checked Checked
Connection Coloring
Adjust Status Bar color depending on the current connection
Checked Checked
Important Database alert
Get additional visual alert when you connect to important databases
Checked Checked
Auto-connect to databases at startup
SSMSBoost connects Object Explorer to your preferred databases at startup
Checked Checked
Auto-open new query window(s) at startup
You can start SSMS with Object Explorer connected to your favorite databases
Checked Checked
Set Connection from Object Explorer
Set active SQL Editor connection directly from Object Explorer
Checked Checked
Copy full object name from Object Explorer
Copy full object name from Object Explorer to clipboard
Checked Checked
Script Object
Open source code of object located at cursor position in sql editor. Shortcut: [F2]
Equal to "Go To Definition" function in Visual Studio. Object script is opened in "well-named" tab, containing object name and other information (customizable)
Checked Checked
Edit Top N Table Rows
Open table data editor directly from SQL Editor. Native SSMS function used in Object Explorer is now available in context menu of SQL Editor.
Checked Checked
Locate Object
Quickly find an object located at cursor position in Object Explorer. Shortcut: [CTRL+F2]
Checked Checked
Track current database
Focus current database in Object Explorer
Checked Checked
Auto replacements or "snippets" allow you to write frequently used SQL commands much faster
Checked Checked
Custom SSMS window title
Show filename, server/database of current document in SSMS title - template is customizable
Checked Checked
Advanced objects search
Search for objects across databases and servers using wildcards
Checked Checked
Search for Object by Token
Search for objects across multiple connections using text as filter string. Shortcut: [SHIFT+F2]
Checked Checked
Select Current Statement
You can quickly select and run current SQL Statement (SHIFT+F5)
Checked Checked
Quick navigation to BEGIN and END of the current block or between corresponding BEGIN/END tokens
Checked Checked
Jump between brackets ()
Quick navigation between bracket pairs within statement
Checked Checked
Jump between COLUMN/VALUE within INSERT statement
Quick navigation between corresponding COLUMNs and VALUEs within INSERT statement
Checked Checked
Comment/Uncomment selection using /**/
Comment/Uncomment selected SQL code using /**/ syntax in one click
Checked Checked
You can re-use well-known syntax:
--#region [Name]
Checked Checked
SQL code formatting
Format SQL Code using 2 different formatting engines:
  SSMSBoost formatting engine: feature rich, multi-template
  Old, but popular "Poor Man's T-SQL Formatter" as external formatting engine
Checked Checked
Results Grid Scripting
Flexible Template-based Results Grid Scripting useing pre-defined templates. Script as Excel document, JSON, XML, HTML, SQL Values List. Create your own scripting templates if you have special needs."
Checked Checked
Copy Results Grid data to Excel
Copy data from Results grid and paste it to Excel preserving data type information
Checked Checked
Find in Results Grid
Search for values in Results grid using wildcards and regular expressions
Checked Checked
Find Columns in Results Grid
Find column in Results grid
Flexible search for columns in all Result sets
Checked Checked
Copy Results Grid Headers
Allows you to copy column names (all or selected) directly from Results grid
Checked Checked
Copy cell data from ResultsGrid 1:1
Copies strings and data from Results grid preserving line breaks and full length
Checked Checked
Copy as SQL values List
Copy as comma-separated list which can be used in WHERE statement
Checked Checked
Results Grid data Visualizers
Visualize any data saved in cells: Pictures, Office Documents, PDF Files, etc
Checked Checked
Recent connections
SSMSBoost keeps track of last used databases/servers and allows to restore previous connections.
Checked Checked
Recent Tabs
Autorecovery of recent tabs, including unsaved documents and their connections. Includes "Restore last closed tab" feature known from Internet browsers
Checked Checked
Recent Sessions
Autorecovery of recent sessions, including unsaved documents and their connections
Checked Checked
SQL Editor contents history
Keep snapshots of SQL Editor contents while working on SQL Scripts. It is a much better feature than the built-in UNDO as it is permanently saved to your disk and can be opened anytime later
Checked Checked
Executed SQL Statements History
Keep track of executed SQL Statements, including additional information about execution context, result and duration.
Checked Checked
Workspaces management
Grouped frequently used documents info Workspaces (or Projects)
Checked Checked
Vertical guidelines
Display one or more vertical lines in SQL Editor to keep the length of your code lines under control
Checked Checked
Fatal actions guard
Protects you from running DML statements (UPDATE,DELETE) without WHERE clause. TRUNCATE TABLE is handled as well.
Checked Checked
Run as Database Query (.dqy) in Excel
One-click export of SQL query to MS Excel for further processing
Checked Checked
Intellisense Completion Fix
Fixes SSMS 2012 "Intellisense autocompletion" option persistence.
Checked Checked
Results Grid Aggregates
Calculate inplace SUM, MIN, MAX, COUNT, NULLs, Distinct Count, AVG and Data Lengths over selected cells in Results Grid
Checked Checked
Post-Execution Handlers
Stay notified when long-running queries execution completes.
Checked Checked
Transactions Guard
Displays a warning whenever SQL Editor has uncommitted transactions
Checked Checked
Define simple sequences of using existing SSMS and third-party commands and assign shortcuts to them
Checked Checked
Manage keyboard shortcuts
Define/Re-Define keyboard shortcuts
  In SSMS Versions 2008-2014 using our custom Shortcut editor
  In SSMS Versions 2016 and later using integrated editor
Checked Checked
Dump all SSMS commands and shortcuts
Outputs full list of native SSMS and third-party commands along with their shortcuts. Saves you a lot of time when looking for some specific command or all commands related to a specific keyword (like "regions").
Checked Checked
Update Checker
Automatically check for new SSMSBoost versions
Checked Checked
Supported versions of SQL Server Management Studio SSMS 2018 32 and 64 bit editions
SSMS 2017 32 and 64 bit editions
SSMS 2016 32 and 64 bit editions
SSMS 2014 32 and 64 bit editions
SSMS 2012 32 and 64 bit editions
SSMS 2008 R2 32 and 64 bit editions
SSMS 2008 32 and 64 bit editions

Professional license offers following benefits:
  • One time activation, no limits, you are free to decide when to make upgrades.
  • One year of updates is included with your purchase.
  • New on-line licenses management platform is ready for small and large team needs.
  • As Licensing administrator you will get separate token for every purchased license. You can distribute tokens in your team, without distributing master account information.
  • Possibility to deactivate already activated licenses for migration purposes (hardware upgrades, passing the license to other employee)
  • SSMSBoost team keeps releasing the add-in on constant basis since 2012, in average publishing new version every 3 months. There are over 40.000 users in more than 15.000 companies worldwide using our software.
  • Here is link to EULA
Free Community Edition mode has following conditions:
  • Trial mode lasts for 30 days and does not require any activation
  • All features are available in trial mode
  • To continue usage after trial mode expiration you can request Free community license or buy the Professional License
  • Users with community license need to download fresh version at least every 4 months (120 days)
  • Whenever we release new version, trial mode restarts from the beginning, even if it was expired. This means, that free community license users get full access to all SSMSBoost features for 30 days after every release