Update 07-th of July, 2017:We are happy to announce Release candidate 2 of v3.0 (Link to the Installation is at the bottom of this text)

NOTE!! IMPORTANT:Licensing functionality is completely disabled in this version. It will run for 60 days in full-functional trial mode until we publish the official release along with the new version of the website.Auto-update functionality is disabled as well as far as it is also bound to the website.

UPGRADES from previous versions:In case windows will ask you for .msi of the previous version and you do not haveone, you can download it under this URL:http://www.ssmsboost.com...chive/SSMSBoostInstaller{version}.msiJust replace {version} with version number, your system is asking you for.

3.0 RC1NEW FEATURES-SSMS 2017 Supported ! Note: SSMS 2017 brought further changes in internal structure, so that we had to re-implement some hooks and interaction routines. We have done full test by now and fixed all issues that were found. One known issue is in progress: "OUTPUT" keyword within "EXECUTE" statement will not be formatted. We would be thankful if you report us any issues, that you encounter.-Jump between COLUMNS and VALUES in INSERT statement. Press CTRL-SHIFT-DOWN (when you are in Columns block) or CTRL-SHIFT-UP (when you are in VALUES block). Cursor will jump to the corresponding Column/Value. (This hotkeys also allow to jump between BEGIN/END statements)-Query post execution actions: get notification after query completes execution. This is useful when you start long-running queries and switch to another script or application. You will be notified by popup or system tray message. We will extend this functionality in further releases, adding the possibility to send e-mail on query completion or execute another action. Write us your ideas and send your post-execution scripts !-Added native search in execution history. SSMSBoost had already logging of all executed queries and execution results, but search had to be done with native feature of SSMS "Find in Files". Now using History->Find in Execution History you can search throught queries, you have executed in the past.-TRANSACTION REMINDER: whenever execution of last SQL batch leaves open transactions SSMSBoost will show floating information window with the reminder. There will be one reminder window shown per SQL Editor tab. Reminder can be closed or will close itself when @@TRANCOUNT reaches 0. Feature re-uses native SSMS functionality, that checks open transactions whenever you try to close SQL Editor window with open transactions. Due to this fact we do not show number of open transactions. You can always check number of open transactions using SELECT @@TRANCOUNT statement. (Can be disabled in Settings)-"Copy as Values list": copy values from ResultsGrid as native SQL values list that can be re-used in SQL statements. Strings are quoted, datetime values are in canonical form. Result is placed to clipboard and is ready to be pasted to your "WHERE in ()" and other statements.-"Preferred connections" drop down is now extended with "Recent connections" secion. Number of recent connections can be configured in Settings->Preferred Connections.

Improvements-Added {ColumnType} parameter to grid scripting template. Now, based on any grid content, you can automatically generate CREATE TABLE scripts. Useful, for example, when you want to create #tempTable CREATE statement based on Stored Procedure output. (See CREATE TABLE scripting template)-Added NString formatter to grid scripting templates. It allows to create own output formatting for NCHAR, NVARCHAR and other N-string types.-Re-designed SSMSBoost menu structure. Now you can find all SSMSBoost commands under SSMSBoost menu. Study it and learn all available functionality. Re-design was necessary in preparation for SSMS 2016.-Added SUM over BIT fields in ResultsGrid Aggregates-Added parameter: Number of recent connetion to remember.-Fatal Action Guard has new setting for disabling it's functionality for scripts larger than X Mb. Default setting is 10Mb.-Added "nullable" property in columns list of "Find column" dialog (Ctrl+F in results grid)-Improved behavior of "Comment-Uncomment" feature. It does not require exact positioning of selection to uncomment the block (whitespace and newlines will be ignored.) Also several lines of "--" comments will be uncommented now as well.-Added "NULL Count" counter to grid aggregates and improved behavior on NULL values.-Grid aggregates can be configured to stop automatic calculations, if there are too many cells selected in the grid. See settings.-{StartTime} and {EndTime} parameters were added to message template of "post-execution notification" feature. NOTE: if you update from previous beta you will have to edit notification template yourself and add these tokens. For example you can use this template:-Added an option to deactivate connection coloring-"Preferred connections" drop down used native SSMS "Local databases" drop down to fill it's"local databases" part, which worked extremely slow when working on remote servers with heavy load or poor connection. Now this feature is improved and listing works much faster. Additionally there is a possibility to show only "accessible" databses for your DB user, based on native SQL has_dbaccess() function. For more options see in Settings->Preferred Connections.-In several SSMSBoost Settings dialogs, like Autoreplacements, some strings can use pre-defined parameters. Help-Text in dialog can be now clicked to copy parameter name to clipboard.-Fixed behavior or {server} parameter in Autoreplacements and added new {serverDisplayName} parameter.-Change log with notes about recent changes will now be displayed on first run after the installation.-File names generated with "Visualize as" functionality will start with correspinging column name.-Added full support for Shortcuts in SSMS 2016. Commands and Macros are now separated in settings. "Commands" page lists all SSMSBoost commands and assigned shortcuts. Shortcuts can be re-fedined here directly. "Macros" - separate page in Settings to create simple command combos and manage their shortcuts.-Added "close all" (result tabs) for "Find in Grid" and "Find in History" dialogs.-Added additional events for saving "Recent Tabs". See "Recent Tabs" settings. Improved management of Recent Tabs/Recent Sessions/Recent Connections management.-SSMSBoost now has one installer for all SSMS versions. Note: it is important to uninstall all previous versions, before installing this new release. All your user data (settings, templates, connections) will not be deleted when uninstalling and will be re-used by the new version after the installation.

Fixes-Improved usability of Objects Search dialog / UI fixes.-Fixed bug with recursive regions parsing-Fixed bug with Unicode strings, placed as HTML to clipboard. (Grid scripting as HTML with further insertion in Outlook or Word)-Added new counters to "Usage statistics".-Improved code guard to ignore cases, when aliased temporary #table is used.-Further internal improvements to increase compatibility with mixed installations of several SSMS versions, when several DLL versions are present in the system.-Better handling of corrupted settings-ENTER starts search in "Search in History"-Performance improvements and bug fixes (mostly in SSMS2016 version)-Improved dialog layout for Grid Scripting, Find column, Find data in grid dialogues-Fixed broken sort order of servers, automatically connected in Object Explorer ar start-up-Added support for latest SSMS 2016 release (13.0.16000.28) which brought some breaking changes in API causing "Fatal actions guard" to stop working.-Increased of max length of autoreplacement strings.-Improved "Query complete" notification icon in system tray. Now dbl-click activates the query window, where the execution completed.

IMPORTANT: Breaking change ! You have to UNINSTALL all previous BETA versions of the add-in to proceed. We have moved from 5 separate installers to single all-in-ine installer. Remove previous versions using "Add/Remove programs".If your computer will ask for .msi file with previous version, you can download it here:www.ssmsboost.com/instal...chive/SSMSBoostInstaller{version}.msi

I personally don't use the Formatting feature at all, since I have another tool which works better for me. And there are many tools which provide Formatting functionality - free and paid.

I think it is more important to focus on feature unique to the product (or available from a limited set of competitors), so more people would be interested in buying the license. The main reason I switched from a competitor product is an ability to script objects by pressing F2, navigation between "BEGIN/END" keywords and session/workplace management and Preferred connectionsEven hough I think SSBS boost is not very strong in history search interface and missing Tab coloring.

Grid Scripting Templates, Grid Visualizers, Grid Aggregates are great and unique features, but I don't use them that much.I am not interested in support of older versions of SSMS and regions (since SSMS support collapsing statements out of the box)

It would be great to have some sort of voting for features for users similar to Microsoft Power BI User Voice (https://ideas.powerbi.com/forums/265200-power-bi-ideas).

Bugs/Proposals:1. Find In History Dialog - doesn't start search by pressing Enter from "Find what" text box2. It would be nice to have "Preview" screen to be always visible in history and change based on selected file.3. Implement Tab Coloring by Connection

There appears to be a bug with the 'Script Object As...' and 'Locate Object in Object Explorer' context menu options when using a SQL Server 2005 database. Whenever you right-click a legitimate object name and select any of these options, you get 'Error occurred while analysing identifier Execute with results failed for database xxxx'

I realise that 2005 is not officially supported in SSMS 2016, but thoughht this was worth raising.

There appears to be a bug with the 'Script Object As...' and 'Locate Object in Object Explorer' context menu options when using a SQL Server 2005 database. Whenever you right-click a legitimate object name and select any of these options, you get 'Error occurred while analysing identifier Execute with results failed for database xxxx'

I personally don't use the Formatting feature at all, since I have another tool which works better for me. And there are many tools which provide Formatting functionality - free and paid.

I think it is more important to focus on feature unique to the product (or available from a limited set of competitors), so more people would be interested in buying the license. The main reason I switched from a competitor product is an ability to script objects by pressing F2, navigation between "BEGIN/END" keywords and session/workplace management and Preferred connectionsEven hough I think SSBS boost is not very strong in history search interface and missing Tab coloring.

Grid Scripting Templates, Grid Visualizers, Grid Aggregates are great and unique features, but I don't use them that much.I am not interested in support of older versions of SSMS and regions (since SSMS support collapsing statements out of the box)

It would be great to have some sort of voting for features for users similar to Microsoft Power BI User Voice (https://ideas.powerbi.com/forums/265200-power-bi-ideas).

Bugs/Proposals:1. Find In History Dialog - doesn't start search by pressing Enter from "Find what" text box2. It would be nice to have "Preview" screen to be always visible in history and change based on selected file.3. Implement Tab Coloring by Connection

Statements, yes, but SSMS does not support persistent collapsible regions.

BEGIN/END would behave exactly as Regions. You would have to use keywords to do that, but how it is different from region tags.The main limitation of the built-in version that it can't include multiple batches (which might be useful) and go across different blocks (which is a weird edge case IMHO).And SSMS has commands to Collapse/Expand all regions or current region, so you can assign Key ShortCuts for them.

I agree that there is no way to tell SSMS to keep it collapsed after re-opening the file (isn't it true for SSMS Boost Regions as well?)

Important DB Alert placed in "Top Right" corner overlaps and obstructs the of SSMS Find/Replace window in SSMS 2016.It would be nice if "Important DB Alert" would be displayed several lines lower than current position and add an option to make it semi-transparent.

Important DB Alert placed in "Top Right" corner overlaps and obstructs the of SSMS Find/Replace window in SSMS 2016.It would be nice if "Important DB Alert" would be displayed several lines lower than current position and add an option to make it semi-transparent.

Well, it might start to be "overparameterized". Why do not you use "position" for this alert and set it to Right-Middle, for example ?

Well, it might start to be "overparameterized". Why do not you use "position" for this alert and set it to Right-Middle, for example ?

I am using Top Middle for now. But it obstructs code sometimes. I am suing 4K monitors and right-middle is too far from to notice unless I make large.What I really want is tab coloring. At least 2 other products support that feature.

When I try to install SSMSBoostInstaller2016_3.0.6103.20236.msi I get an error that SSMS 2016 must be installed. I do have it installed but have the latest version which was released on 9/23 I believe. My SSMS 2016 version is 13.2.15900.1. Is the setup checking for major version or a specific version?

When I try to install SSMSBoostInstaller2016_3.0.6103.20236.msi I get an error that SSMS 2016 must be installed. I do have it installed but have the latest version which was released on 9/23 I believe. My SSMS 2016 version is 13.2.15900.1. Is the setup checking for major version or a specific version?

Run command prompt (cmd.exe) as administrator and start installation from command line.

We have uploaded next Beta-release (see download links in the head post).Changes:-Restored Guidelines functionality under SSMS 2016.-some minor UI polishing in dialogs-some core and project refactoring

I have the same issue. I installed the latest version of SSMS Microsoft SQL Server Management Studio 13.0.16000.28. Now I get the message 'Execution guard failed to check the script due to internal error.' I disabled the Fatal Actions Guard but that didn't help. Other functionality does not work either like Script Object or Locate Object.

I was also getting the 'Execution guard failed to check the script due to internal error' from SSMSBoost 3.0 beta after upgrading SSMS2016 this week (and some other seemingly harmless 'Object not set' errors). However, when I viewed the error details from the popup it shows several ApexSQL errors, so apparently there's a conflict between the two addins w/latest SSMS2016 build. (I also installed the latest ApexSQLComplete2017 this week)

in regards to the error "Execution guard failed to check the script due to internal error. Do you want to continue script execution?":I don't have ApexSQL installed and never have. if I disable Fatal Action Guard the issue goes away also if I add a space to "SSMSBoost settings\Fatal Action Guard\ Magic unblocking tokens".If you add a space the error goes away but that is the equivalent of disabling it since all your queries will contain a space.

in regards to the error "Execution guard failed to check the script due to internal error. Do you want to continue script execution?":I don't have ApexSQL installed and never have. if I disable Fatal Action Guard the issue goes away also if I add a space to "SSMSBoost settings\Fatal Action Guard\ Magic unblocking tokens".If you add a space the error goes away but that is the equivalent of disabling it since all your queries will contain a space.

Most likely you use latest release of Microsoft SQL Server Management Studio 13.0.16000.28, released 2 days ago. There was a breaking change in the API. We have found and fixed the issue. Update will be published within next 1-2 days.

Updated beta files are now available for download. Links are in the top-topic.Changes:

-Added support for latest SSMS 2016 release (13.0.16000.28) which brought some breaking changes in API causing "Fatal actions guard" to stop working.-Fixed broken sort order of servers, automatically connected in Object Explorer at start-up -Improved behavior of "Comment-Uncomment" feature. It does not require exact positioning of selection to uncomment the block (whitespace and newlines will be ignored.) Also several lines of "--" comments will be uncommented now as well.-Restored "Comment/Uncomment" icon on the toolbar.

It would be really useful to add the start time or completion time to the execution finished notification. Sometimes I come back to an execution window and wonder when I ran the query. I know I can dig that out of execution history but it would be nice to have it in the notification.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.