Anyone have a method for identifiying dupes in a text field?

coromokes wrote:
By dupes, you mean the existence of the same text value in more than one
row? If so, you can group on the text column and use a having clause to
test for dupes.

You'll need to convert to a varchar or nvarchar data type first, which
means you'll only get access to teh first 4,000 or 8,0000 characters for
the test. But maybe that's good enough.

Select CAST(TextDataCol as VARCHAR(8000))
From TableName
Group By CAST(TextDataCol as VARCHAR(8000))
Having COUNT(*) > 1

Profiler and set fmtonly On issue
Detecting Tables with no recent activity
Crosstabs queries
Recreating database on production machine?
SQL reporting services - issues