- If you sure your Ms SQL server SP version is greater than SP2 and no need to cumulative service pack 2.
- If you checked report after DBCC CHECKDB and found no error so no need to fix MDF file
- If you can’t find the reason of that buffer error even installed the hot fixes or last SP
For ex If you have a query like Select fxCustomTrim(A) as A , B from tblDestination
And if your fxCustomTrim() function had a return value like “RETURNS varchar(8000)” so change its return max value that you need like varchar(250) so it resolves the buffer error. I don’t know yet why but researching.