title: Microsoft SQL Server: Any way to tell when a record was created?
body: <p>Our customer wants to order by the record creation date.  To me this seems like a system variable, some sort of meta data for the record itself.</p>
  
  <p>Is there a way to tell when a record was created without actually creating a datetime field with a default of GetDate() and hope that no one modifies it?  </p>