Re: SQL profiler question

• From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
• Date: Wed, 7 Sep 2005 18:21:14 +0200

Did you stop and close the trace?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Andrew,
I created the trace to load a file.  I tried to use the fn_trace_gettable
but I got an error:"File 'C:\test_Website_Trace.trc' either does not exist or
is not a recognizable trace file. Or there was an error opening the file."
Thanks,
joe

"Andrew J. Kelly" wrote:

Take a look at sp_trace_setevent in BooksOnLine.  You may want to use one of
the 3rd party log sniffer tools for something like this as it can make life
a lot easier.  I also don't recommend tracing directly to a table for
performance reasons.  Trace to a file and then use fn_trace_gettable to
import it to a table later on.

--
Andrew J. Kelly  SQL MVP

"jaylou" <jaylou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:531882AB-E152-4227-B4D0-6A8D4F3CC73F@xxxxxxxxxxxxxxxx
> Hi All,
> I am trying to capture every time either SA or a DB_owner adds, changes,
> or
> deletes a user.  Basically I am looking to trap all security functions on
> my
> SQL servers.
> I started a trace that loads a table.  The only problem is that the event
> class is a number not the description.  Is there a reference table for
> this
> or is there a way to load the description?

.

• Follow-Ups:
  • Re: SQL profiler question
    • From: jaylou

• References:
  • SQL profiler question
    • From: jaylou
  • Re: SQL profiler question
    • From: Andrew J. Kelly
  • Re: SQL profiler question
    • From: jaylou

• Prev by Date: Re: SQL profiler question
• Next by Date: RE: Profiler showing no host data
• Previous by thread: Re: SQL profiler question
• Next by thread: Re: SQL profiler question
• Index(es):
  • Date
  • Thread

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint