• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Execution plain in SQL 2005

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
bozer
Asked:
bozer
  • 2
  • 2
1 Solution
 
NightmanCTOCommented:
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
 
bozerAuthor Commented:
Thanks, how did I miss that - It was also on the toolbar
0
 
NightmanCTOCommented:
>>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
 
bozerAuthor Commented:
:)

Have a good day
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now