JElster
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?
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?
ASKER
What does parse the sql statement the oldfashion way mean.
I rebuilt the indexes.. still same error
I rebuilt the indexes.. still same error
Did you run "DBCC CHECKDB"? What were the results?
ASKER
What am I looking for
CHECKDB found 0 allocation errors and 0 consistency errors in database
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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