TR_DESIGNATION_INSERTUPDATE_NAME

                        create trigger [dbo].[TR_DESIGNATION_INSERTUPDATE_NAME] on [dbo].[DESIGNATION]
                            after insert, update
                            not for replication
                            as
                            begin
                                set nocount on;

                                if (update(DESIGNATIONLEVEL1ID)
                                    or update(DESIGNATIONLEVEL2ID)
                                    or update(DESIGNATIONLEVEL3ID)
                                    or update(DESIGNATIONLEVEL4ID)
                                    or update(DESIGNATIONLEVEL5ID))
                                begin
                                    declare @IDS UDT_GENERICID;
                                    insert into @IDS
                                    select ID from inserted

                                    exec dbo.USP_DESIGNATION_SETNAME @IDS
                                end
                            end