Post reply

BULK Insert

  • June 3, 2005 at 5:49 am

    #167361

     

    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

    #562834

    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

    #562848

    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

    #562867

    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