Post reply

Script for checking when table was last updated

  • June 29, 2011 at 4:35 am

    #389860

    Hi,

    Can someone please point me in the right direction of how to check by how much data was last written to a table? I have a script which tells me when it was last updated.

    Thanks

  • June 29, 2011 at 5:01 am

    #1345798

    I highly doubt this can be done, but I'm waiting for other members' suggestions, if any.

    -- Gianluca Sartori

  • June 29, 2011 at 5:09 am

    #1345800

    In SQL server 2008 Version, there is one of the auditing configuration at server level and database level, Through database level auditing you able to monitoring like how many data inserted, updated and delete for database level.

    rgds

    ananda

  • July 11, 2011 at 8:45 am

    #1351122

    With 2008 you can also use CDC (Change Data Capture) or Change Tracking. Both are useful but require a little thought on what your needs are.

    Another option is Audit triggers on the table.

    Depends what detail of change you are after. But there is plenty out there. But all of these solutions require some planning and thought. I guess you have been thinking about it 🙂

    HTH

    Graeme

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

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