Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL Server Management Studio - Execution Plan erro

Author  Topic 

swilkos
Starting Member

1 Post

Posted - 2011-03-01 : 14:45:22
I've done quite a bit of research on this particular issue, and can not find anyone that has run into this error in regards to an Execution Plan.

Starting a few days ago (I can't pin exactly when or what may have been installed right around it) SQL Server Manamgement Studio began throwing a "Exception has been thrown by the target of an invocation." error whenever I press the "Display Estimated Excecution Plan" or when "Include Actual Execution Plan" is enabled and I run the query to review. This happens on all databases, both user as well as system and I have never come across it before. In addition to the error, and I'm certain a releated issue, the query plan does not show up at any time. The tab does not show up in the results at all so I'm guessing it's related to an object on the tab that's failing to instantiate, But what it is, or a fix I do not know.

I have uninstalled, reinstalled SQL Server 2008R2 including moving everything to a different Instance name.

Does anyone happen to have a suggestion for me?

Environment:

Windows 7 - 64Bit
8GB Memory
SQL Server 2008R2 (I even installed 2011's SSMS and it does the same thing!!)

Any thoughts or suggestions are greatly appreciated!

Scott Wilkos
scott@wilkos.net
Development Team Lead - CCS Inc.
   

- Advertisement -