Solved

Error when updating

Posted on 2014-04-09
6
170 Views
Last Modified: 2014-04-12
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?
0
Comment
Question by:JElster
6 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
Comment Utility
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
0
 
LVL 1

Author Comment

by:JElster
Comment Utility
What does parse the sql statement the oldfashion way mean.
I rebuilt the indexes.. still same error
0
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
Did you run "DBCC CHECKDB"?  What were the results?
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 1

Author Comment

by:JElster
Comment Utility
What am I looking for

CHECKDB found 0 allocation errors and 0 consistency errors in database
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
Can you elaborate on your system and post the relevant code that is triggering the error?
0
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
Comment Utility
Hmm, interesting.

I suggest flushing the procedure/statement cache for that db, since there may be an obsolete object definition being used somewhere.

You'll need to get the database_id for that db:

DBCC FLUSHPROCINDB(<database_id>);


Also, I'd refresh all views in the db -- it won't hurt, and it might, with some luck, help:

EXEC sp_refreshview 'viewname'
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now