TR_DESIGNATION_INSERT_BBNCDESIGNATIONIDMAP

                CREATE trigger TR_DESIGNATION_INSERT_BBNCDESIGNATIONIDMAP on dbo.DESIGNATION after insert not for replication
                as begin
                    insert into dbo.BBNCDESIGNATIONIDMAP (DESIGNATIONID)
                        select ID from inserted;
                end