Solved

Not able to run anything at SQL Server Management Studio

Posted on 2011-09-15
5
380 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 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