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