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

  • 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

  • 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?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply