Post reply

profiler trace for one table

  • July 25, 2007 at 9:48 am

    #70582

    I think I am correct with the below statement but any input or suggestions would be appreciated. 

    In sql2000 with profiler you cannot filter your profiler trace to just one table in one dbase.

    It does not work.

    Any info on this or ways to trace a table  would be appreciated ????

  • July 25, 2007 at 11:31 am

    #722381

    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

  • July 26, 2007 at 6:46 am

    #722546

    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 3 posts - 1 through 2 (of 2 total)

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