A. Issue the following query substituting tablename and column list for those columns that need checking for duplicates.

SELECT
<list of all columns>
FROM
tablename
GROUP BY
<list of all columns>
HAVING
count(*) > 1

Learn more from How can I delete duplicate rows from a SQL Server tables? and Q. How can I remove duplicates from a list of entries?