Copy Code Trigger Definition 

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