title: SQL Server 2000 Function for record created datetime
body: <p>I was given a task to display when a record in the database was added, however the previous developers never made a field for this, and I can't go back and make up dates for all the existing records. Is there an easy way to extract out a record Creation date from a <code>SQL server 2000</code> query. </p>
  
  <pre><code>SELECT RECORD_CREATED_DATE FROM tblSomething WHERE idField = 1
  </code></pre>
  
  <p>The <code>RECORD_CREATED_DATE</code> isn't a field in the existing table. Is there some sort of SQL Function to get this information ?</p>