News on my problem!
I've tried to substitute the line
REPLACE Picture WITH FILETOSTR(cImageFile)
with
REPLACE Picture WITH LEFT(FILETOSTR(cImageFile), 8000)
and the update don't emit error.
So the maximun limit is 8000 bytes ...
In the BOL of SQL Server where there is specified that for text, ntext and image you can use the UPTDATEXT, WRITETEXT ecc... (more quick because not logged) but there is no limitations about using UPDATE against image fields, so the update should'nt be in error!? or i haven't Understand the BOL ? Someone can help me ?
The Part of BOL that i'm not sure is the following:
----------------------------------------------------------------------
Note The UPDATE statement is logged. If you are replacing or modifying large blocks of text, ntext, or image data, use the WRITETEXT or UPDATETEXT statement instead of the UPDATE statement. The WRITETEXT and UPDATETEXT statements (by default) are not logged.
----------------------------------------------------------------------
Thanx in Advance.
bye, Emanuele!
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.