Posted by Utahduck on 02/22/07 22:32

On Feb 22, 3:28 pm, "Duffey" <rduf...@mazakcorp.com> wrote:
> 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

ntext and text are BLOB data types. They don't work very well with
varchar. Must you use ntext? It would be much easier to work with
VARCHAR(8000) if you are allowed.

[Back to original message]