Compare editions of SSMSBoost add in for SSMSThis 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 its functionality. Note, that there are some differences between functionality of Free and Professional versions. CIA DOCUMENTS ON THE CUBAN MISSILE CRISIS 1962. November 1, 1962. Soviet missiles leaving Cuba after the whiteknuckled standoff. Shadow of the US reconnaissance. Jonathan, We are implementing AlwaysOn with Availability Groups and welcome this utility. I have found a couple of issues with using the current version. I have over 20 years of experience in designing, implementing, integrating and customizing business management and accounting systems. In 2000 I started Flexible. 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. SSMSBoost. Features. 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 parametersAutomatically connect object explorer on startup. Automatically open empty script window on startup. Note, that in Community Edition the number of preferred connections is limited by 2. Quick Connection Switch. Drop down on toolbar, allowing to switch connections between servers. Connection Coloring. Adjust the color of the Status Bar, depending on current connection. How To Install Ssms Addin' title='How To Install Ssms Addin' />Important Database alert. Get additional visual alert when connected to important databases. Auto connect to databases at startup. SSMSBoost can create empty query windows connected to your favorite databases on startup. Auto open new query windows at startup. Download the free trial version below to get started. Doubleclick the downloaded file to install the software. Get databases under most popular source control systems directly from SSMS using shared or dedicated database development model. PDF files that contain the Visual Studio 2005 documentation. SSMS with Object Explorer connected to your favorite databases. Set Connection from Object Explorer. Set active SQL Editor connection directly from Object Explorer. Copy full object name from Object Explorer. How To Install Ssms Addin' title='How To Install Ssms Addin' />Copy fully qualified object name from Object Explorer to clipboard. 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. Edit Top N Table Rows. Open table data editor directly from SQL Editor. SSMS function available in Object Explorer now in context menu of SQL Editor. Quickly find object located at cursor position in object explorer. Shortcut Ctrl F2. Track current database. Focus current database in Object Explorer. Autoreplacements. Auto replacements or snippets allow you to write frequently used SQL commands more quickly. Custom SSMS window title. Show filename, serverdatabase of current document in SSMS title template is customizable. Advanced objects search. Search for objects across databases using wildcards. Jump to BEGINEND. Quick navigation through BEGINEND blocks. Jump between COLUMNVALUE within INSERT statement. Quick navigation between corresponding COLUMNs and VALUEs within INSERT statement. CommentUncomment selection using. CommentUncomment selected SQL code using syntax. You can re use well known syntax. Name. SQL code formatting. Format SQL Code using 2 different formatting engines SSMSBoost formatting engine feature rich, multi template. Old, but popular Poor Mans T SQL Formatter as external formatting engine. Results Grid Scripting. Flexible Template based Results Grid Scripting define your own export format for results from grid. Copy Results Grid data to Excel. Right click data in Results Grid and copy it to Excel preserving data formats. Find in Results Grid. Search for values in results grid using wildcards. Find Columns in Results Grid. Find column in Results Grid. Flexible search for columns in all Result Grids. Copy Results Grid Headers. Allows to copy column names from resulst grid directly all or headers of selected cells. Copy cell data from Results. Grid 1 1. Copies strings and data from results grid preserving line breaks and in full length. Copy as SQL values List. Copy as comma delimited list, which can be used in WHERE statement. Results Grid data Visualizers. Visualize any data saved in cells Pictures, Office Documents, PDF Files, etc. Recent connections. SSMSBoost keeps track of last used databasesservers and allows to restore previous connections. Autorecovery of recent tabs, including unsaved documents and their connections. Includes Restore last closed tab feature known from Internet browsers. Recent Sessions. Autorecovery of recent sessions, including unsaved documents and their connections. Boss Reggae Blogspot Videos. SQL Editor contents history. Keep snapshots of SQL Editor contents, while working on SQL Scripts. It is much better than built in UNDO, as far as it is permanently saved on disk and can be opened anytime later. Executed SQL Statements History. Keep track of executed SQL Statements, including additional information about execution context, result and duration. Workspaces management. Grouped frequently used documents info Workspaces or Projects. Vertical guidelines. Display one or more vertical lines in SQL Editor to keep length of your code lines under control. Fatal actions guard. Protects you from running DML statements UPDATE,DELETE without WHERE clause. TRUNCATE TABLE is handled as well. Run as Database Query. Excel. 1 click query export to Excel for further processing. Intellisense Completion Fix. Fixes SSMS 2. 01. Intellisense autocompletion option persistence. Results Grid Aggregates. Calculate inplace SUM, MIN, MAX, COUNT over selected cells in Results Grid. Query Post Execution handlers. Stay notified when long running queries execution completes. Transactions Guard. Transactions Guard. See a warning whenever SQL Editor has uncommitted transactions. Define simple sequences of using existing SSMS and third party commands and assign shortcuts to them. Manage keyboard shortcuts. DefineRe Define keyboard shortcuts. In SSMS Versions 2. Shortcut editor. In SSMS Versions 2. Dump all SSMS commands and shortcuts. Outputs full list of SSMS native and third party commands along with their shortcuts. Saves you a lot of time, if you are looking for some specific command or. Automatically check for newer SSMSBoost versions. Supported versions of SQL Server Management Studio. SSMS 2. 01. 7 3. 2 and 6. SSMS 2. 01. 6 3. 2 and 6. SSMS 2. 01. 4 3. 2 and 6. SSMS 2. 01. 2 3. 2 and 6. SSMS 2. 00. 8 R2 3. SSMS 2. 00. 8 3. 2 and 6. Licensing. 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. Possibility to deactivate already activated licenses for migration purposes hardware upgrades, passing the license to other employeeSSMSBoost team keeps releasing the add in on constant basis since 2. There are over 4. Here is link to EULA Free Community Edition mode has following conditions Trial mode lasts for 3. 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 1. 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 3.