http://blogs.technet.com/patricg/archive/2008/05/26/how-to-remove-duplicate-rows-from-a-table-in-sql-server.aspxMicrosoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as "key" or "PK" in this article, but this will always denote "primary key."fr-FRCommunityServer 2.1 SP1 (Build: 61025.2)