Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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.