Re: Security Audit Stored Procs

From: Toni Lassila (mpao@mc-europe.com)
Date: 06/26/02 

From: mpao@mc-europe.com (Toni Lassila)
Date: 26 Jun 2002 00:17:31 -0700

"Diane" <dfleming@webmd.net> wrote in message news:<11fb201c21c6e$ce97f280$9ae62ecf@tkmsftngxa02>...
> Does anyone have an example of a stored procedure that is
> used to trace security events?
>
> I saw where I can use SP_trace_create to create the trace
> parameters but i'm a little confused on how to start the
> trace on sql server startup. I read about sp_procoption
> but what goes into the stored proc i'm trying to start?

You can write it yourself using sp_trace_create, sp_trace_setevent
etc. but an easier way is to create the trace using SQL Profiler.
Just choose the events you want, set the filters and select
File->Script Trace from the menu. That spits out a ready sproc
you can modify to decide where you want the trace files, how
big, rollover etc.

Relevant Pages

  • SqlDataAdapter.Fill returns results of previous command
    ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ... stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: fn_trace_gettable threatening my sanity
    ... solution is so ridiculous as to be unbelievable: my stored procedure ... by the procedure that created the trace. ... with the file type added by the ... uppercase and one with lowercase to see the problem behavior and ...
    (microsoft.public.sqlserver.server)
  • Re: Stored Procedures Data view webparts
    ... The only way I have found to get any type of trace is to use SQL Profiler. ... I've had a stored procedure created that works in the following way ... Having the following issues basically i get a generic error message ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Log everything
    ... from the trace I can see that probably an error occurs in a trigger. ... trigger does a rollback tran (and with that makes it impossible to put some ... >> I would like to log every error that occurs in every stored procedure ...
    (microsoft.public.sqlserver.server)
  • Re: Log everything
    ... from the trace I can see that probably an error occurs in a trigger. ... trigger does a rollback tran (and with that makes it impossible to put some ... >> I would like to log every error that occurs in every stored procedure ...
    (microsoft.public.sqlserver.programming)