Sessions: 56 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.


  Sunday, October 1, 2023
Wider View Login

IBM - AS400
Performance Counters
Service Broker
SQL Server
     Temporary Database
     SQL Mail
     DTS - Data Transformation Services
     Jobs SQL Agent
          CHECKDB With Data Pu...
          Displaying a trace o...
     User Management
     System Databases
     Temp Tables
Windows OS

Will be added as a sub-category of, DBCC
CHECKDB With Data Purity

When upgrading from sql server 2000 to 2005, a dbcc checkdb must be run at least once with data_purity.

If an error occurs with the data_purity, these rows should be fixed.  Some fixes can be done by updating the data or by running dbcc updateuseage {table_name / index}, the error / message from checkdb will contain the table_name and/or index to run updateuseage with.