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 220.127.116.118 on SSMS 11.0.5058.0 (2012).
Thanks for your help tracking this down! I’ve made a fix for the permission issue here:
Which should work without having to run as an administrator. We’ll look into getting this included in the SQL Search and Developer Bundle installers.
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.
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.
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 18.104.22.168) 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. 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.
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.
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
this bug is precisely why I have not purchased it. Something as simple as toolbar persistence and you can't get it right...