Script to check when database objects were they were changed last time

 

use tempdb -- Execute this statement is specific database, which you want to analyze

go
SET NOCOUNT ON select name, crdate, refdate from sysobjects order by crdate desc go