Check what was changed in DB after 9PM Last night

SELECT name,  TYPE,  type_desc,  create_date,  modify_date 

FROM sys.objects 

WHERE TYPE IN ('U','V','PK','F','D','P') 

AND modify_date >= Dateadd(HOUR,21,Cast((Cast(Getdate() - 1 AS VARCHAR(12))) AS SMALLDATETIME)) 

ORDER BY modify_date 

--U - Table

--V - View

--PK - Primary Key

--F - Foreign Key

--D - Default Constraint

--P - Procedure