Posted by Duffey on 02/22/07 22:28

On Feb 22, 5:22 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Duffey (rduf...@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, esq...@sommarskog.se
>
We used the importing tool in Access to import the table and data into
SQL
JobLogID int Unchecked
Notes nvarchar(MAX) Checked
Unchecked

This is what the table looks like in SQL Management.

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

[Back to original message]