Hi all,

Trying to add a unique constraint to a table with many, many millions of
rows. Dies with an obvious duplicate
but no clue which record. Oracle has an exceptions into clause. Is there
anything similar in sql server 2000?

TIA

-- chip
MS Sql Server LazyDBA home page