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