Solved

Not able to run anything at SQL Server Management Studio

Posted on 2011-09-15
5
379 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:crazywolf2010
  • 2
  • 2
5 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36542294
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
 

Author Comment

by:crazywolf2010
ID: 36542316
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
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36542326
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
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36542349
As like in F10 in .Net environment to dry run (Step by step execution) or code same like that.
0
 

Author Closing Comment

by:crazywolf2010
ID: 36542428
Issue Resolved
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question