Listing all modified objects in SQL Server by Date

 

select * from sys.objects where modify_date >= '2010-02-16'

This will list all the database objects modified after 16th Feb 2010