Solved

Not able to run anything at SQL Server Management Studio

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

Suggested Solutions

Title # Comments Views Activity
How to use odbc in vb to connect to ms sql 14 52
Challenging SQL Update 5 41
sql 2014,  lock limit 5 32
How to search for strings inside db views 4 27
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

776 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