Re: Auditing SP Execute.

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

Date: Wed, 23 Feb 2005 15:54:16 -0500

Without monitoring the activity with either trace or a 3rd party tool there
is no way to do this in Sql2000. 

-- 
Andrew J. Kelly  SQL MVP
"Pranay Pandya" <ppandya@gmail.com> wrote in message 
news:1109187761.063534.20330@z14g2000cwz.googlegroups.com...
>I want to capture the user name and the time (using sql).  i dont want
> to run profiler for ever.  When someone runs the sp may be i can get
> the userid and insert it into a table.
>

Relevant Pages

  • Re: How to display the command text when a long transaction is on proc
    ... The only way to see what line is actually executing is to start a trace ... beforehand with stmt:starting event. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: Log Reader
    ... Andrew J. Kelly SQL MVP ... >> though you may be runing the script from QA on your machine the trace ... >> Andrew J. Kelly SQL MVP ... >>> comand to stop and clear the trace and re run the commands and it say ...
    (microsoft.public.sqlserver.programming)
  • Re: tracking SPID back to the user or client
    ... You can run a trace and at some point you should see a cursor prepare ... Andrew J. Kelly SQL MVP ... or database code to see why it is blocking and fix the source. ... The connection is made through ODBC. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL profiler question
    ... Trace to a file and then use fn_trace_gettable to ... > Andrew J. Kelly SQL MVP ... >> I started a trace that loads a table. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL profiler question
    ... I created the trace to load a file. ... "Andrew J. Kelly" wrote: ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)