Hello,
I am using an insert statement in a stored procedure that insert and image
datatype column into a table on a different sql server, same edition server
2000.
It was working a few days ago in a job, but I had to stop the server to
defragment the drive. Now the stored procedure produces message 8626  and
warns me that I can only use text pointers in a work table and the query plan
produced requires image column in a work table.
However, the image column is the data that I require for further processing.
Does anyone know how to resolve this problem?

Are your statistics up to date? What is the data/index fragmentation?


ML

---
http://milambda.blogspot.com/

The data blocks are about 9 gig's each and it's still really fragmented.
I don't remember how to check the statistics at the moment.

thanks for the response,
Chieko

Show quoteHide quote

Tuning
Changing resultset to 1 row and 1 column
Slow update on SQL Virtual Server 2000 on WIN2003 cluster
Question on QUOTED_IDENTIFIER
Interesting Fundamental Questions about Tables
DateTime Formatting Question
Stored Procedure Lock?
Help wit a complicated query
Ingnorant about encryption with symmetric key and certificates
add a count column