SQL – Find Orphaned Records

I created a quick stored procedure the other day to find orphaned records in a SQL 2000 database:

http://drop.io/SQL_FindOrphans

SQL Query to find duplicates

SELECT [column_a], [column_b], COUNT(*) as NumDuplicates
FROM [tablename]
GROUP BY [column_a], [column_b]
HAVING COUNT(*) > 1