Post reply

Here's a fun one :-)

  • March 5, 2003 at 2:02 pm

    #58451

    Monitoring changes to database objects.

    sysobjects has a crdate field that states when the object was created and not when it was modified. Is there a way to monitor changes in the database?

    Thanks

    Jeff


    "Keep Your Stick On the Ice" ..Red Green

  • March 5, 2003 at 2:37 pm

    #450347

    There is a version column in the same table. If you record the current version, you can monitor if it was changed. It inrements every time you alter the object. However, if you drop and recreate an object, it will get a new ID and new versioning, of course.

  • March 5, 2003 at 2:46 pm

    #450350

    Perfect!!! Thanks


    "Keep Your Stick On the Ice" ..Red Green

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

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