Matt is there anyway I can do that in a 2000 environment.

Can someone help me I would like to save the execution plan using SQL management studio. But I'm still having the error telling me that :

Msg 195, Level 15, State...

Thank you Tod your suggestion was apply and the query run faster than before.

Im Using 2005 to display the plan, but my data its in 2000

As mention on microsoft site I try to save the Execution plan as follow

http://technet.microsoft.com/en-us/library/ms190646.aspx

But I received those errors

Msg 195, Level 15, State 5, Line 2

'SHOWPLAN_XML' is not...

Grant here is the Query execution plan :

StmtText

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT MSP_RESOURCES.RES_EUID,MSP_WEB_PROJECTS.PROJ_NAME AS ProjName, MSP_TASKS.TASK_NAME AS TaskName, MSP_WEB_RESOURCES.RES_NAME AS ResName,

...