Include the actual execution plan in the query analyser - Error

  • Hi all,

    When i try 'include the actual execution plan' in the query analyser, I get this error, please help.

    The type initializer for 'Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanNodeBuilder' threw an exception.

    Cannot execute a program. The command being executed was "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Documents and Settings\xxxxxxxx\Local Settings\Temp\pmqcodzn.cmdline".

    Please advice.

    Thanks in advance

  • Sounds to me like your copy of Management Studio may be corrupted. I'd uninstall and reinstall and see if that fixes it.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • mailsar (7/10/2008)


    .... "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" ...

    Maybe you should first try to upgrade to SP2 including the latest cumulative update (CU8).

    If the reinstall of SSMS doesn't help out ....

    you may need to reinstall the dotnet framework :crazy:

    Chances are even that will give you an error.

    I use dotnetfx_cleanup_tool to uninstall it.

    Download it here: http://astebner.sts.winisp.net/Tools/dotnetfx_cleanup_tool.zip

    and then reinstall it.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply