There is no generic script which can be used for this. You need to query each table to see if it has duplicate rows in it.
If your table looked like this:
<pre>CREATE TABLE Employee
And you wanted to check for duplicate records you would use this query to identify the duplicate rows.
<pre>SELECT EmployeeId, FirstName, LastName, count(*)
GROUP BY EmployeeId, FirstName, LastName
HAVING count(*) <> 1</pre>