Only text pointers are allowed in work tables

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Only text pointers are allowed in work tables

Author

Topic

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-05-03 : 13:31:13

I have this problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269426

But I dont have this problem in a select. I have it in an update. So a union of a left and right join cant be used to solve the problem.
Can anyone help?

UPDATE C
SET C.varchar4000Col = EC.TextCol
FROM C
INNER JOIN linkserver.mydb.dbo.CC ON CC.CO_ID = C.CO_ID
INNER JOIN linkserver.mydb.dbo.EC on EC.ID = CC.EC_ID
WHERE C.CO_ID is not null
and cc.number = 0

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-03 : 16:01:54

I would say the problem lies in using the linked server. If you copy the linked server tables to local tables and rewrite the join to use the local tables, you may fix the problem.

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-05-04 : 06:04:40

that worked, thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources