Auditing SP Execute.

From: Pranay Pandya (ppandya_at_gmail.com)
Date: 02/23/05 

Date: 23 Feb 2005 09:12:05 -0800

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