Hi, I am new to sql trace files / analyzer / profiler (but not new to SQL Server) and I'm wondering if I am looking in the right place. Quite simply I need to add records via an application (web-based app with sql back-end) and I need to see exactly which tables get hit. Is this where trace files come in? Is creating a trace file the only way to determine which tables are being populated?
Sure, you can use Profiler to trace all / some of the database traffic. Looking initially at profiler events RPC:Completed, and SQL:BatchCompleted, read some docs about profiler (google SQL Server Profiler and you will get a ton of hits).
A.J. DBA with an attitude
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply