TR_EVENTDESIGNATION_VALIDATEDELETE

                    CREATE trigger [dbo].[TR_EVENTDESIGNATION_VALIDATEDELETE] on [dbo].[EVENTDESIGNATION] 
                    after delete 
                    not for replication
                    as
                    begin
                        set nocount on;
                        begin try

                            if exists(select deleted.ID 
                                      from deleted
                                          inner join dbo.REGISTRANT on REGISTRANT.EVENTID = deleted.EVENTID
                                          inner join dbo.REGISTRANTDESIGNATION on REGISTRANTDESIGNATION.REGISTRANTID = REGISTRANT.ID
                                              and REGISTRANTDESIGNATION.DESIGNATIONID = deleted.DESIGNATIONID)
                                raiserror('BBERR_EVENTDESIGNATION_REGISTRANTDESIGNATION_INUSE',13,1);

                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                        end catch
                    end