Replication

Hi,can someone help me to detect the replication of data in SQL DB tables and how to remove the replicated data.Do you mean duplication of data? I'm not sure what you're asking here.|||Originally posted by strader
Do you mean duplication of data? I'm not sure what you're asking here.

Yes My friend duplication of data,can u help me please.|||Replication is a very different thing than duplication, so I had to ask.

Can you explain the scenario a bit further, what data are you trying to detect duplicates of?

The best situation is to avoid duplication by putting keys on columns. That might not be what you're after though

You can write some queries though that will detect multiples of something in a table.

Something like:

select dupfield, count(dupfield)
from duptable
group by dupfield
having count(dupfield) > 1