THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andrew Kelly

Debug button in SSMS 2008

How many people are tired of accidentally hitting the toolbar button with the green triangle on it when trying to run a query in the Query Editor only to get into the debug mode?  If you are like me then I bet a lot of you:).  It only seems natural to hit the Green button to run something right?  Especially since it is right next to the execute button to begin with. Maybe if you are more of a developer and use Visual Studio a lot its not so bad. Well I got tired of it real quick so I simply removed it from the toolbar altogether and no longer have to think about it.  For those few times you really want to debug the script you can still access it from the menu or by hitting Alt - F5.  These are such simple solutions but we tend to forget about them so this is just a reminder that you can control your SSMS life after all:).

Published Wednesday, September 17, 2008 5:44 PM by Andrew Kelly
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



AaronBertrand said:

The biggest problem with this is that Query Analyzer's Execute button was a green arrow, that looks remarkably similar to the Debug button in SSMS 2008.  So the hardest hit by this change are going to be people who skip 2005 and go right from 2000 tools -> 2008 tools.  They are going to be so used to clicking the green arrow that it will take them a while to train themselves that this button now has a different meaning.  Hopefully they will see your post and/or be smart like you were and remove the button altogether.

September 17, 2008 5:20 PM

Andrew Kelly said:


You know it has been so long since I have had 2000 installed on my machine that I forgot it was that way in QA. I was thinking it was from VS but now that you mention it I can see why I was so driven to click on it:).

September 17, 2008 5:36 PM

Kalen Delaney said:

This is really weird... but I had absolutely not noticed there was a green arrow in SSMS 2008 until I read this post. And now it is absolutely jumping out at me and it's all I can do to keep from clicking it.

Yuck... away with it, NOW!


September 17, 2008 7:11 PM

jerryhung said:

I hate that Green button too (partially it's besides Execute, partially from SQL 2000 QA)

so today, after learning I am not the only one

I decided to customize my toolbar, and re-arranged it all the way to right (right next to IntelliSense Enable button)

no more hitting it by accident

September 18, 2008 10:38 AM

Lane Sandness said:

What's worse is the green arrow while working with Reporting Services actually DEPLOYS .rdl files to the active platform.  I made that mistake once and ended up having to go backup (luckily I had made a copy of all the .rdl files on the server) to get the production versions back on the production reporting server, then quickly disabled the production deployment configuration to avoid ever making that mistake again!

Now that I don't use Query Analyzer much anymore, it's not such a problem, but last year it was difficult to remember that the icon had different behavior among related Microsoft products.

September 19, 2008 6:19 PM

Chris Leonard said:

Thanks for pointing this out - I use the Execute button or the keyboard shortcuts, and never even noticed it.  

I know this is an old thread, but an easy solution is to alt-drag the button off the toolbar.  

The sad thing is that somebody in Redmond thought this was a good idea?

September 26, 2008 12:14 PM

Leave a Comment


This Blog


Privacy Statement