Querying Changes...

  • Is there a way to query a main database to determine if a database has had a change recently. I am trying to determine which databases are "stale"

    Thanks,

    Neil

  • You can query to see if new objects have been created. There is a create data in sysobjets. If the objects are altered, however, you cannot determine this with a query.

    If you are looking for updated information, you would have to have datetime fields that have changed.

    If you want to know if anything has been written to the database, you cannot really tell this. You could always get a product like Log Explorer and check to see if any changes have been to the db since the last log backup.

    Steve Jones

    steve@dkranch.net

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

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