I want to capture each execution of all stored procedures and the parameters supplied, I'm going to do this via a trace on RPC:starting, capturing TextData, Database and starttime. I'll need to parse the TextData column to get the information that I want. I
assume I also need to capture nested stored procedure calls , i.e. SP: starting as well.
Does this sound correct and is this the best way of extracting this information ?Sean
View Complete Post