T-SQL Script: Find Duplicates in a Table

SELECT YourColumn, COUNT(*) AS Count
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1;