IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st where LCase(st.table_name)= LCase('Services') and LCase(sc.column_name)= LCase('CreateDate') ) = 0 then alter table Services add "CreateDate" timestamp end if; GO Update Services set CreateDate = (select min(LastChanged) from Services); GO IF (EXISTS(Select * from sys.systrigger where LCase(trigger_name) = LCase('Trig_Services_CreateDate'))) THEN Drop trigger Trig_Services_CreateDate END IF GO create trigger Trig_Services_CreateDate before insert order 2 on DBA.Services referencing new as new_ for each row when(new_.CreateDate is null) begin set new_.CreateDate = current timestamp end