Symptoms
Quick Search on ListView throwing errors if "All Columns" is selected
Error:
The conversion of the nvarchar value '20160222161503' overflowed an int column.
Diagnoses
The problem occurs if you have int field and enter more that 10 numbers in the search box.
Resolution
change the ID field and any other int field to "bigInt". This will give exactly 19 characters more to search with before giving the same issue.
Another work around is to create a stored procedure for searching only (and fixed sorting) where you cast the ID to a Varchar. Eg:
SELECT CAST(SID] as Varchar(19)) as ID,
FROM OK2].2dbo].oSmoIt]
