This error may occur when trying to preview SQL server tables that contain fields defined as SMALLDATETIME:
"There was an error loading records. The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."
The tables will be listed under the OLE DB connection object in the TOC, in ArcCatalog/ArcMap, but the data cannot be previewed.
This is due to a data type conversion error when making the connection to the database using either the Microsoft OLE DB provider for SQL Server, or the Microsoft OLE DB provider for ODBC drivers (and an ODBC DSN).