[dba-SQLServer] deleting duplicates across multiple tables

http://blogs.techrepublic.com.com/datacenter/?p=372

The above article discusses a simple technique for deleting duplicates in a 
single table. A reader wants to know how to expand it to deal with related 
tables.

You can use referential integrity to prevent orphans, but... if the 
duplicates have related duplicates, you still end up with duplicates -- any 
idea how to expand this?

Susan H.