Re: SQL Server 2000 Profiler

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 18:36:17 -0000

You can load a trace file(.trc) or multiple if you've specified rollover
into a table using the following syntax

select * into mytracetable
from ::fn_trace_gettable('c:\mytrace.trc', default) 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kevin H" <anonymous@discussions.microsoft.com> wrote in message
news:A7720F84-07A7-41BD-A52B-2110E10FD677@microsoft.com...
> Hi and thank you for your reply Jasper.
>
> So what I am taking from this is that this is an issue and there is not a
way around it in profiler?!?
> I understand I could log it to a table but I dont want to do that because
of other issues.
>
> Is there a sp_ procedure to load a trace file to a table? This way I could
load it when I want or need to.
>
> Thanks,
> Kevin
>
>      ----- Jasper Smith wrote: -----
>
>      This is indeed an issue with Profiler filtering IIRC. What you can do
is
>      save the trace file and load it into a SQL table. Then you have much
better
>      filtering abilities using TSQL.
>
>      -- 
>      HTH
>
>      Jasper Smith (SQL Server MVP)
>
>      I support PASS - the definitive, global
>      community for SQL Server professionals -
>      http://www.sqlpass.org
>
>
>      "Kevin H" <anonymous@discussions.microsoft.com> wrote in message
>      news:000101c3fa4f$1a706600$a001280a@phx.gbl...
>      > Hi and thanks for your help all.
>      > My problem is this:
>      > I am running a trace on "Applicaiton name"  like " SQL
>      > Query Analyzer". The problem is that I am getting a result
>      > set with a large number of rows with the "Application
>      > name "  as a blank. I am not wanting any row that does not
>      > have only "SQL Query Analyzer". I do not want the rows
>      > with blanks.
>      >> I have tried with Not like "" and " "  and still get the
>      > same result set.
>      >> Below is some of the examples I get with blank application
>      > names which I dont want in my results set.
>      >>>> Can someone help me ?
>      >> Thanks,
>      > Kevin  H
>      >> example:
>      >> SQL:BatchStarting IF @@TRANCOUNT > 0 COMMIT TRAN
>      > sa
>      > 3044 86 2004-02-23 15:43:31.357
>      > SQL:BatchStarting set implicit_transactions off
>      > sa
>      > 3044 86 2004-02-23 15:43:31.357
>      > SQL:BatchStarting set implicit_transactions on
>      > sa
>      > 3044 86 2004-02-23 15:43:31.373
>      > SQL:BatchStarting IF @@TRANCOUNT > 0 COMMIT TRAN
>      > sa
>      > 3044 86 2004-02-23 15:43:31.373
>      > SQL:BatchStarting set implicit_transactions off
>      > sa
>      > 3044 86 2004-02-23 15:43:31.373
>      >>

Relevant Pages