Limiting a server side trace to a specific table in SQL 2000

microsoft.public.sqlserver.tools

11 Jan 2006 11:00 PM

Chris Powell

I have setup a server side trace on a database, but now I want to limit the
queries captured to a specific table. Is there a way to do this with the
filters available?

I have attempted to filter on the Object Name, but the SQL:BatchCompleted
class does not populate this field.

I have also tried filtering on the TextData, but this does not capture the
Login and Logout events.

Any suggestions would be appreciated.

Thanks,
Chris