[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » [Microsoft][ODBC SQL Server Driver][SQL...

[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified.

Rate Topic

Display Mode

Topic Options

Author

Message

Lotus

Posted Wednesday, January 06, 2010 9:10 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, December 09, 2010 2:28 PM
Points: 42, Visits: 79

Get the following error while trying to insert into nvarchar(max) column with data greater than 180K.

Here is the error
[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified.

begin tran declare @h int exec @h=sp_createorphan '"evalcasedb"."_SMDBA_"."_ATTACH_"."FILEBLOB"'
WRITETEXT BULK "evalcasedb"."_SMDBA_"."_ATTACH_"."FILEBLOB" @h WITH LOG

Post #842916

Naomi N

Posted Monday, March 19, 2012 7:56 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:08 PM
Points: 13, Visits: 182

Did you get the resolution to this problem? I am reproducing this error by using 2MB file. I am wondering what is the size limit before this error occurs?

Post #1268977

« Prev Topic | Next Topic »

Permissions