Duplicate Records

Hi,

Not so sure how simple this question is but here is what happened. I installed SQL Server 2005 on a new Win Server 2003. I exported the tables and their data from the old machine to the newly established database on the new machine.

It looks like all my records were duplicated. When I try to delete one of the duplicates it won't work because both rows are effected. I can't set my primary key now and if I try to create a new database with the primary key already set than the import fails.

Any one run into this before or know what's going on?

Any help ASAP would really be appreciated.

Thanks,

Alice

I think I might have found the answer to my question here:

http://www.sqlteam.com/item.asp?ItemID=3331

I'll try it.

Alice

|||

I tried the SELECT DISTINCT approach and copied the records into a new table. It seemed to work, but everytime I try to create a new primary key it seems like the table creates a new duplicate record that prevents it. I'm wandering if this is something I'll need to call tech support on. Maybe something is misconfigured.

Ally

|||

Hi,

I would suggest to refer below links also which has workaround you are reffering

http://www.sql-server-performance.com/rd_delete_duplicates.asp

http://support.microsoft.com/kb/139444

Hemantgiri S. Goswami