SQL Server last called stored procedures with parameters

Posted by Teoman shipahi on Stack Overflow See other posts from Stack Overflow or by Teoman shipahi
Published on 2012-03-21T19:55:22Z Indexed on 2012/06/07 16:40 UTC
Read the original article Hit count: 265

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?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about stored-procedures