I would like to capture stored procedure execution details which would require altering existing procedures to perform an INSERT at the start and an UPDATE at the end.
I recall finding a blog article some time ago that demonstrated adding statements to the start/end of stored procedures but cannot find it.
How could I make these changes programmatically either in C# or T-SQL ensuring the original stored procedure definition works as expected?
Edit: As a minimum I want to capture the user executing, the stored procedure name, start and end times. Parameters and stored procedure definition are optional.