In this tip you can learn about stored procedures execution history monitoring.
Please read the latest MSSQL Tip: “Several Methods to collect SQL Server Stored Procedure Execution History“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.