Query to find out list of all updated object in last 30 days.

Virendradugar
Posted by Virendradugar under Sql Server category on | Views : 1545
SELECT name AS [Object Name],SCHEMA_NAME(schema_id) AS [Schema],modify_date as [ModifyDate], type_desc, [type] 
FROM sys.objects WHERE modify_date > GETDATE() - 30

Comments or Responses

Login to post response