Decoding SQL Profiler .trc files into text?

Is there a method available to turn a Profiler .trc file into its text
equivalent? We would like to run some parsing tools against Profiler files
but they need to be in some form of delimited text. Doesn't it?
I think you would have to use fn_trace_gettable first to load it into SQL
and then export the table to a text file. In SQL2005 you can use SMO to read
a trace from code (e.g. C#,VB.NET) and do what you want with it. You can
also read running traces using both SMO and fn_trace_gettable (in SQL2000
the trace has to be stopped in order to acces it).
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:035B663B-AA0A-4CAE-A1EA-92D2114DC1FB@.microsoft.com...
> Is there a method available to turn a Profiler .trc file into its text
> equivalent? We would like to run some parsing tools against Profiler
> files
> but they need to be in some form of delimited text. Doesn't it?

DeBugging

Ive been given the Schema's for XML files we will be sent. Ive managed to
struggle to get this far using SQLXML , and im at loss of where to turn next.
Im very new to the whole XML format, and the Schema's given have include
statements which doesnt help. Im getting this error ;
<?xml version="1.0"?>
<Result State="FAILED">
<Error><HResult>0x8000FFFF
</HResult>
<Description><![CDATA[Schema: relationship expected on
'OriginatingAccount'.]]>
</Description>
<Source>Schema mapping</Source><Type>FATAL</Type></Error></Result>
but have no idea where to start looking to fix the problem. Is there a way i
can debug the process, and at least manage to find which schema is causing
the problem
Find the element declaration for "'OriginatingAccount'" and add the
necessary relationship annotation for the mapping.
Best regards
Michael
"Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
news:BD8789F4-507F-47D9-A2C4-F7CF22CACE94@.microsoft.com...
> Ive been given the Schema's for XML files we will be sent. Ive managed to
> struggle to get this far using SQLXML , and im at loss of where to turn
> next.
> Im very new to the whole XML format, and the Schema's given have include
> statements which doesnt help. Im getting this error ;
> <?xml version="1.0"?>
> <Result State="FAILED">
> <Error><HResult>0x8000FFFF
> </HResult>
> <Description><![CDATA[Schema: relationship expected on
> 'OriginatingAccount'.]]>
> </Description>
> <Source>Schema mapping</Source><Type>FATAL</Type></Error></Result>
> but have no idea where to start looking to fix the problem. Is there a way
> i
> can debug the process, and at least manage to find which schema is causing
> the problem

Debug output no longer displaying?

I must have hit some setting to turn off the debug output, but I can't find how to get it back on. The debug output window displays when I execute a package, I just don't get the execution output I had been getting. Sorry to bother you with such trivia, but any help you can provide is appreciated. Thanks.

If I understand you correctly, then what you are looking for is under 'View - Output'.

Pipo

|||That's what I am looking at, but the output window is empty - nothing is being generated in the window when I execute the package. It had been before - just not anymore.|||Got it. When I right click within the output window the option for program output was not checked. When I clicked on that option to set the check on, I then began to get the output trace again.