SQL Server Performance Forum – Threads Archive
Buffer provided to read column value is too small
Hi All, We have ASP.net 2.0/LLBL Pro Gen application which is hitting a SQL 2005 Standard Edition(SP 2) Database on Windows 2003 SP 1 . While searching a nvarchar column in any table (from Windows XP SP2 workstations) users are getting the following error :- Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption I got a link , but it did not help. I wonder if anybody has faced this problem. Meanwhile I will run profiler and see what is going on the database. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124755 pse help MadhuIs this a production server?
If so not advisable to have SP2 applied, as it is in CTP (beta) stages.
Also can you see any database consistency errors lately? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Hi Satya, No… it is not a production but Testing server. I saw in LLBL PRo Gen forum that it is a SQL 2005 bug and by installing sp2 it will be rectified. I ran the profiler, what LLBL Pro does is it simply executing Dynamic SQL using sp_executesql. I copied the statement from profiler and pasted the it in Query analyser, it is working fine. I am doing some R&D on this. i will let u know the result. thanks… Madhu
If it is a bug you’ve getting then you can report to Microsoft Connect. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Hi Satya, It is already reported on 15 Aug 06. Nobody has comeup with a solution. I hope that there is no point in reporting again. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124755 Madhu
]]>