title: Get latest added database objects
body: <p>I want to fetch the tables and stored procedures added in last 5 or 6 months to a particular database.</p>
  
  <p>I have tried using the below command but it is not giving correct data.</p>
  
  <pre><code>select * from sys.objects
  where type = 'U' or type = 'P'
  and modify_date between '2012-09-01' and '2013-01-29' 
  </code></pre>
  
  <p>Please suggest which command can give me this list.</p>