Post reply

Determine the last modified date of table

  • April 5, 2005 at 8:06 am

    #85782

    Hi All

    I would like to know if it's possible to determine the last modified date for a table in SQL 2000. Can someone help me on this.

    Thanks

    Jam

  • April 5, 2005 at 8:10 am

    #550528

    No.  The only way you can determine that is if you drop and recreate the table each time.  Normally, you would have these changes stored in SourceSafe or somewhere so you could tell easily the last time it was modified.  You also might want to consider maintaining trace data for auditing purposes that tracks all ddl statements.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

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

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