This is typically something handled by creating a trigger on the relevant tables, and is "on" all the time. When you need to capture the actions of only a specific stored procedure, it would need to either be coded in the stored procedure or might need a slightly different kind of trigger, and I forget what they call them.... is either DDL or DML, or possibly Database. Someone else likely remembers those details far better than I do.