SQL Server Training | Tutorials | How to's

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

Following script will list down  database objects and their corresponding creation date and last modified date.

-- ***********************************************************************************/
-- Description  :    Script to check the objects and the date they were changed for a database
--                        Following script will list down  database objects and their corresponding creation date and last modified date.
-- Compatibility  :     7.0+
-- ***********************************************************************************/
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