Posted by Weyus on 06/22/07 22:33

All,

Just want to make sure that I understand what's going on here.

I have a table with IGNORE_DUP_KEY set on a unique, multi-column
index.

What I'm seeing is this:

1) When performing a BULK INSERT, the UNIQUE index is not being
respected and rows which violate the unique index are inserted.

2) When performing a regular INSERT, the UNIQUE index is being
respected and rows which violate the unique index ARE NOT inserted.

Is this expected behavior.

Also, I have some questions, given the index described.

Q1) Will a regular INSERT that attempts to insert duplicate data get
an error back or just a warning?

Q2) How can I set things up so that a BULK INSERT would NOT allow
duplicates to be entered into the table?

Thanks,
Wes Gamble

• Next in forum: Re: BULK INSERT ignores UNIQUE index with IGNORE_DUP_KEY set?
• Prev in forum: Re: correct syntax for this select in SQL Server?
• Thread view: BULK INSERT ignores UNIQUE index with IGNORE_DUP_KEY set?

[Reply to this message]