ALTER TABLE dbo.ModelElementData NOCHECK CONSTRAINT all;or disable all constraints on all tables
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all";
select top 100 * from dbo.ModelElementData AS med where not exists (select 1 from dbo.UTILMODELS AS um where med.ModelId=um.ID and med.LayerId=Layer)
UPDATE dbo.ModelElementData SET ModelId = 1478 WHERE ElementHandle=1049983;or
UPDATE dbo.ModelElementData SET ModelId = 1478 WHERE ElementHandle IN ( select ElementHandle from dbo.ModelElementData AS med where not exists (select 1 from dbo.UTILMODELS AS um where med.ModelId=um.ID and med.LayerId=Layer) )
ALTER TABLE dbo.ModelElementData WITH CHECK CHECK CONSTRAINT all;or
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all";
If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.
Buy Me a CoffeeNo comments. Be the first one to comment on this post.
DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.
Authors are allowed to set their own "buy me a coffee" link.
Join us.