Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query sysObject to find last modified date

Status
Not open for further replies.

tklear

Programmer
Jan 16, 2003
37
US
I would like to be able to detect any database object that has been modified since a certain date. Is there a way I can accomplish this. It would help a lot with moving schema changes from development to test environment.

I see a crdate and a refdate but the values seem to be the same in both.

Is there any other way to accomplish what I'm trying to do?
Thanks.
 
If you are looking for something to help with determing changes. i would suggest redgate sql compare. its very easily the best softare ive gotten for the price. the new verion is much faster than the old.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top