TR_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_DELETE_UPDATETICKET

              CREATE trigger TR_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_DELETE_UPDATETICKET on dbo.SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET after delete not for replication
              as begin
                  set nocount on;

          update 
            dbo.TICKET
          set 
            APPLIEDTOMEMBERSHIP = 0,
            APPLIEDTOMEMBERSHIPSALESORDERID = null
          from
            dbo.TICKET inner join deleted on
              TICKET.ID = deleted.TICKETID
              end