Is there a way in SQL 7.0 to query the modified date of a user defined object (tables, sp). For a table it would be the date the structure was changed, indexed added or dropped and/or a trigger was added or dropped. For a stored procedure it would be the date it was modified.

I looked at the sysobjects system table but could only find a date created field.

The reason for this is to compare databases without having to use some type of replication schema ( I can't go this route do to a firewall and of course mgrs w/ security issues).

Any help would be greatly appreciated.

thanks
oz