Auto update of date field - SQL Server 2005

HI folks,

Is there a way I can automatially tell when a record was last updated?

I can set a field to get the date by using getdate(), but is there a way SQL server will insert the timestamp, without me having to create the date object in CF, then inserting it.

I'd like to add a 'last updated' function to my CMS.

Thanks in advance