SQL2000 know last data modification

Posted on 2011-10-11
Last Modified: 2012-05-12
There's a way to know the date of the last row was add or modify on a MS SQL 2000 database/table?
Question by:hvillanu
    LVL 17

    Accepted Solution

    The following shows date of  last statistics update for a table - If your table has an index this may help

    SELECT 'Index Name' =, 'Table Name' =,  

    'Statistics Date' = STATS_DATE(, i.indid)  

     FROM sysobjects o, sysindexes i  

    where =
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>There's a way to know the date of the last row was add or modify on a MS SQL 2000 database/table?<<
    LVL 15

    Assisted Solution

    There is no way to get this details unless you have designed auditing based on DML triggers on the table.  
    @BCUNNEY, you cannot relay on STATS_DATE for this because it only says about the date when the statistics are Last updated, Also statistics are not update each time when you do inserts.
    LVL 5

    Author Comment

    @BCUNNEY... they helps, but not accurate... the difference between statistics date and datadevice/logdevice date was over +1 day.
    Thanks any way.
    LVL 5

    Author Closing Comment

    Good if checking statistics update dates

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now