dbTalk Databases Forums  

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

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Limiting a server side trace to a specific table in SQL 2000 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Powell
 
Posts: n/a

Default Limiting a server side trace to a specific table in SQL 2000 - 01-11-2006 , 05:00 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.