Post reply

How do i monitor transactions on a specified table with SQL Profiler?

  • January 28, 2009 at 2:42 am

    #125954

    Hi,

    I want to monitor all transactions on a table with SQL Server Profiler, I set ObjectName or ObjectId but it does not work.

    How do i monitor transactions on a specified table with SQL Profiler?

    Regards

  • January 28, 2009 at 3:16 am

    #933678

    Hi there,

    have you tried to filter the trace with the name of the object (table)?

  • January 28, 2009 at 3:21 am

    #933679

    I tried to filter ObjectName and again with ObjectID( OBJECT_ID(?) )

    but it could not work?

  • January 28, 2009 at 7:34 am

    #933808

    Go to Column Filter,

    Choose TextData ,

    in LIKE, put %YOURTABLENAME% in

    AND CHECK the box ' Exclude the rows that do not contain values'

  • January 28, 2009 at 7:49 am

    #933826

    Thanks,

    It works fine.

Viewing 5 posts - 1 through 4 (of 4 total)

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