Stanley Pagenel (4/8/2008)
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 5, Line 1
'SHOWPLAN_XML' is not a recognized option.
Msg 195, Level 15, State 8, Line 1
'XML' is not a recognized statistics option.
Thanks
SET SHOWPLAN_XML is a SQL Server 2005-specific option (or rather - introduced in 2005 and later versions). It needs to be run against a SQL 2005 database engine. Your data is running against a SQL 2000 engine, so that setting doesn't exist.
Your options would be SHOWPLAN_TEXT or SHOWPLAN_ALL.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?