Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

When I'm adding one procedure article to the Publication the I get this error:

The text data type cannot be selected as DISTINCT because it is not comparable

the proc is a simple

select distinct field1, field2, fieldn from tablex where id = @param1

The database is on compatibility level 80.

The source server is SQL 2008 R2.

Any help is appreciated. Thanks, Gabriel Guimarães

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I solved it, due to the sql 2000 compatibility (80) of the database, I've set an option on the replication to: Convert MAX data types to NText and IMAGE.

so by doing a convert to varchar(max) it was solved.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.