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

column dataType
Joining 2 select statement with like fields
Query from a dynamic table
Applying a function to a subquery
Case statement question