Re: SQL profiler question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks I will look at that.

"Tibor Karaszi" wrote:

> > Do you know of a reference table that holds eventID and description?
>
> Yep. Check out http://www.sqldev.net/misc.htm
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "jaylou" <jaylou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:64769B7A-9A29-4BB5-8F64-62220A2A3976@xxxxxxxxxxxxxxxx
> > Yes that was my first thought.
> >
> > Do you know of a reference table that holds eventID and description? The
> > description doesn't seem to load into the table when I run the trace directly
> > into a table.
> >
> > Thanks,
> > Joe
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> 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/
> >>
> >>
> >> "jaylou" <jaylou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:379EB231-57D9-4EDE-A2F6-6B1250FF4E7F@xxxxxxxxxxxxxxxx
> >> > 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?
> >> >>
> >> >>
> >> >>
> >>
> >>
>
>
.

Relevant Pages

  • Re: SQL2000 View Construction using UNION
    ... I haven't seen a reference as such. ... Tibor Karaszi, SQL Server MVP ... Yet another reason to use QA. ...
    (microsoft.public.sqlserver.programming)
  • Re: Commands with and with quotes
    ... Books Online has reference for all the SQL command. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: 64bit insert delays
    ... Tibor Karaszi, SQL Server MVP ... > we/users can query when mails were processed by the antispam system, ... this sounds like you are selecting from some other table than the one inserting into and you ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Truncating Log Files
    ... Tibor Karaszi, SQL Server MVP ... I have ran dbcc loginfoand used found that I have about 136 Gig at ... my LSN for Log Shipping and possibly break my Mirroring? ...
    (microsoft.public.sqlserver.server)
  • Re: Subquerie in CHECK Constrain
    ... I recall once retrieving a record set in VB, looping it and for each row, executing another ... Tibor Karaszi, SQL Server MVP ... >> Kalen Delaney ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)