Error Msg 8626

Hi all,
I have an sp which works fine on a server, but fails on my desktop engine
with the following error code:
Server: Msg 8626, Level 16, State 1,
Only text pointers are allowed in work tables, never text, ntext, or image
columns. The query processor produced a query plan that required a text,
ntext, or image column in a work table.
I have checked the sp but no text, ntext, or image column is involved in the
code !
Got any idea about it ?!
ThanksCould you provide a repro?
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"fdudan" <fdudan@.discussions.microsoft.com> wrote in message
news:0437938D-8959-47F7-826A-B95B6022286B@.microsoft.com...
> Hi all,
> I have an sp which works fine on a server, but fails on my desktop engine
> with the following error code:
> Server: Msg 8626, Level 16, State 1,
> Only text pointers are allowed in work tables, never text, ntext, or image
> columns. The query processor produced a query plan that required a text,
> ntext, or image column in a work table.
> I have checked the sp but no text, ntext, or image column is involved in
> the
> code !
> Got any idea about it ?!
> Thanks
>