Link to home
Start Free TrialLog in
Avatar of JElster
JElsterFlag for United States of America

asked on

Error when updating

Getting the following

Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

When updating a table between 2 servers/databases.

Can't find a solution.

Any ideas?
Avatar of Pratima
Pratima
Flag of India image

Try ou some of below

1. Rebuild Indexex
2.update package 2 for SP2
3. parse the SQL statement the old fashioned way
Refer for more details
http://www.sqlservercentral.com/Forums/Topic287524-149-1.aspx
Avatar of JElster

ASKER

What does parse the sql statement the oldfashion way mean.
I rebuilt the indexes.. still same error
Did you run "DBCC CHECKDB"?  What were the results?
Avatar of JElster

ASKER

What am I looking for

CHECKDB found 0 allocation errors and 0 consistency errors in database
Can you elaborate on your system and post the relevant code that is triggering the error?
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial