>Hi All:
> I have duplicate records in one table that is part of Sql Server. How can I delete all the duplicate records in the table and preventing this from happening again in the future ?
>Thanks
Mahmood,
Strategy varies according to how you define a duplicate (a key field, a few fields combination, the whole record etc). On SQL server side you could add check constraints to prevent it (typically a candidate key for a combination of fields). Each added constraint would impact on performance so maybe it's a good idea to check 'before' sending to server.
Cetin