tag:blogger.com,1999:blog-8502662455793548336.post8260415330022518111..comments2024-02-27T13:05:07.965+01:00Comments on Dynamics AX = Denis Macchinetti: Violation of PRIMARY KEY constraint 'I_65518FIELD' - Dynamics 365 for Finance & Operations LBDDenis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8502662455793548336.post-15268708413006053192018-09-21T20:04:34.543+02:002018-09-21T20:04:34.543+02:00Hi Denis,
I wrote this script based on what you w...Hi Denis,<br /><br />I wrote this script based on what you write:<br />select T.ID, T.NAME, S.FIELDID,<br />(SELECT TOP 1 Q.NAME from SQLDICTIONARY Q WHERE Q.TABLEID = T.TABLEID AND Q.FIELDID = 0) AS TableName<br /> from TABLEFIELDIDTABLE T<br />JOIN SQLDICTIONARY S ON T.TABLEID = S.TABLEID AND T.NAME = s.NAME<br />WHERE S.FIELDID <> 0 AND S.FIELDID <> T.ID<br />ORDER BY T.TABLEID<br /><br />This finds 767 records in my dev box, which doesn't appear to have SQL sync issues.<br /><br />is this what you meant?<br /><br />Cheers, SimonSimon Buxtonhttps://www.blogger.com/profile/10082626608790896597noreply@blogger.com