SELECT
ISNULL(sp.name, s.name) AS [main_schema],
ISNULL(op.name, o.name) AS [main_object],
ISNULL(op.type, o.type) AS [main_type],
ISNULL(op.type_desc, o.type_desc) AS main_type_desc,
s.name AS [schema],
o.name AS [object],
o.type,
o.type_desc,
o.create_date,
o.modify_date,
sp.name AS P_schema,
op.name P_object,
op.type AS P_type,
op.type_desc AS P_type_desc,
op.create_date AS P_create_date,
op.modify_date AS P_modify_date
FROM sys.objects AS o (NOLOCK)
INNER JOIN sys.schemas s (NOLOCK) ON s.SCHEMA_ID = o.SCHEMA_ID
LEFT OUTER JOIN sys.objects op (NOLOCK) ON o.parent_object_id > 0 AND o.parent_object_id = op.OBJECT_ID
LEFT OUTER JOIN sys.schemas sp (NOLOCK) ON o.parent_object_id > 0 AND sp.SCHEMA_ID = op.SCHEMA_ID
WHERE o.modify_date >= DATEADD(HOUR, -24, GETDATE())
--WHERE o.modify_date = o.create_date
AND o.is_ms_shipped = 0
ORDER BY o.modify_date DESC, s.name, o.name