Post reply

monitoring a table

  • March 30, 2013 at 5:33 am

    #272633

    I want to monitor a table continuously to see whether its updating or not if its updated i want too know how many rows it update and i wan to store them in a table

    time updated, no of rows

  • March 30, 2013 at 12:47 pm

    #1602262

    Sounds like you need a history table.

    Check this out

    http://database-programmer.blogspot.com/2008/07/history-tables.html

  • March 30, 2013 at 1:25 pm

    #1602269

    gurjer48 (3/30/2013)

    I want to monitor a table continuously to see whether its updating or not if its updated i want too know how many rows it update and i wan to store them in a table

    time updated, no of rows

    Do you want to store the actual data for the rows that are updated or do you just want to store the number of rows that got updated and when? Either way, the use of a well written, set-based trigger will do the job quite nicely.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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