IF (EXISTS(Select * from sys.systrigger where LCase(trigger_name) = LCase('InsSvoObjectsStn'))) THEN Drop trigger InsSvoObjectsStn END IF GO create trigger InsSvoObjectsStn after insert order 1 on DBA.Objects referencing new as NewRow for each row begin if NewRow.handle_id = 3 then insert into SvoObjectsStn( Glava,Svoistvo,Stoinost) values( NewRow.Id,'31','1') end if end GO