Would that cause the trigger to fire again? If so how would you stop it from getting into a indefinite loop?
>Create a insert trigger on the table that fills in an UpdateDate field (and maybe an UpdatedBy field as well). This way SQL Server takes care of it automatically.
>
>>what is the best way to datetime stamp a datetime field when the record is updated? For example a customer record.