Home Forums SQL Server 7,2000 General How to List All table Modified, altered, updated, inserted in sqlserver 2000 database Last N Days. RE: How to List All table Modified, altered, updated, inserted in sqlserver 2000 database Last N Days.

  • September 19, 2013 at 10:05 am

    #1651584

    To get the Tables Altered, you can use

    SELECT name, create_date, modify_date

    FROM sys.objects

    WHERE modify_date >= GETDATE()-n