sql_variant datatype

• kraks

  SSC Veteran

  Points: 295

  More actions

  June 15, 2003 at 10:56 am

  #82376

  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 **

• crosspatch

  Hall of Fame

  Points: 3168

  More actions

  June 18, 2003 at 8:37 am

  #461925

  Depends what you're storing in the column.

  Personally I subscribe to the Keep It Simple philosophy. If you data can be represented in the simpler (and cross platform-compatible) VARCHAR type I would use that option

  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961

  
  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961