SQLTeam.com | Weblogs | Forums

SQL Server Export Wizard Problem with constraints


#1

TITLE: SQL Server Import and Export Wizard

Error 0xc002f210: Preparation SQL Task 1: Executing the query "TRUNCATE TABLE [dbo].[Counties]
" failed with the following error: "Cannot truncate table 'dbo.Counties' because it is being referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


BUTTONS:

OK


#2

What is your question?