TR_RELATIONSHIP_INSERT_BBNCRELATIONSHIPIDMAP

CREATE trigger TR_RELATIONSHIP_INSERT_BBNCRELATIONSHIPIDMAP on dbo.RELATIONSHIP after insert not for replication
as begin
    insert into dbo.BBNCRELATIONSHIPIDMAP (RELATIONSHIPID)
        select ID from inserted
end