foreign key constraints - referential integrity
We've just performed a DTS copy objects and data from the production server
to the development server, but the DTS failed on updating the referential
integrity.
The following error is reported with the specific names of the database, fk,
table, and column replaced with generics in brackets:
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 23000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER
TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_[foreign
key]'. The conflict occurred in database '[database]', table '[Table]',
column '[Column]'.
Step Error code: 80040223
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131
|