Linked server from SQL Server 2008 R2 64 bit to SQL Server 2000 32 bit is failing on updated statement

Last Post 11 Apr 2012 01:20 PM by Imran Khan. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
Imran Khan
New Member
New Member

--
11 Apr 2012 01:20 PM
Hi,


linked server problem when I run update statement from SQL Server 2008 R2 64 bit to SQL Server 2000 32 bit. It returns error given below;

Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

I have tried every thing and have created sp_tables_info_rowset_64 stored procedure in master database of SQL Server 2000. It enabled select and insert into the SQL Server 2000 database tables but when I try to Update records on SQL Server 2000 database tables above error comes up.

Any comments and suggestions are appreciated.

Thanks.


Acceptable Use Policy
---