Execution Plan of a CLR Stored Procedure?

Hi,
Is it not possible to view the Execution Plan of a CLR Stored Procedure?
I have set (Ctrl + M) Include Actual Execution Plan.
Thanks,
Clive.C (C@.discussions.microsoft.com) writes:
> Is it not possible to view the Execution Plan of a CLR Stored Procedure?
> I have set (Ctrl + M) Include Actual Execution Plan.
It is. You can capture it in Profiler. Grab the the Showplan:XML event.
You will see the graphical plan as in Mgmt Studio.
But in Mgmt Studio or Query Analyzer you can't get the plan. I've noticed
that too.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||OK. Thanks for that.
"Erland Sommarskog" wrote:

> C (C@.discussions.microsoft.com) writes:
> It is. You can capture it in Profiler. Grab the the Showplan:XML event.
> You will see the graphical plan as in Mgmt Studio.
> But in Mgmt Studio or Query Analyzer you can't get the plan. I've noticed
> that too.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>