Attempting to Set a NonNULLable Column Value to NULL

Issue

Error message when performing a query on the Customer Search: Attempting to set a non-NULL-able column's value to NULL

Solution

Install Service Pack 1 for SQL2008 to resolve the error. Download available here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

Refer to the following article from Microsoft describing the problem: http://support.microsoft.com/kb/981037