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


  Wednesday, September 19, 2018


bob tech
Contact Bob
VW Buses
Cook Book


Halloween_2007 _45.JPG

  bob Links
Google Search copy v...
Mother's in the kitchen washing out the jugs, Sister's in the pantry bottling the suds, Father's in the cellar mixing up the hops, Johnny's on the front porch watching for the cops. - Prohibition Song
Wider View Insert

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

Insert Category

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.