Error 7139,image column

On Thurs, Apr 26 2001 8:52 pm, Stoney said:

> The SQL Server gives the following error msg When my app executes an update
> statement to set an image column:
> native error=7139, legth of text,ntext,or image data(70986) to be replicated
> exceeds configured maximum 65536.
I have this same error. Any suggestions?
OLE exception from "cqole":
SQLParamData: RETCODE=-1, State=37000, Native Error=7139
SQL statement="update devtask [...] where dbid = 34163920 and version =
11"
[Microsoft][ODBC SQL Server Driver][SQL Server]Length of text, ntext,
or
image data (73254) to be replicated exceeds configured maximum 65536.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
Win32::OLE(0.1702) error 0x80020009: "Exception occurred"
in METHOD/PROPERTYGET "Commit"
client: Windows 2003, OLE
server: Windows 2003, Sql Server 2000
issue the following sp_configure 'max text repl size',value where value is
the largest expected value of your image data. Issue a reconfigure with
override after issuing this command.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"topher67" <t0ph3r1967@.netscape.net> wrote in message
news:1162862580.901319.171170@.m7g2000cwm.googlegro ups.com...
> On Thurs, Apr 26 2001 8:52 pm, Stoney said:
>
> I have this same error. Any suggestions?
> OLE exception from "cqole":
> SQLParamData: RETCODE=-1, State=37000, Native Error=7139
> SQL statement="update devtask [...] where dbid = 34163920 and version =
> 11"
> [Microsoft][ODBC SQL Server Driver][SQL Server]Length of text, ntext,
> or
> image data (73254) to be replicated exceeds configured maximum 65536.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> Win32::OLE(0.1702) error 0x80020009: "Exception occurred"
> in METHOD/PROPERTYGET "Commit"
> client: Windows 2003, OLE
> server: Windows 2003, Sql Server 2000
>