I have few tables with datatype sql_variant.
invariably, during integrity check from the maintenance plan, I get these errors and this is happening for sql_variant columns only. I am thinking whether to get out of sql_variant and move to varchar().
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 2131642787, index ID 0, page (1:10854), row 55. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 2 and 0.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 900 consistency errors in database 'tst'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tst).
** Execution Time: 0 hrs, 1 mins, 14 secs **