Hi, Thanks for the respond.

My situation here is different to what you've refered me to. Using SQL Server 2000, we used to have 1 central table that we all query from on a daily basis and at the same time append new records to it. We set indexes into that table (tblModels) for these 2 fields (Modelcode and Modeldescription) to ignore duplicates. We do not want it to have duplicates records only unique records must be there. MS SQL Server 2000 used to insert only unique records but with MS SQL Server 2005, when ever new data contains duplicates records within the whole transaction rolls back and nothing gets inserted there which will be a problem for us.

Thanks.