Posted by Danny on 07/14/05 15:41

Thanks Erland. I find it interersting that the execution plan is stored in
TextData but the show plan is stored in BinaryData.

Danny
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96936F3E9F270Yazorman@127.0.0.1...
> Danny (someone@nowhere.com) writes:
>> That may work as a manual solution to find and view a few records. But
>> I'm looking for a way to automatically capture the show plan
>> information.
>>
>> Surprising I haven't been able to find anything on it in BOL or the Net.
>
> OK. I have directed a question to Microsoft, so see if I can find out
> anything.
>
> I looked at the description in Books Online, and found that it was
> completely wrong. What is in BinaryData, it has in TextData.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]