Get earliest and latest date values in a database

  • sarmistead

    SSCommitted

    Points: 1671

    Comments posted to this topic are about the item Get earliest and latest date values in a database

    Steve

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Not sure what I would do with this knowledge.

  • sarmistead

    SSCommitted

    Points: 1671

    My manager handed me a portable disk drive containing mdf files of about 15 databases, and asked me to tell him about them - age, content, when last used.....

    After attaching the mdf files, this script quickly returned the oldest and most recent dates contained in each database. I discovered that one was very recently updated, but the others had not been updated in several years. Just good to know information.

    Steve

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

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