Solved

Not able to run anything at SQL Server Management Studio

Posted on 2011-09-15
5
375 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

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…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now