Posted by Erland Sommarskog on 02/22/07 22:22

Duffey (rduffey@mazakcorp.com) writes:
> I am trying to copy the data from one table to another table linked in
> SQL. I keep getting an error message saying "the data types
> nvarchar(max) and ntext are incompatible in the equal to operator" I
> went into the SQL Management Server and tried to modify the codes and
> am still having no luck. Any help would be appreciated.

The tables are on different servers?

How does your UPDATE statement look like? What is the CREATE TABLE
statement for the tables?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]