New answers tagged change-tracking
It sounds like, for this particular scenario, you should run a trace in SQL Profiler. You can open it from the Tools menu in SSMS or find it in the Start > Applications > SQL Server 2008 R2 > Performance Tools folder. Create a new trace and connect it to your database. Use the "blank" template and in the Events Selection tab just select Stored Procedures > ...
Top 50 recent answers are included