Post reply

Date Table Modified

  • April 15, 2003 at 7:54 am

    #82054

    Is there a way to determine the date a table was last modified. I have 5 tables and need to know which table is the oldest. The tables do not have a datetime field.

    Thanks

  • April 15, 2003 at 7:56 am

    #454230

    I thought we cannot see when a table was last updated. We surely can check when a table was created though in sysobjects in all the user database.

    .

  • April 15, 2003 at 8:39 am

    #454251

    When you say 'the date a table was last modified', do you mean the last change to the schema of the tables (new or changed column, new index etc) or the last time a row in the table was modified (inserted or updated or deleted)?

    Jeremy

  • August 7, 2003 at 8:07 pm

    #469110

    I'll answer that last question... at least for me. We need to know the date/time rows in the database were last inserted, updated or deleted... preferably a list of all the tables in order of their date/time last "updated."

  • August 8, 2003 at 8:54 am

    #469197

    There may be a neater solution than this but you could set up a triggers on each table for insert, update, delete which then update rows in a table. This table would have 3 columns: table name; type (insert/update/delete); datetime

    Jeremy

  • August 8, 2003 at 11:41 am

    #469230

    Thanks for the reply... yep, thought of that.

    How about reading the log file? I don't know much about that topic. Is it "readable?"

Viewing 6 posts - 1 through 5 (of 5 total)

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