Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: User interface

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Remove Red Gate toolbar

This is an old problem that just won't go away.

The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.

Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.

Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).

6 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

leMec shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Stephen commented  ·   ·  Report

    Running as Administrator worked for me.

    (In case some, like me, aren't familiar with how to do this permanently for Windows 8.1, Shift+Right-click the taskbar icon and on the Properties pop-up, check the Compatibility page's "Run this program as an administrator." You could elect to click the "Change settings for all users" if you have elevated UAC rights and set it for everyone who may use the machine.)

    Having fired up SSC, performed a Commit, and Exited SSMS, I did get the frequent Windows App Died Poorly dialog, but I dismissed with a "Worked Properly" button-click. SSC has a bad habit of wrecking SSMS shutdown - this being 2-for-2 on machines I've used it on.

    Restarted SSMS, before setting the Run as Admin property, the toolbar was hidden.

    Hope this helps.

  • leMec commented  ·   ·  Report

    You nailed it - it's a permissions issue.

    #1 worked as long as I only deselect the toolbar. If I delete the toolbar, it comes back - which is probably a good thing as long as it stays where you put it.

    I did some further testing. Interesting that the position of the toolbar is now persisting when moved as an Administrator. This was actually the reason I wanted to delete/hide it in the first place. The d@!m thing kept moving back to its own row and shifting everything down. Since it's staying put now, I will not have to hide it.

    I cannot test #2 since I do not have the SQL Source Control product installed.

    Thanks. I hope you can integrate a permanent solution.

  • AdminAaron Law (Admin, Redgate) commented  ·   ·  Report

    Just a quick update, It looks like there might be two different issues:

    1) The framework used for SQL Search and a few other tools (which shows the "Add-ins" button) is having a permissions error trying to save some of its options to registry, resulting in the bar being made visible on startup. You might be able to fix this by running SSMS as an administrator, hiding the bar, then closing SSMS. I'm looking into a proper fix now.

    2) There's a possible race condition which I can recreate on a VM with SQL Source Control and Prompt installed that's causing the toolbar to be recreated every other startup. Uninstalling Source Control fixes this for me, and oddly enough even after reinstalling it stays fixed (maybe by changing the startup order)

    If possible, please use the latest Prompt (currently 6.4.1.164) and let me know if running SSMS as an administrator and/or uninstalling SQL Source Control helps so I know I'm going down the right track.

    Thanks,
    Aaron.

  • Stephen commented  ·   ·  Report

    Thanks Aaron. I'm using SSMS2014 on a brand new Dell Precision Desktop, OS is Windows 8.1 Pro, and I still can't get it remain invisible after restarting either SSMS or the machine itself, which appears at variance with you experience. Let me know if you need any time to take a remote session look.

  • Stephen commented  ·   ·  Report

    Even tried the SSMS Integration Pack Framework "repair". Still can't get rid of this nuisance! AND there's a long-running Forum thread equally being (seemingly) ignored.

  • leMec commented  ·   ·  Report

    Any feedback?

    I don't believe that the visibility and position of the toolbar is intrinsic to the functioning of the product. Come on, you have a GREAT product. This should be "ingeniously simple" to tweak. :)

  • Chris Millensifer commented  ·   ·  Report

    this bug is precisely why I have not purchased it. Something as simple as toolbar persistence and you can't get it right...