SQL Profiler - logging to table

12 Sep 2006 5:13 PM

P Brent

I am trying to script creating of a Profiler trace, and would like it to log
to a table.
Is there a way to do this. ? It seems sp_trace_create procedure allows you
to log only to file.

I'd the trace information in a table, so I can query it.
If anyone know how to get trace files back into a tables, that would also
solve my problem.. Thanks,!!

12 Sep 2006 5:56 PM

Jasper Smith

Look at fn_trace_gettable in Books On Line. It allows you to load a trace
file into a table. In SQL2005 you can also use this to qury an actively
running trace (in SQL2000 the trace had to be stopped to load the file). In
SQL2005 you can also use the SMO Trace API to manage traces. There's an
example in the samples C:\Program Files\Microsoft SQL
Server\90\Samples\Engine\Programmability\SMO\Tracer

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

Show quote

"P Brent" <PBr***@discussions.microsoft.com> wrote in message
news:ABE32A2A-E408-4086-B651-78443193C97B@microsoft.com...
>I am trying to script creating of a Profiler trace, and would like it to
>log
> to a table.
> Is there a way to do this. ? It seems sp_trace_create procedure allows
> you
> to log only to file.
>
> I'd the trace information in a table, so I can query it.
> If anyone know how to get trace files back into a tables, that would also
> solve my problem.. Thanks,!!

13 Sep 2006 2:03 AM

Hari Prasad

Hi,

Take a look into this article. This explains about the server side tracing
and loading into a sql server table.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

Thanks
Hari
SQL Server MVP

Show quote

"P Brent" <PBr***@discussions.microsoft.com> wrote in message
news:ABE32A2A-E408-4086-B651-78443193C97B@microsoft.com...
>I am trying to script creating of a Profiler trace, and would like it to
>log
> to a table.
> Is there a way to do this. ? It seems sp_trace_create procedure allows
> you
> to log only to file.
>
> I'd the trace information in a table, so I can query it.
> If anyone know how to get trace files back into a tables, that would also
> solve my problem.. Thanks,!!