Not able to run anything at SQL Server Management Studio

Hi,
I was playing up with some SQL server 2008 parameters and probably enabled a tracing at Management Studio .

Now, I am not able to run any SQL. All I see is "Debugging Query". I have stopped and started SQL server services but no luck so far. Please see attached snap.

Thanks
000324.png
crazywolf2010Asked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
confirm whether you are hitting F5 or the execute button, '!', or you are hitting the debug button (looks like a green "play" icon).  

You can customize the toolbar, and get the debug button out of there.  A lot of people accidently get stuck on it.

0
 
crazywolf2010Author Commented:
Hi,
You are right, I used the green button there by mistake. I cancelled now and using execute. It seem working.
What does a green Debug button do there? How can I customize the toolbar?

Many Thanks
0
 
dbaSQLCommented:
uptop in the menu bar, select Tools, then Toolbars \ Commands.  play around with that a little, you will see how you can add or remove icons from the toolbar
0
 
Alpesh PatelAssistant ConsultantCommented:
As like in F10 in .Net environment to dry run (Step by step execution) or code same like that.
0
 
crazywolf2010Author Commented:
Issue Resolved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.