SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Originally Posted by: Clint R

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".




Fixed. Updated files are listed in head post.
SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Originally Posted by: ddaiker

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.



Done. Download updated beta
SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
So, today (4 November), we have updated beta version again.
-Additional fixes were made to support latest version of SSMS 2016 (13.0.16000.28). Code formatting, Locate/Script object and Code guard features are work again
-{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:

Document: {DocumentTitle}
Execution result: {Result}
Connection: {Connection}
Started: {StartTime:HH:mm:ss} Ended: {EndTime:HH:mm:ss}
Duration: {Duration}


Clint R
  • Posts: 2
  • Joined: 11/1/2016
Originally Posted by: SSMSBoost

Originally Posted by: Clint R

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".



Fixed. Updated files are listed in head post.


Thank you for fixing these issues. Now running 3.0.6151.40538 it is improved, but still either failing completely or flakey. Mostly failing on a production system, so maybe the slower connection has something to do with it, or the fact that it is a different version of MSSQL being used on production (Microsoft SQL Server Management Studio 12.0.4100.1).

On a production server with database connected in the object explorer I right click the object from a select statement:

Analysing identifier...
Locating object...
[1 minute and 10 seconds later]
Object could not be found.

On a development server there was also a delay of 1 minute (in past versions it worked within 5 seconds), and then the error is displayed "Object could not be found", even though the object was found.

Then trying locate the object again on dev it is found within seconds, multiple times, so it became fast after multiple tries. So for me it isn't reliable on dev or production. Hope you can find the issue 🙂. Thanks.
kennyG34
  • Posts: 3
  • Joined: 11/8/2016
I have updated to the latest beta version of SSMS boost for SSMS 2014 and the 'restore Session' feature seems to have been broken.

In the version 2 the tabs would be restored along with the associated connections to the database(s).

In beta V3 the tab queries are restored but none of the database connection are. :-(

Thank you for an excellent product. Hopefully this problem can be fixed.

epikarma
  • Posts: 4
  • Joined: 1/28/2013
I've just installed the SSMSBoost 3.0 in SSMS 2014 because I had an issue with the official version but the issue is here again: I can't activate my copy because the buttons are all disabled.

Issue on activation

moronoron
  • Posts: 3
  • Joined: 11/15/2016
Originally Posted by: epikarma

I've just installed the SSMSBoost 3.0 in SSMS 2014 because I had an issue with the official version but the issue is here again: I can't activate my copy because the buttons are all disabled.

Issue on activation



Yes, my trial mode expires tomorrow too, even though I just installed the latest beta seconds ago 😞
Alexander Sharovarov
  • Posts: 18
  • Joined: 4/21/2016
My version is expired. Can't use the tool anymore.
SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Originally Posted by: epikarma

I've just installed the SSMSBoost 3.0 in SSMS 2014 because I had an issue with the official version but the issue is here again: I can't activate my copy because the buttons are all disabled.

Issue on activation



You do not need to activate the Beta. Buttons will be enabled after the release.
SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Originally Posted by: Alexander Sharovarov

My version is expired. Can't use the tool anymore.



Updated Betas were published today. See head post in this thread. Sorry for the delay.

Changelog:
-No visible changes
-Several internal improvements

Please write us if you find any issues.
SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Originally Posted by: kennyG34

I have updated to the latest beta version of SSMS boost for SSMS 2014 and the 'restore Session' feature seems to have been broken.

In the version 2 the tabs would be restored along with the associated connections to the database(s).

In beta V3 the tab queries are restored but none of the database connection are. :-(

Thank you for an excellent product. Hopefully this problem can be fixed.



There is an issue, when queries are restored with connections SET but in Disconnected state. When you press "F5", the connection will be open. Please confirm that you have same behavior.
We will address this issue soon.
Alexander Sharovarov
  • Posts: 18
  • Joined: 4/21/2016
Originally Posted by: SSMSBoost

Originally Posted by: kennyG34

I have updated to the latest beta version of SSMS boost for SSMS 2014 and the 'restore Session' feature seems to have been broken.

In the version 2 the tabs would be restored along with the associated connections to the database(s).

In beta V3 the tab queries are restored but none of the database connection are. :-(

Thank you for an excellent product. Hopefully this problem can be fixed.



There is an issue, when queries are restored with connections SET but in Disconnected state. When you press "F5", the connection will be open. Please confirm that you have same behavior.
We will address this issue soon.



I experience the same issue. I would consider it minor.
I also noticed that if SSMS crashes and a previsouly saved file has unsaved changes they will be lost.
dQuille
  • Posts: 6
  • Joined: 2/8/2013
Originally Posted by: SSMSBoost

Originally Posted by: kennyG34

I have updated to the latest beta version of SSMS boost for SSMS 2014 and the 'restore Session' feature seems to have been broken.

In the version 2 the tabs would be restored along with the associated connections to the database(s).

In beta V3 the tab queries are restored but none of the database connection are. :-(

Thank you for an excellent product. Hopefully this problem can be fixed.



There is an issue, when queries are restored with connections SET but in Disconnected state. When you press "F5", the connection will be open. Please confirm that you have same behavior.
We will address this issue soon.


I can confirm the issue as well. I believe a related issue I see is sometimes when you open up a 'New Query' window, and you already have a query window open, that new window will have the connection set from the original window but the 'Change Connection' toolbar icon will be disabled. The change connection icon becomes usable again after you do an execute or F5 (even if it's an execute on nothing).
kennyG34
  • Posts: 3
  • Joined: 11/8/2016
Originally Posted by: SSMSBoost

Originally Posted by: kennyG34

I have updated to the latest beta version of SSMS boost for SSMS 2014 and the 'restore Session' feature seems to have been broken.

In the version 2 the tabs would be restored along with the associated connections to the database(s).

In beta V3 the tab queries are restored but none of the database connection are. :-(

Thank you for an excellent product. Hopefully this problem can be fixed.



There is an issue, when queries are restored with connections SET but in Disconnected state. When you press "F5", the connection will be open. Please confirm that you have same behavior.
We will address this issue soon.


Hi there,
I can confirm the same behaviour. Although the tab says 'not connected' it is actually connected to the requisite database and F5 to execute a query does work.
So the problem is not as bad as I thought.

Many thanks
Kevin Greiner
  • Posts: 6
  • Joined: 11/2/2015
Two suggestions:

1. Would you consider opening the Settings window non-modal? Currently, it is very tedious to make changes to a formatting style. It requires many open-close-reformat cycles.

2. Add a formatting option to remove unnecessary square brackets. SSMS adds square brackets to object names when generating code, even if they aren't needed.
SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Originally Posted by: Kevin Greiner

Two suggestions:

1. Would you consider opening the Settings window non-modal? Currently, it is very tedious to make changes to a formatting style. It requires many open-close-reformat cycles.


There is interactive Format editor: look into menu SSMSBoost -> Query-> SQL Format Styles editor

Originally Posted by: Kevin Greiner


2. Add a formatting option to remove unnecessary square brackets. SSMS adds square brackets to object names when generating code, even if they aren't needed.


We have this already in our to-do list. Will be addressed.
Thank you !
Thomas Franz
  • Posts: 21
  • Joined: 6/29/2015
Two change requests:
  • I attached the Find column in Grid (super useful!) window to the property window, but every time I restart my SSMS this window is hidden and I have to enable it again. It would be nice, if it could be visible by default / option

  • The Show Grid Aggregates (set to Autoshow / Autohide) is very useful too - except you query a very large data warehouse table with lot of columns and e.g. 500k lines and select all, because you want either to script it out or just copy it. In this case the Grid aggregate kicks in an uses 1-2 minutes summing and counting my customer numbers, zip codes and other useless stuff. So it would be nice if the aggregate modul would ask me (button in the aggregate window), if I would really want to aggregate the selected stuff, if I have selected very much data (lines * columns > x, while x (e.g. 10 mio) could be configured)

SSMSBoost
  • Posts: 287
  • Joined: 6/30/2012
Hello Thomas
Originally Posted by: Thomas Franz

Two change requests:

  • I attached the Find column in Grid (super useful!) window to the property window, but every time I restart my SSMS this window is hidden and I have to enable it again. It would be nice, if it could be visible by default / option

Currently, unfortunately, we can not do this due to closed model of SSMS. But we have a hope with further investigation to be able to do this at least in SSMS2016.

Originally Posted by: Thomas Franz


  • The Show Grid Aggregates (set to Autoshow / Autohide) is very useful too - except you query a very large data warehouse table with lot of columns and e.g. 500k lines and select all, because you want either to script it out or just copy it. In this case the Grid aggregate kicks in an uses 1-2 minutes summing and counting my customer numbers, zip codes and other useless stuff. So it would be nice if the aggregate modul would ask me (button in the aggregate window), if I would really want to aggregate the selected stuff, if I have selected very much data (lines * columns > x, while x (e.g. 10 mio) could be configured)

  • The proposal is reasonable, thank you. Will be implemented.

    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Updated Beta was uploaded today. See links in the head post.
    Improvements:

    -Fixed issue with "recent tabs", when connections were sometimes restored in disconnected state
    -Added {StartTime} and {EndTime} tokens to execution complete notification
    -Added "NULL Count" counter to grid aggregates and improved behavior on NULL values.
    kennyG34
    • Posts: 3
    • Joined: 11/8/2016
    Many thanks for the latest update.
    I can confirm that the 'recent tabs' now restore correctly. (using 2014 version SSMSBoost)
    Sam_SilverCreek
    • Posts: 41
    • Joined: 5/9/2013
    Originally Posted by: João Pedro Lopes

    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.



    I'm having this issue as well.
    TheJoker1974
    • Posts: 5
    • Joined: 11/12/2015
    Originally Posted by: Sam_SilverCreek

    Originally Posted by: João Pedro Lopes

    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.



    I'm having this issue as well.


    Me, too.
    I can define the shortcuts, but they do not work at all.
    E.g. if I use F5/F6 for Text/Grid results, the keys have no effect at all. Even if I create a new shortcut for just setting results to grid (without execute) with F5 and eliminate the original shortcut from studio's option, there is no effect.....

    Regards
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    New beta release was uploaded.
    Latest "visible" addition is:
    -Grid aggregates can be configured to stop automatic calculations, if there are too many cells selected in the grid. See settings.

    Latest issue, we are working on is Shortcuts/Macros functionality in SSMS 2016. The changes in SSMS itself were massive, so we plan to spend next week on this issue.

    Please note: this beta release will work until 15.01.2017. We will release new version util it's expiration.
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Originally Posted by: Thomas Franz

    Two change requests:

    • I attached the Find column in Grid (super useful!) window to the property window, but every time I restart my SSMS this window is hidden and I have to enable it again. It would be nice, if it could be visible by default / option

    • The Show Grid Aggregates (set to Autoshow / Autohide) is very useful too - except you query a very large data warehouse table with lot of columns and e.g. 500k lines and select all, because you want either to script it out or just copy it. In this case the Grid aggregate kicks in an uses 1-2 minutes summing and counting my customer numbers, zip codes and other useless stuff. So it would be nice if the aggregate modul would ask me (button in the aggregate window), if I would really want to aggregate the selected stuff, if I have selected very much data (lines * columns > x, while x (e.g. 10 mio) could be configured)


    The limit for automatic calculations is now implemented. Check latest Beta.
    dQuille
    • Posts: 6
    • Joined: 2/8/2013
    Fighting against the trial time limit on these Beta's is getting old... It's a pain when the limit expires and the next time I open SSMS I can't restore my last session! But it just goes to show you how dependent you become on some of SSMSBoost's features once you've been using them for a while. 🙂
    ftkalcevic
    • Posts: 6
    • Joined: 8/11/2015
    Originally Posted by: SSMSBoost

    Please note: this beta release will work until 15.01.2017. We will release new version util it's expiration.



    It's the 15th January on this side of the planet. My version has expired and all the SSMSBoost features are disabled. Any news on a new build?

    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    We have just uploaded the updated beta with extended period. Please see links in the head post of this topic.
    We are still working on the Shortcuts/Macros for SSMS 2016 and plan next beta in next 10 days with this functionality working + improvements of several issues.
    Stay tuned.
    kleinux
    • Posts: 2
    • Joined: 6/23/2016
    Originally Posted by: SSMSBoost

    We have just uploaded the updated beta with extended period. Please see links in the head post of this topic.
    We are still working on the Shortcuts/Macros for SSMS 2016 and plan next beta in next 10 days with this functionality working + improvements of several issues.
    Stay tuned.



    I've reread the first post of this thread so I understand licensing is disabled for beta, but when I install the latest beta it says I'm expired. All boost features are disabled. What can I do to re-enable them? I am using SSMS 2016 and SSMSBoostInstaller2016_3.0.6201.27007.msi
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Originally Posted by: kleinux

    Originally Posted by: SSMSBoost

    We have just uploaded the updated beta with extended period. Please see links in the head post of this topic.
    We are still working on the Shortcuts/Macros for SSMS 2016 and plan next beta in next 10 days with this functionality working + improvements of several issues.
    Stay tuned.



    I've reread the first post of this thread so I understand licensing is disabled for beta, but when I install the latest beta it says I'm expired. All boost features are disabled. What can I do to re-enable them? I am using SSMS 2016 and SSMSBoostInstaller2016_3.0.6201.27007.msi


    You are using old version. Please download latest one (links are in the first post of this thread)
    niemrawyborsuk
    • Posts: 4
    • Joined: 1/19/2017
    Is there a way to move contex menu items added by plugin to the bottom of the menu? I'm having an issue with Registered Server contex menu that is not customizable from GUI level. Clicking on the "Expand All" instead of the "New Query" is quite irritating.
    StellarSteve
    • Posts: 2
    • Joined: 1/25/2017
    Hi,

    I've been using the Results Grid scripting capability, using the INSERT INTO template, and have noticed that when I put a table name into the Specify Parameter Values that has requires a schema name, the resulting table name is wrapped in square brackets. As the table name is wrapped completely, the generated SQL is invalid.

    For example, if I enter the table name AdventureWorks.DimDate, the resulting script shows as :

    INSERT INTO [AdventureWorks.DimDate] ([DimDateKey].....


    The script should read as :

    INSERT INTO [AdventureWorks].[DimDate] ([DimDateKey].....


    Thanks,
    Steve

    EDIT : I've edited the XML for the template to include an additional schema parameter, which is then appended to the table name with a period between, to work around the problem. Thanks!
    Alexander Sharovarov
    • Posts: 18
    • Joined: 4/21/2016
    SSMS Boost team, thank you for your great job. It is really nice to see the improvements you are making.

    I would like to ask you about a couple of enhancements/fixes:

    1. In previous versions (at least prior to v3) if you call "Script Object as Alter" on a table it would script the table. But it gives an error now saying that "No suitable objects found at cursor position". It would be nice to have it back. When you explore an unknown table, it makes it easier to review table structure and related objects.

    2. SQL Server 2016 SP1 supports "CREATE OR ALTER" syntax. IT would be nice to have an option to use that syntax instead of "Alter" (it can optional configuration)

    3. "Reparse/Refresh Regions" wipes out collapsable sections SSMS creates automatically on sections like BEGIN/END
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Originally Posted by: Alexander Sharovarov

    SSMS Boost team, thank you for your great job. It is really nice to see the improvements you are making.

    I would like to ask you about a couple of enhancements/fixes:

    1. In previous versions (at least prior to v3) if you call "Script Object as Alter" on a table it would script the table. But it gives an error now saying that "No suitable objects found at cursor position". It would be nice to have it back. When you explore an unknown table, it makes it easier to review table structure and related objects.

    2. SQL Server 2016 SP1 supports "CREATE OR ALTER" syntax. IT would be nice to have an option to use that syntax instead of "Alter" (it can optional configuration)

    3. "Reparse/Refresh Regions" wipes out collapsable sections SSMS creates automatically on sections like BEGIN/END



    Thank you, we will check the issues. #2 will be considered for v.3.1
    theremon
    • Posts: 1
    • Joined: 2/3/2017
    Hello guys

    first of all thanks for the great tool.
    I've been using it with a community license for quite some time now and it is a great help. However, the beta version I've been using (the latest release for SSMS2014, 3.0.6224.39758) has locked up, even though it says I've got 18 more days of trial when strarting SSMS (in the about dialog it says that my trial is over).
    Since there is no activation system available yet for v3.0 beta, I'd like to ask if there's going to be a new version released soon?

    Thanks a lot


    [Edit]
    Guys, a couple of restarts and re-installs later, things got normal again... Dunno why - the wonders of high tech. So, never mind my nagging.
    Even though, the question about when the next release is estimated, still stands even though I bet you've replied a million times already...

    Thanks again
    Andrej Kozionov
    • Posts: 3
    • Joined: 12/13/2016
    Hi.

    I update for new version (the latest release for SSMS2016, 3.0.6224.39786 Build Date: 2017-01-15) but i see reminder: You have 8 days ....

    I have tried reboot and delete -> install SSMS2016 many times .... but no any changes :(

    What is problem ?

    Thanks a lot
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Originally Posted by: Andrej Kozionov

    Hi.

    I update for new version (the latest release for SSMS2016, 3.0.6224.39786 Build Date: 2017-01-15) but i see reminder: You have 8 days ....

    I have tried reboot and delete -> install SSMS2016 many times .... but no any changes :(

    What is problem ?

    Thanks a lot



    Hey - 8 days are 8 days ! ;)
    Next beta release is coming in 2 minutes...
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    We are happy to provide you with latest beta release. We finally managed to implement full support of commands/shortcuts in SSMS 2016 and have done a log of internal refactoring work.
    This is final beta, we will not be adding any new features till final release now, but will certainly do our best to fix all reported issues.
    Please read the changelog for this update and pay attention to features, that were changed.
    Thank all of you for the comments and reports, that you have sent us !

    -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 additional events for saving "Recent Tabs". See "Recent Tabs" settings. Improved management of Recent Tabs/Recent Sessions/Recent Connections management.
    -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.
    -Added "close all" (result tabs) for "Find in Grid" and "Find in History" dialogs.
    Thomas Franz
    • Posts: 21
    • Joined: 6/29/2015
    Originally Posted by: SSMSBoost


    -Improved "Query complete" notification icon in system tray. Now dbl-click activates the query window, where the execution completed.



    This is very useful, but why did you not add this to this yellow "post-its" in the top right corner?

    BTW: those notes about the finished queries are useful too, but would be more useful, if you could the timestamp when the query was finished after the duration (sometimes I forgot to close this notes and become confused, which query was finished when, particularly when I run multiple slow queries at the same time).
    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Originally Posted by: Thomas Franz

    Originally Posted by: SSMSBoost


    -Improved "Query complete" notification icon in system tray. Now dbl-click activates the query window, where the execution completed.



    This is very useful, but why did you not add this to this yellow "post-its" in the top right corner?

    But this is done already: you have this message in SSMS in the top right corner, if SSMS is active. Tray message appears when you switch to other application

    Quote:


    BTW: those notes about the finished queries are useful too, but would be more useful, if you could the timestamp when the query was finished after the duration (sometimes I forgot to close this notes and become confused, which query was finished when, particularly when I run multiple slow queries at the same time).


    You can customize message text in Settings / Query post-execution handlers.

    SSMSBoost
    • Posts: 287
    • Joined: 6/30/2012
    Alle v2.0 licenses will be automatically migrated to v3.0 licenses.
    We strive to release final v 3.0 as soon as possible.
    • 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.