>>Check BINARY_CHECKSUM() function in BOL.
>
>Had a look at it, but as far as I can see it is useful for checking records that have changed. I am not sure how it can help in removing duplicate records. Am I missing something obvious here?

Hi Alan,

The BINARY_CHECKSUM() function would return the same value if rows are the same (duplicates) and it ignores text, ntext and image columns. You can temporay add a calculated column with BINARY_CHECKSUM() as expression to your table and use it as starting point in finding duplicates. Unfortuantelly, there's as small chance that the different data in a row can produce the same checksum so you'll have to add some other columns to the comparison.
Keep in mind that it's just an idea and test thoroughly.