TR_SALESORDERITEMITINERARYRESOURCE_DELETE_SALESORDERITEM

                    CREATE trigger [dbo].[TR_SALESORDERITEMITINERARYRESOURCE_DELETE_SALESORDERITEM] 
                        on [dbo].[SALESORDERITEMITINERARYRESOURCE] 
                        after delete not for replication
                        as begin
                            delete from dbo.SALESORDERITEM
                            from deleted
                            where dbo.SALESORDERITEM.ID = deleted.SALESORDERITEMID
                        end