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?
LVL 1
JElsterAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
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
 
Pratima PharandeCommented:
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
 
JElsterAuthor Commented:
What does parse the sql statement the oldfashion way mean.
I rebuilt the indexes.. still same error
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Scott PletcherSenior DBACommented:
Did you run "DBCC CHECKDB"?  What were the results?
0
 
JElsterAuthor Commented:
What am I looking for

CHECKDB found 0 allocation errors and 0 consistency errors in database
0
 
Anthony PerkinsCommented:
Can you elaborate on your system and post the relevant code that is triggering the error?
0
All Courses

From novice to tech pro — start learning today.