SQL Server last called stored procedures with parameters
- by Teoman shipahi
I am using ASP.NET environment.
Is it possible to track last N number of stored procedures called with parameters info?
I see in this article "Recently executed stored procedures";
http://sqlfool.com/2009/08/find-recently-executed-stored-procedures/
But I need input parameters also.
If not what can be the best way to track it?
For example, adding an insert statement to a information table for every single procedure beginning?
Or is there any better solution for this?