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