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

Leave a comment (0) Go to comments

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

EOF - Script to check when database objects were they were changed last time, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.