An error occurred while executing batch. Error message is: Error processing…

You might get the following error in SQL Server Management Studio version 2008 R2:

An error occurred while executing batch. Error message is: Error processing execution plan results. The error message is:The type initializer for 'Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanNodeBuilder' threw an exception.There is not enough space on the disk.

I believe that the error was caused in my situation by RedGate’s Data Compare/Deploy feature and running out of space. I got the error while trying to do an execution plan, but had previously gotten a similar error when I did a large data compare; I noticed that RedGate creates a temp file on c:\ and that’s not a good place if you’re doing a large compare.  After I cancelled out and had been working for a bit, I tried a Display Execution Plan and got the error again.  Close out of SSMS and try again to clear up the error.

Thanks,
Lee

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