These errors mean that the sync cannot insert the NameFormat records because there are already primary ones in CRM.  The NameFormat records that sync is trying to insert (and generating the error) happen to already exist in CRM.  

The easiest way to resolve this problem is to just delete the ones in CRM and let the TA ones sync over, then things will be fine. 

Here is an example of how to select and delete the problem records

1.  Identify LookupID, PRIMARYSALUTATION and PRIMARYADDRESSEE values
 
a.  The LookupID, in this case, is 'TA616557001' and is visible on the CRM screen on the Constituent record.  This value is made up of:
TA         To signify a TA sync'd record
6165570    The TA Account ID
01         The Name_ID

b.  The PRIMARYSALUTATION and PRIMARYADDRESSEE values need to be set to '1'.  This is a flag - 1 means TRUE, 0 means FALSE. The sync query will be checking for '1' (i.e. PRIMARYSALUATION/PRIMARYADDRESSEE is TRUE) in order to process those records.

2.  Run these scripts, via SDM, with DB rights:

-- In case this is the Nth time running this script.  Use any temp table name (see next Select statement)
 
DROP RSR_NF_13429114;

-- Create temp table with copy of records to delete INTO RSR_NF_13429114
SELECT N.*
INTO RSR_NF_13429114
FROM NAMEFORMAT N
INNER JOIN B2TROWS B ON B.CONSTITUENTID = N.CONSTITUENTID
INNER JOIN CONSTITUENT T ON T.ID = N.CONSTITUENTID
WHERE B.ERRORDESCRIPTION LIKE '%CK_NAMEFORMAT_PRIMARYSALUTATIONCOUNT%'
AND B.BBECTABLE = 'NAMEFORMAT'
AND N.PRIMARYSALUTATION = 1
AND T.LOOKUPID = 'TA616557001'
UNION    
SELECT N.*
FROM NAMEFORMAT N
INNER JOIN B2TROWS B ON B.CONSTITUENTID = N.CONSTITUENTID
INNER JOIN CONSTITUENT T ON T.ID = N.CONSTITUENTID
WHERE B.ERRORDESCRIPTION LIKE '%CK_NAMEFORMAT_PRIMARYADDRESSEECOUNT%'
AND B.BBECTABLE = 'NAMEFORMAT'
AND N.PRIMARYADDRESSEE = 1
AND T.LOOKUPID = 'TA616557001';

-- Delete statement from NAMEFORMAT table
DELETE FROM NAMEFORMAT
WHERE ID IN (SELECT ID FROM RSR_NF_13429114);

3.  Allow time for next scheduled sync to run and finish.  Check records.
=============================================================================