February 15, 2007 at 8:33 am
Is it possible to run a trace on some selected tables? I am providing ObjectID to the profiler alongwith databaseID but ObjectID column alongwith ObjectName is null. Any ideas?
February 15, 2007 at 9:38 am
I do it this way: in the filter set TextData Like %YourTableName%
For example this filter will trace queries towards sysusers table and will not trace towards sysjobs:
TextData Like %sysusers%
You have to put % around the table name so the statement containg the word sysusers will be traced
Regards,Yelena Varsha
February 15, 2007 at 11:43 am
only problem is that I have set of 40 tables on which I want to setup the trace.
February 15, 2007 at 1:09 pm
You have to append a filter per line when using sp_trace commands anyway and use OR between the lines. Another suggestion, if you would like all tables but not system tables, do filter "Not Like %sys%"
Regards,Yelena Varsha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply