TR_EVENT_UPDATE_DELETELINKEDDESIGNATIONS

                    CREATE trigger TR_EVENT_UPDATE_DELETELINKEDDESIGNATIONS on dbo.EVENT after update not for replication
                    as begin
                        set nocount on;

                        if update(DESIGNATIONSONFEES) and ((select count(*) from inserted where DESIGNATIONSONFEES = 0) > 0)
                            begin
                                delete from dbo.EVENTDESIGNATION
                                where EVENTDESIGNATION.EVENTID in (select ID from inserted)

                                delete 
                                from dbo.REGISTRANTDESIGNATION
                                where REGISTRANTDESIGNATION.REGISTRANTID in (select REGISTRANT.ID from
                                dbo.REGISTRANT inner join inserted on REGISTRANT.EVENTID = inserted.ID)
                            end

                    end