Get All The Modified Or Created SQL Objects On Current Date

  1. SELECT name,* FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 500