TR_CK_EVENTGROUPMEMBER_VALIDREGISTRANT

                    create trigger TR_CK_EVENTGROUPMEMBER_VALIDREGISTRANT on dbo.EVENTGROUPMEMBER after insert, update not for replication
                    as begin
                        set nocount on;

                        if (select count(*) from inserted) = 0
                            return;

                        if not exists (
                            select 
                                REGISTRANT.ID 
                            from 
                                inserted I
                                inner join dbo.REGISTRANT ON REGISTRANT.ID = I.REGISTRANTID
                                inner join dbo.EVENTGROUP on EVENTGROUP.ID = I.EVENTGROUPID
                            where 
                                REGISTRANT.EVENTID = EVENTGROUP.EVENTID
                        )
                        begin
                            raiserror('TR_CK_EVENTGROUPMEMBER_VALIDREGISTRANT', 16, 1);
                            rollback;
                        end;
                    end;