Profiler: how to trace table activity?

microsoft.public.sqlserver.tools

22 Mar 2007 10:10 PM

Leon Shargorodsky

Does anybody know how to trace all activity for a specific table, using
Profiler? I want to be able to trace every single SELECT, INSERT, UPDATE and
DELETE for a specific table.

Thank you in advance!

23 Mar 2007 1:05 AM

Hari Prasad

Hello,

Run the profiler with filter set on object name. Rather than running the
profiler go for server side trace.

Thanks
Hari

Show quote

"Leon Shargorodsky" <LeonShargorod***@discussions.microsoft.com> wrote in
message news:1A10F165-B2F3-4110-8A7E-4CDEEE30D6EC@microsoft.com...
> Does anybody know how to trace all activity for a specific table, using
> Profiler? I want to be able to trace every single SELECT, INSERT, UPDATE
> and
> DELETE for a specific table.
>
> Thank you in advance!