Solved

Execution plain in SQL 2005

Posted on 2007-12-03
4
280 Views
Last Modified: 2011-09-20
Hello experts,

I can't find the execution plan's graphical interface on SQL 2005. I saw the text version with "showplan_text" but I can't see the classic view.

Thanks
0
Comment
Question by:bozer
[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
4 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 50 total points
ID: 20395175
In management studio, press CTRL-M (or click the query menu, and select "include actual execution plan")

This will show as a separate tab in your results window
0
 

Author Closing Comment

by:bozer
ID: 31412304
Thanks, how did I miss that - It was also on the toolbar
0
 
LVL 29

Expert Comment

by:Nightman
ID: 20395323
>>how did I miss that

You'd be surprised. Some time back I spent two hours trying to debug a procedure on a server, not understanding why none of my changes were reflected in the system. And then discovered that I was changing the proc on Server A and testing on Server B.

So anything is possible ... :-D
0
 

Author Comment

by:bozer
ID: 20395386
:)

Have a good day
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL joins 9 58
SSRS report parameters set after publishing to report manager 1 84
Help with simplifying SQL 6 55
What Is an Error? 2 59
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
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…
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…

738 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