Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prbsql
Starting Member
4 Posts |
 Posted - 2006-01-12 : 01:17:33
|
| Hi,I have two tables tab1 and tab2.One field in tab1 is defined as varchar datatype and the same field in tab2 is defined as ntext. When i am trying to insert the rows from tab1 to tab2 the msg 8626 is getting displayed.----Server: Msg 8626, Level 16, State 1, Procedure IMPORT_DATA_SP_Load_CSM_CALL_HISTORY, Line 175Only 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.----This error i am getting in the local machine but not coming in the server (In server also tab1 and tab2 has been defined as mentiond above)Please give me the solution.regards |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-08-25 : 16:29:38
|
| I found that this error occurred if I was mixing text and ntext. You probably need to change your varchar to nvarchar. |
 |
|
|
|
|
|
Msg 8626