Re: Auditing SP Execute.

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 13:17:41 -0500

You can run a trace that is filtered only on this sp. That is the easiest
and least expensive way. Or you would have to buy one of the 3rd party log
tools to view the contents of the log. 

-- 
Andrew J. Kelly  SQL MVP
"Pranay Pandya" <ppandya@gmail.com> wrote in message 
news:1109178725.456740.135850@z14g2000cwz.googlegroups.com...
> To meet audit requirements, I have to maintain an audit log of when a
> particular sp was execute and by whom.  I am not willing to use the c2
> option for just one stored procedure.  There are 2 users who can run
> the stored procedure from enterprise manager or query analyser (others
> run it from an app). Any suggetions?
> Thank You,
> -pranay
>

Relevant Pages

  • Auditing SP Execute.
    ... To meet audit requirements, I have to maintain an audit log of when a ... particular sp was execute and by whom. ... the stored procedure from enterprise manager or query analyser (others ...
    (microsoft.public.sqlserver.security)
  • 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.programming)