Consistency Errors in MS SQL Server 2000

home
database
view story

1 Kicks

Consistency Errors in MS SQL Server 2000(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

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.

add a comment |category: Database |Views: 1
Tweet