Because I have to keep running this script and thus look it up, keeping it here for handy and quick reference [code]select count(id) from database.dbo.tablename group by id having count(id) > 1[/code]