I need to create a query in SQL 2000 which will find duplicates in
an entire database (user tables only). What would be the best
logic to implement this? I need to run this from vb, so a stored
procedure, view or passing the SQL text. The dups are to be
matched on 8-10 fields (may var between tables) and not the
rest because they are binary type fields.

Thanks in advance for any assistance.