Microsoft Dynamics CRM 4.0 has built-in duplicate detection which is great, but in 3.0, which many businesses are still using, the only options for duplicate detection were some third-party applications or a a custom-developed one like the minimally functional example in the 3.0 SDK.
[BEST PRACTICES NOTE: Duplicate detection should be only one of the tools in you data quality arsenal. The best approach is to have some solid practices that govern data entry, and to train users well on things like searching for a record before entering new data.]
Because of the shortcomings of duplicate detection in version 3.0, a lot of these systems have ended up with some data quality issues. If you're running CRM 3.0 and you'd like a quick way to check your duplicates, here's a simple SQL query you can run to find them.
- Open SQL Server Management Stu ...