title: Date object last modified
body: <p>How can I find out the date a MS SQL Server 2000 object was last modified?</p>
  
  <p>I need to get a list of all the views, procs, functions etc that were modified since Aug 15th.  In sysObjects I can see the date objects were created but I need to know when they were last altered.</p>
  
  <p>NB: this is an SQL 2000 database.</p>