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:21 PM by Imran Khan. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Imran Khan
New Member
New Member

--
11 Apr 2012 01:21 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.
You are not authorized to post a reply.

Acceptable Use Policy