Support for StmtCursor and CursorPlan

[costinBol]

cursorPlan.sqlplan.txt
Hello Justin,

First of all, I have to say - great idea! This is a very useful tool, especially since the only way of viewing a SQLPLAN is using SSMS.

The question I have for you is whether you're planning to support the whole array of elements in the the schema: http://schemas.microsoft.com/sqlserver/2004/07/showplan/

In the attached file, you can see elements such as StmtCursor and CursorPlan, which don't seem supported in your XSLT.

Thanks,
Costin

[JustinPealing]

Goal is to support the whole schema, but I didn't have any example plans with those elements.

Thanks for the example - I've re-purposed this issue for the support of those elements. Looks like the other top-level elements that aren't currently supported are:

• StmtCond (Raised issue Support for StmtCond #23)
• StmtUseDb (Raised issue Support for StmtUseDb #24)
• StmtReceive

Not sure how to create a test execution plan that includes StmtReceive elements.

[JustinPealing]

This is mostly completed, just need icons, plus description tooltips for Keyset and SnapShot cursor types, as well as for PopulateQuery and RefreshQuery operation types.