User id executed stored procedure
in [Server Configuration]
|
Prev: Error making target server on multiserver envmnt
Next: UPDATE [table] WITH (PAGLOCK) xx OPTION (SHRINKDB PLAN)
From: tolcis on 20 May 2010 12:19 Is there a way to find out in SQL 2005 who executed a particular stored procedure? Thank you, T.
From: Tom Moreau on 20 May 2010 15:49
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. |