USE SansSQL; -- Change the Database Name GO DECLARE @Days int SET @Days=300 -- Specify the number of days SELECT name AS ObjectName ,SCHEMA_NAME(schema_id) AS SchemaName ,type_desc AS ObjectType ,create_date AS ObjectCreatedOn ,modify_date As ObjectModifiedOn FROM sys.objects WHERE modify_date > GETDATE() - @Days ORDER BY modify_date; GO
Thursday, November 14, 2013
T-SQL to get the list of objects modified in x number of days
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment