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.

  • davehegwood (9/19/2013)


    To get the Tables Altered, you can use

    SELECT name, create_date, modify_date

    FROM sys.objects

    WHERE modify_date >= GETDATE()-n

    Won't work on SQL 2000.

    3 year old thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass