Retrieve insertiondate

Hi folks,
Does anyone know how to retrieve the date when data has been inserted
thnx in advanceYou can create a column of the datetime data type. Set the default for that column to "getDate()". This should give you a value of the current date at the time of the insert.|||thnx for your reply,

I know that I can solve it like you suggested, but I want to know the insertiondate of a excisting record..

Can't I retrieve this info with the system tables or something like that

thnx in advance|||Generally, no.

I suppose you could restore an old copy of the database and just start restoring transaction logs until the record you are looking for pops up, but I'm guessing you don't have a full-time employee to devote to this for the next week.|||I wish I had,

But thnx for sharing that with me, now I can leave it and go further

thnx