I am using Microsoft Visual Web Developer 2010. I would like to populate my database by running
the Import and Export Data Wizard. I was
successful after manually and painstakingly removing primary keys and allowing
nulls thus having no constraints. I then ran the program and the database was
dropped. I've been trying to use the
wizard but I get this error message.
Executing the query "TRUNCATE
TABLE [dbo].[Students]
" failed with the following error: "Cannot truncate table 'dbo.Students'
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.
(SQL Server Import an ...
Go to the complete details ...