Tracing a table in Profiler

• Linda-272642

  Ten Centuries

  Points: 1100

  More actions

  December 4, 2006 at 4:00 pm

  #114863

  

  I am trying to trace a specific table using profiler 2000 or 2005.  I need to find out what procs are hitting it and to see if we have an overhaul on indexes.  I have tried filtering it by objectid and/or objectname with no success.

  Please send me any suggestions you may have as for I am about to pull my hair out

  thanks

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 4, 2006 at 7:54 pm

  #675698

  Use textdata filter as '%tablename%'

  or

  You can run the query against syscomments table which will give you table used by procs, triggers and views used..

  select distinct object_name(id) from syscomments

  where text like '%Tablename%'

   

  MohammedU
  Microsoft SQL Server MVP