|
|
Posted by Jack Vamvas on 09/21/06 13:18
One way to do this task is: Set up a Profile Trace and add Show Plan
event , save the info , and filter with the SPID
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________
"Thyagu" <tdelli@gmail.com> wrote in message
news:1158834419.604983.220140@m7g2000cwm.googlegroups.com...
> Hi,
>
> Is there a way to findout the query plan of the executing process using
> the SPID/KPID information.
>
> Thanks in advance,
> Thyagu.D
>
Navigation:
[Reply to this message]
|