I am trying to run a DTS package that basically copies an
entire database to another location. But it runs until
it gives me this error:

"ALTER TABLE statement conflicted with TABLE FOREIGN KEY
constraint 'cimalloc_fkc1'. The conflict occurred in
database 'CIM_BU', table 'SMPKDT'."

I think i understand the error but is there an easy way to
either see what the constrant is looking at? (What
fields?) Or what data is not meeting the Foreign Key
constraint?

I am just learning SQL (and databases for that matter) so
please be gentle with your answer... THANKS IN ADVANCE!!!

OK

You are looking in database 'CIM_BU' and table 'SMPKDT'. You are looking
for a constraint called 'cimalloc_fkc1'

Have a look at the sysreferences table to find out which columns are being
referenced by which tables

select
OBJECT_NAME(constID) as ConstraintName,
OBJECT_NAME(fkeyID) as referencedTable,
OBJECT_NAME(rkeyID) as referencingTable,
col_name(fkeyid,fkey1) as ReferencedColumn,
col_name(rkeyid,rkey1) as referencingColumn
from sysreferences



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Chip Melton" <cmelton (AT) choctawnation (DOT) com> wrote