Post reply

Table "modified" date?

  • March 24, 2009 at 12:44 pm

    #71404

    Is there a way to see when a table was modified vs. created. I can see the "createdate" by running script:

    select * from sysobjects where type = 'u'

    This returns "crdate" among other fields, but is there a way to know when it was modified (if it was)? I noticed there's a "refdate" but it's the same datetime value as the "crdate".

    thx,

    john

  • March 24, 2009 at 2:49 pm

    #965626

    To know when a table is modified in SQL Server 2000, you need to be running an audit trace looking for those types of activities. SQL Server 2005, however, does track modifications in the sys.tables system view.

  • March 27, 2009 at 7:59 am

    #967447

    Yeah, I figured that. Thanks for the info.

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

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