A default constraint only works on inserts, for an update use a trigger. Triggers are the best way, because this logic is intimately associated with the table, and not the application. This is just about the only obvious proper use of a trigger that I can think of, apart from more granular referential integrity.
Please see :
Create a Modified On Column in SQL Server[
^]
And also check one similar thread :
here[
^]
--Amit