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 have
one, you can download it under this URL:
http://www.ssmsboost.com...chive/SSMSBoostInstaller {version}.msi
Just replace {version} with version number, your system is asking you for.

3.0 RC2
Fixed start-up issues, that happened sometimes with "Open empty query window" option set in preferred connections

3.0 RC1
NEW 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


Download link for all SSMS versions: 2008/2008R2, 2012, 2012SP2, 2014, 2016, 2017
(Updated on 7-th of July, 2017)
http://www.ssmsboost.com/beta/SSMSBoostInstaller_3.0.6397.msi 

If you get "SSMS 20XX is not installed" message during the installation, please start installation from cmd.exe running with administrative privileges and send us short notice to our support@ e-mail.

Update on 24-th of August:
Added Beta for SSMS 2016. See link above.

>>Please write comments and proposals here, we are always happy to get the feedback !

We need the realization of the new features in formatter described in the post #5 in forum branch here:

http://www.ssmsboost.com...atter--published-in-2-13 

It's very important for us, as we can't format existing code (to satisfy our corporate standards) with current formatter.

if more donation can speed up progress - write me, please. Thank you!

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 connections
Even 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 box
2. 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.

I have the same exact situation.

Thanks, we are working on all reported issues and will release updated beta around 7-th of September

Cheers for this link, Community version expired today :)

Regards

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

I installed the beta today and have had several out of memory issues and subsequent SSMS crashes, so I am going to have to deinstall it.

However, I have saved the ActivityLog.xml file which was created when SSMS crashed. If you would like me to send it to you, please provide an e-mail address.

In addition to statements it supports batches and blocks such as BEGIN/END: https://msdn.microsoft.c...us/library/cc281835.aspx 

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?)

Try the query below in SSMS 2012 - 2016:
BEGIN -- This is SSMS built-in region - Region 1
BEGIN -- This is SSMS built-in region - Region 2

SELECT *
FROM sys.objects o
WHERE 1=0

SELECT *
FROM sys.objects o
WHERE 1=0

SELECT *
FROM sys.objects o
WHERE 1=0

END


SELECT *
FROM sys.objects o
WHERE 1=0
END

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.

Hi, it is very valuable, please send it to support@ address.
thank you !
Please mention also in the e-mail, if you have some other add-ins installed.

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.

If I start SSMS and if use "Pick Recent Session..." when there is no Query Window Opened (Object explorer is connected) some of the restored query windows are "Disconnected" (no connection).

For the "Try to switch to data with the same name ..." option under Preferred Connections Settings. Could it check for the existence of the database before attempting to login?

At the moment it appears to be attempting to blindly login to the current database on the new connection.

This results in messages like


I know this will drive some auditing round the bend with all these "failed login" messages.


Cheers
Phil

UPDATE: New Beta release:

Changes:
-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 in "Find column" dialog (Ctrl+F in results grid)
-Restored Grid Visualizers functionality in SSMS2016 (was temporary disabled)
-ENTER starts search in "Search in History"
-SSMSBoost for SSMS2016 installer fix (on some installations installer would say that SSMS2016 is not installed)
-Performance improvements and bug fixes (mostly in SSMS2016 version)
-Position of "Important DB Alert" improved for Right-Top case in SSMS 2016 (was covering Find/Replace dialog)
-Fixed issues with scripting of Triggers on SQL2005 and older databases
We wait for your feedback. Please post also "positive" feedback, if you feel that everything is working "well".

Just updated install for SSMS 2016: http://www.ssmsboost.com...r2016_3.0.6103.20236.msi 
Users, who experienced problems with installation should try this new install.

Note: If you get "Can not Install, SSMS 2016 not found" message, please run .msi file from command line with administrative rights. (cmd.exe->Run As Admin, then just run the .msi)

Hi

am using latest beta for ssms2008 v:2008_3.0.6102.26341

working fine except that I get regular errors in query results:
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

haven't noticed a way to reproduce, ie its not when running particularly long/complex queries

thank you

All users, experiencing unreasonable slowdowns or System.OutOfMemoryException's: please update to latest SSMS 2016 version, which was released on 20-th of September:
Microsoft SQL Server Management Studio 13.0.15800.18
This update particularly solves problems on systems with Visual Studio Enterprisse edition, installed along with SSMS 2016 and SSMSBoost.
Please post short info here, if it helped.

Just a quick note to let you, and anyone else, know that since downloading the latest update to SSMS 2016 on Monday (26th Sept) the latest SSMSBoost 3 beta has been working really well.

Where is the last Beta for download?

When should be expecting the public release?

Thanks

Carlos

In SSMS 2016, I can't define shortcuts in the Shortcuts & Macros tab.
It happens either I choose "Shortcut - force override" or not.
Thank you.

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

Updated version for SSMS 2008.
Fixedd issue where some buttons were without Icons under windows XP.

It may be on the list already, but I'd love to see the "Comment Selected" button come back. It's a small thing, but I used it all the time.

Thanks!

Hello,

First I wanna thank you for an awesome product 😁

In SSMS 2016 i have problem to open projects, just after the project opens I get a message "SSMS has stopped working" and it crashes.

In event viewer I get this .NET error:

Application: Ssms.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException
at SSMSBoost.Reflection.ReflectionUtils.GetNonPublicField(System.Object, System.String)
at SSMSBoost.Reflection.ReflectionUtils.GetNonPublicField[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Object, System.String)
at SSMSBoost.Features.AlertTips.AlertTipsService.cg7O9Ekx35()
at SSMSBoost.Features.AlertTips.AlertTipsService.dLlOawHDMa(System.Object, System.EventArgs)
at System.Windows.Forms.Timer.OnTick(System.EventArgs)
at System.Windows.Forms.Timer+TimerNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)

I always start SSMS with an other account.

Hope it can be solved in future releases.

EDIT: Doesn't matter if I run as Administrator or not

TIA

David Edmark

Dowloaded the last beta 3.0.6124.25840 Build Date 2016-10-07 and using with SSMS 16.5 (released on 10/26) and every time that I try to run a query I got a popup

---

SSMSBoost

---

Execution guard failed to check the script due to internal error. Do you want to continue script execution?

---

Yes No

---

javascript:__doPostBack('forum$ctl03$PostReply','')

I agree. I have the same issue. I installed this morning the latest version of SSMS.

Microsoft SQL Server Management Studio 13.0.16000.28

and now get the message mentioned.

I have uninstalled SSMSBoost and reinstalled with the same error resulting.

Mike

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 have uninstalled SSMSBoost and reinstalled with the same errors.

FYI: 'Execution guard failed...' error resolved!

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)

I uninstalled ApexSQLComplete2017 and the errors went away.

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.

Thank you. The new update resolved the issue with SSMSBoost.

Mike

Thanks SSMSBoost for the update.

I've installed 3.0.6149.29062 in Microsoft SQL Server Management Studio 13.0.16000.28 and still get this error:

Right click on an object and "Locate object in Object Explorer" gives error "Error occurred while parsing identifier".