Wednesday, April 20, 2011

Getting SQL Server Execution Plan through SMO?

I know I can get the execution plan in Management Studio in XML format using "SET showplan_xml ON".

Is there a way to get the same information through .NET code?

From stackoverflow
  • SET is just a normal sql command, so if you can send an arbitray string to the server, send "set showplan on".


Post a Comment