Help!! - SQL 2005 Profiler - RPC:Completed event and TextData colu

microsoft.public.sqlserver.tools

15 Nov 2006 12:52 AM

bill k.

Hi,

Botton line is I want to be able to see TextData column with RPC:Completed
event.

from SQL 2005 Profiler
1. connect to SQL server
2. Add Stored Procedures - RPC:Completed event
3. Add TextData column and SPID column
4. Run
5. Wait for few secs, Stop the trace

You see the RPC:Completed event (assume you have RPC calls to sql server)
along with TextData column and SPID column.

Now, please export the above Trace Definition as you want to
programmatically control the start and stop of the trace.

This is the excerpt of that Trace Definition file,

.........
exec sp_trace_setevent @TraceID, 10, 1, @on
exec sp_trace_setevent @TraceID, 10, 12, @on
.........

Column ID 1 represents the TextData column

Now, you run the trace file from SSMS Query Editor, you then stop and close
the trace using, (put your Trace ID)

EXEC sp_trace_setstatus 2, 0;
EXEC sp_trace_setstatus 2, 2;

then open the captured trace file via Profiler, you dont see the TextData
column there and instead the BinaryData column's there. Why is that?

I've tried other Events and the only one displaying as BinaryData column is
the RPC:Completed event.

Can you help?

Thank you,

Bill