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
No comments:
Post a Comment