Re: Auditing SP Execute.

From: Steve Troxell (steve_troxell_at_hotmail-nospamforme.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 17:10:15 -0500

Andrew J. Kelly wrote:
> Without monitoring the activity with either trace or a 3rd party tool there
> is no way to do this in Sql2000.
>

Of course he can.

create table AuditLog (WhenItRan datetime, WhoRanIt sysname)
go

Add to beginning of SP:

insert into AuditLog values (getdate(), suser_sname())