Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified. Expand / Collapse
Author
Message
Posted Wednesday, January 06, 2010 9:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, March 19, 2012 7:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 10, 2014 1:23 PM
Points: 14, Visits: 196
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 »

Add to briefcase

Permissions Expand / Collapse