InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 03:43:37 GMT20http://www.sqlservercentral.com/Forums/Topic1407724-391-1.aspxYou would need to loop through dropping all the FK's, then truncate, then load then recreate the FK'sJust setting the constraint to NOCHECK still wont allow you to truncate the referenced table.Wed, 16 Jan 2013 04:38:11 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407724-391-1.aspxHi all, Is there any way to truncate and load the data when the tables have relationships.like disabling all the constraints at one time .truncating ,loading all datathen enabling all constraintsthankssathiyan rWed, 16 Jan 2013 03:33:46 GMTsathiyan00