June 3, 2005 at 5:49 am
Constraints on tables to be Bulk Inserted are not checked during the bulk copy operation unless you use the Check_constraints keyword. By default, constraints are ignored....is there any database option to change this to always check constraints even on a bulk insert?
June 3, 2005 at 6:03 am
FWIW, see if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 3, 2005 at 6:30 am
Thanks for the reply...maybe some more information about what we are looking for will help. The Foreign keys are the issue. We have found that a bulk insert on a table will load data that violates the Referential Integrity of the database, which in turn causes problems on the application. We want to assure that this situation does not happen on that database again by forcing the BUlk insert always to check the contraints when the check_constraint keyword is left off of the insert statement.
June 3, 2005 at 6:48 am
Oops, sorry. No, there is no setting I know of. Default is that constraints are ignored unless you explicitely state otherwise.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply