From: tolcis on
Is there a way to find out in SQL 2005 who executed a particular
stored procedure?

Thank you,
T.
From: Tom Moreau on
Yes and no. If you had the profiler running, you could determine who
executed the proc. However, if it was not running, then there is no way to
find out retroactively.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"tolcis" <nytollydba(a)gmail.com> wrote in message
news:d1e919db-e896-4eb7-85f0-a011158e6714(a)m21g2000vbr.googlegroups.com...
Is there a way to find out in SQL 2005 who executed a particular
stored procedure?

Thank you,
T.