bcp in child before parent

Huh?

I've got good RI data...BUT..a developer loaded the tables in alpha table order...

Such that the child loaded BEFORE the parent...

Huh?

Got a test being set up now to mess with the child file to add a key that doesn't exist in the parent...

But Why is this allowed?

In DB2 you can specify

LOAD DATA REPLACE NO CHECK...

On the load card...you then need to run a check after to verify the data...

Is that what's going on? Is there such a utility in SQL Server to run a check post load?

I'm confused...

Any comments appreciated.

Thanks

Brett

8-)OK, -h option would allow you to check constraints

Otherwise it doesn't

So then if you use the default, How do you make sure the data is ok?|||d'oye....

DBCC CHECKCONSTRAINTS

What a maroon....