Consistency Errors in MS SQL Server 2000

Overview of Consistency Errors A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true: SQL Server loads data into a column that is a sql_variant data type. The data originates in another column that is a sql_variant data type and at some point the data is sent on-the-wire by SQL Server. The data is sent either directly to another server that is running SQL Server or to an intermediate file. The sql_variant column contains numeric values. Here are some examples of statements that could cause this behavior: An INSERT SELECT statement that specifies a remote server in the FROM clause of the SELECT statement. A bcp or a BULK INSERT statement from a file that was originally created by a SELECT statement from SQL Server. A data load using Data Transformation Services.