IF (EXISTS(Select * from sys.systrigger where LCase(trigger_name) = LCase('Trig_SOL_Ins'))) THEN Drop trigger Trig_SOL_Ins END IF GO create trigger Trig_SOL_Ins after insert order 1 on DBA.SaleOrderLines referencing new as DocNew for each row begin call CalcSaleTotal(DocNew.DocId) end