profiler trace for one table

  • Filter have not worked most time for me to i trace the data and manipulate with tables and sql statements.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • this might help.....

    in profiler Filter tab mention "Objectid Equals" to object id of that table.

    you can find the object id of any table  like this..

    select object_id('databasename..tablename')

    specify this object id in the filter.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply