Posted by Danny on 07/14/05 04:00

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.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96935937189Yazorman@127.0.0.1...
> Danny (someone@nowhere.com) writes:
>> There must be a way to convert the binarydata field in the SQL trace
>> output to text data when the event type is a show plan. SQL Profiler
>> does it but how can it be done from an imported table?
>
> What if you open the table in SQL Profiler?
>
>
> --
> 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

• Next in forum: Need help with Importing XML data to a table
• Prev in forum: Re: How to convert binary trace data
• Thread view: Re: How to convert binary trace data

[Reply to this message]