SQL:Get the list of Sys objects modified in x number of days
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