Hello,

I am not a SQL expert, so any help is much appreciated.

Running the dbcc checkdb query finds the following errors in the database.

"CHECKDB found 0 allocation errors and 2 consistency errors in database 'Production'"

I also looked in the windows event logs and see the last time there weren't consistency errors was about 2 weeks ago.

Doing some Google searches, I can see that the best way to remedy this problem is to restore the DB from backups. Unfortunately, I don't have backups for each day since the problem began. Note, I am doing full backups each day, but the tapes are overwritten, except for the month end and then 5 Friday tapes are overwritten each week. So I have a Friday backup about 5 days before it happened, but not the daily transaction log backups for every day until the present, which I believe is what I need. Also, the recovery model is set to full.

It sounds like if I run a repair, then I will lose data. Is this always the case? Is it possible rebooting the server and running a chkdsk could fix this or is that just wishful thinking?

Thank you,

G

• It sounds like if I run a repair, then I will lose data. Is this always the case?

If you run repair, you will lose those pages/data that we cant predict. If you have a QA/TEST box you can take a backup of corrupted DB, Restore it take a row count and then run DBCC CHECKDB with repair_allow_dataloss. once its completed you can check the ROW count again to see the # of missing rows.

==>good to use CONTINUE_AFTER_ERROR during backup/restore just in case they fail

• Is it possible rebooting the server and running a chkdsk could fix this or is that just wishful thinking?

If you reboot, there are chances that your DB may not come online. I don't recommend that option. Also post your entire checkdb results to understand if the consistency is with User objects or system objects. What's the size of DB ?

Thank you so much.

Can you tell me what the syntax is for the repair?

To compare the row count, is it just running the dbcc checkdb query and comparing each row before and after the repair? Is that what you mean by checking the rows?

I keep getting an "Unexpected Error" message when trying to paste the dbcc results here. I'll try to do it in separate posts.

Thanks again!

checkdb results - 1

There are 0 rows in 0 pages for object "WC_AK_SUPP".
DBCC results for 'AD_FORMS_HIST'.
There are 0 rows in 0 pages for object "AD_FORMS_HIST".
DBCC results for 'CLAIM_ACCORD_SUPP'.
There are 104 rows in 1 pages for object "CLAIM_ACCORD_SUPP".
DBCC results for 'EVENT_SENTINEL'.
There are 4941 rows in 19 pages for object "EVENT_SENTINEL".
DBCC results for 'PROPERTY_UNIT_STGNG'.
There are 0 rows in 0 pages for object "PROPERTY_UNIT_STGNG".
DBCC results for 'CLAIM_X_SITELOSS'.
There are 0 rows in 0 pages for object "CLAIM_X_SITELOSS".
DBCC results for 'RSW_RES_CUSTOMIZATION'.
There are 2 rows in 1 pages for object "RSW_RES_CUSTOMIZATION".
DBCC results for 'WC_AL_SUPP'.
There are 0 rows in 0 pages for object "WC_AL_SUPP".
DBCC results for 'EVENT_SUPP'.
There are 0 rows in 0 pages for object "EVENT_SUPP".
DBCC results for 'LOCATION_SELECTED'.
There are 0 rows in 0 pages for object "LOCATION_SELECTED".
DBCC results for 'INDEX_UPDATE_PROCESS_LOG'.
There are 618 rows in 12 pages for object "INDEX_UPDATE_PROCESS_LOG".
DBCC results for 'WCP_AGNCY_SERV_ZIP'.
There are 1147 rows in 11 pages for object "WCP_AGNCY_SERV_ZIP".
DBCC results for 'ENT_X_CONTACTINFO'.
There are 0 rows in 0 pages for object "ENT_X_CONTACTINFO".
DBCC results for 'WC_AR_SUPP'.
There are 0 rows in 0 pages for object "WC_AR_SUPP".
DBCC results for 'POLICY_X_FORMS_ENH'.
There are 0 rows in 0 pages for object "POLICY_X_FORMS_ENH".
DBCC results for 'CLAIM_ACCORD_MAPPI'.
There are 0 rows in 0 pages for object "CLAIM_ACCORD_MAPPI".
DBCC results for 'EVENT_X_ACTION'.
Msg 2508, Level 16, State 3, Line 3
The In-row data RSVD page count for object "EVENT_X_ACTION", index ID 0, partition ID 46502875365376, alloc unit ID 46502875365376 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
There are 12080 rows in 26 pages for object "EVENT_X_ACTION".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'EVENT_X_ACTION' (object ID 709577566).
DBCC results for 'SITE_UNIT_STGNG'.
There are 0 rows in 0 pages for object "SITE_UNIT_STGNG".
DBCC results for 'SITE_UNIT'.
There are 0 rows in 0 pages for object "SITE_UNIT".
DBCC results for 'RSW_CUSTOM_TRANSTYPE'.
There are 2 rows in 1 pages for object "RSW_CUSTOM_TRANSTYPE".
DBCC results for 'WC_AZ_SUPP'.
There are 0 rows in 0 pages for object "WC_AZ_SUPP".
DBCC results for 'WCP_PPD_WEEKS'.
There are 20 rows in 1 pages for object "WCP_PPD_WEEKS".
DBCC results for 'EVENT_X_DATED_TEXT'.
There are 3 rows in 1 pages for object "EVENT_X_DATED_TEXT".
DBCC results for 'UNIT_SELECTED'.
There are 0 rows in 0 pages for object "UNIT_SELECTED".
DBCC results for 'INDEX_UPDATE_CREATE_LOG'.
There are 1041 rows in 26 pages for object "INDEX_UPDATE_CREATE_LOG".
DBCC results for 'CHECK_STOCK_FORMS'.
There are 0 rows in 0 pages for object "CHECK_STOCK_FORMS".
DBCC results for 'WPA_EMAIL_ENTRY'.
There are 0 rows in 0 pages for object "WPA_EMAIL_ENTRY".
DBCC results for 'WC_CA_SUPP'.
There are 0 rows in 0 pages for object "WC_CA_SUPP".
DBCC results for 'UNIT_SELECTED_SUPP'.
There are 0 rows in 0 pages for object "UNIT_SELECTED_SUPP".
DBCC results for 'CL_FORMS_HIST'.
There are 0 rows in 0 pages for object "CL_FORMS_HIST".
DBCC results for 'EVENT_X_MEDW_SUPP'.
There are 0 rows in 0 pages for object "EVENT_X_MEDW_SUPP".
DBCC results for 'DISABILITY_PLAN'.
There are 0 rows in 0 pages for object "DISABILITY_PLAN".
DBCC results for 'VEHICLE_STGNG'.
There are 0 rows in 0 pages for object "VEHICLE_STGNG".
DBCC results for 'CLAIM_X_OTHERUNIT'.
There are 0 rows in 0 pages for object "CLAIM_X_OTHERUNIT".
DBCC results for 'ORG_SECURITY_EIDS'.
There are 0 rows in 0 pages for object "ORG_SECURITY_EIDS".
DBCC results for 'EVENT_PSO'.
There are 0 rows in 0 pages for object "EVENT_PSO".
DBCC results for 'CHK_STUB_TEXT_MAP'.
There are 0 rows in 0 pages for object "CHK_STUB_TEXT_MAP".
DBCC results for 'WC_CO_SUPP'.
There are 0 rows in 0 pages for object "WC_CO_SUPP".
DBCC results for 'WCP_TOTDIS_LIMITS'.
There are 12 rows in 1 pages for object "WCP_TOTDIS_LIMITS".
DBCC results for 'SYS_POL_TAX'.
There are 0 rows in 0 pages for object "SYS_POL_TAX".
DBCC results for 'EVENT_X_MEDW_TEST'.
There are 0 rows in 0 pages for object "EVENT_X_MEDW_TEST".
DBCC results for 'UNIT_POLICY'.
There are 0 rows in 0 pages for object "UNIT_POLICY".
DBCC results for 'EXISTING_INDICES'.
There are 618 rows in 6 pages for object "EXISTING_INDICES".
DBCC results for 'WC_CT_SUPP'.
There are 0 rows in 0 pages for object "WC_CT_SUPP".
DBCC results for 'WC_GU_SUPP'.
There are 0 rows in 0 pages for object "WC_GU_SUPP".
DBCC results for 'EVENT_X_MEDWATCH'.
There are 4941 rows in 79 pages for object "EVENT_X_MEDWATCH".
DBCC results for 'DISABILITY_CLASS'.
There are 0 rows in 0 pages for object "DISABILITY_CLASS".
DBCC results for 'PS_ENDORSEMENT_STGNG'.
There are 0 rows in 0 pages for object "PS_ENDORSEMENT_STGNG".
DBCC results for 'SUPP_MULTI_VALUE'.
There are 0 rows in 0 pages for object "SUPP_MULTI_VALUE".
DBCC results for 'OTHER_UNIT'.
There are 0 rows in 0 pages for object "OTHER_UNIT".
DBCC results for 'CURRENCY_RATE'.
There are 6 rows in 1 pages for object "CURRENCY_RATE".
DBCC results for 'BATCH_PRINT'.
There are 0 rows in 0 pages for object "BATCH_PRINT".
DBCC results for 'WC_DC_SUPP'.
There are 0 rows in 0 pages for object "WC_DC_SUPP".
DBCC results for 'WCP_LIFEPEN_LIMITS'.
There are 5 rows in 1 pages for object "WCP_LIFEPEN_LIMITS".
DBCC results for 'EVENT_X_OSHA'.
There are 4942 rows in 54 pages for object "EVENT_X_OSHA".
DBCC results for 'UNIT_THIRD_PARTY'.
There are 0 rows in 0 pages for object "UNIT_THIRD_PARTY".
DBCC results for 'FINAL_INDICES'.
There are 714 rows in 8 pages for object "FINAL_INDICES".
DBCC results for 'PORTALITEMS'.
There are 5 rows in 1 pages for object "PORTALITEMS".
DBCC results for 'WC_DE_SUPP'.
There are 0 rows in 0 pages for object "WC_DE_SUPP".
DBCC results for 'WC_NB_SUPP'.
There are 0 rows in 0 pages for object "WC_NB_SUPP".
DBCC results for 'PMT_APPROVAL_HIST'.
There are 10987 rows in 92 pages for object "PMT_APPROVAL_HIST".
DBCC results for 'EVENT_X_OSHA_SUPP'.
There are 0 rows in 0 pages for object "EVENT_X_OSHA_SUPP".
DBCC results for 'DIS_PLAN_SUPP'.
There are 0 rows in 0 pages for object "DIS_PLAN_SUPP".
DBCC results for 'WRCMP_FACTOR'.
There are 0 rows in 0 pages for object "WRCMP_FACTOR".
DBCC results for 'BATCH_PRINT_ACORD'.
There are 0 rows in 0 pages for object "BATCH_PRINT_ACORD".
DBCC results for 'WC_FL_SUPP'.
There are 0 rows in 0 pages for object "WC_FL_SUPP".
DBCC results for 'CLAIM_PRG_NOTE_TEMPLATES'.
There are 0 rows in 0 pages for object "CLAIM_PRG_NOTE_TEMPLATES".
DBCC results for 'EVENT_X_OUTCOME'.
Msg 2508, Level 16, State 3, Line 3
The In-row data RSVD page count for object "EVENT_X_OUTCOME", index ID 0, partition ID 53842933514240, alloc unit ID 53842933514240 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
There are 12080 rows in 26 pages for object "EVENT_X_OUTCOME".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'EVENT_X_OUTCOME' (object ID 821577965).
DBCC results for 'COVERAGE_DETAIL'.
There are 0 rows in 0 pages for object "COVERAGE_DETAIL".
DBCC results for 'OPTIMUM_INDICES'.
There are 598 rows in 7 pages for object "OPTIMUM_INDICES".
DBCC results for 'WC_AB_SUPP'.
There are 0 rows in 0 pages for object "WC_AB_SUPP".
DBCC results for 'POINT_UNIT_DATA'.
There are 0 rows in 0 pages for object "POINT_UNIT_DATA".
DBCC results for 'PORTALTEMPLATE'.
There are 0 rows in 0 pages for object "PORTALTEMPLATE".
DBCC results for 'WC_GA_SUPP'.
There are 0 rows in 0 pages for object "WC_GA_SUPP".
DBCC results for 'WC_NS_SUPP'.
There are 0 rows in 0 pages for object "WC_NS_SUPP".
DBCC results for 'ADJUSTER_FROI_ACORD'.
There are 0 rows in 0 pages for object "ADJUSTER_FROI_ACORD".
DBCC results for 'EXPERT'.
There are 2 rows in 1 pages for object "EXPERT".
DBCC results for 'DIS_PLAN_X_INSURED'.
There are 0 rows in 0 pages for object "DIS_PLAN_X_INSURED".
DBCC results for 'DRIVER_SUPP'.
There are 0 rows in 0 pages for object "DRIVER_SUPP".
DBCC results for 'UNIT_STAT'.
There are 0 rows in 0 pages for object "UNIT_STAT".
DBCC results for 'WC_HI_SUPP'.
There are 0 rows in 0 pages for object "WC_HI_SUPP".
DBCC results for 'SYS_UTIL_CLM_LTR'.
There are 0 rows in 0 pages for object "SYS_UTIL_CLM_LTR".
DBCC results for 'EXPERT_SUPP'.
There are 0 rows in 0 pages for object "EXPERT_SUPP".
DBCC results for 'EDI_MTC_MAP'.
There are 0 rows in 0 pages for object "EDI_MTC_MAP".
DBCC results for 'WC_BC_SUPP'.
There are 0 rows in 0 pages for object "WC_BC_SUPP".
DBCC results for 'RMNET_MODULES'.
There are 11 rows in 1 pages for object "RMNET_MODULES".
DBCC results for 'WC_IA_SUPP'.
There are 0 rows in 0 pages for object "WC_IA_SUPP".
DBCC results for 'WC_PE_SUPP'.
There are 0 rows in 0 pages for object "WC_PE_SUPP".
DBCC results for 'WORK_LOSS_MAPPING'.
There are 0 rows in 0 pages for object "WORK_LOSS_MAPPING".
DBCC results for 'FALL_IND_SUPP'.
There are 0 rows in 0 pages for object "FALL_IND_SUPP".
DBCC results for 'DIS_CLASS_TD'.
There are 0 rows in 0 pages for object "DIS_CLASS_TD".
DBCC results for 'CLAIM_X_POLICY'.
There are 0 rows in 0 pages for object "CLAIM_X_POLICY".
DBCC results for 'WC_ID_SUPP'.
There are 0 rows in 0 pages for object "WC_ID_SUPP".
DBCC results for 'CONTACT_LOB'.
There are 0 rows in 0 pages for object "CONTACT_LOB".
DBCC results for 'FALL_INDICATOR'.
There are 4942 rows in 36 pages for object "FALL_INDICATOR".
DBCC results for 'WCP_DATA_BODY_MEMB'.
There are 0 rows in 0 pages for object "WCP_DATA_BODY_MEMB".
DBCC results for 'WC_ON_SUPP'.
There are 0 rows in 0 pages for object "WC_ON_SUPP".
DBCC results for 'PI_X_INJURY_SUPP'.
There are 0 rows in 0 pages for object "PI_X_INJURY_SUPP".
DBCC results for 'RMNET_MODULES_USER'.
There are 0 rows in 0 pages for object "RMNET_MODULES_USER".
DBCC results for 'WC_IL_SUPP'.
There are 0 rows in 0 pages for object "WC_IL_SUPP".
DBCC results for 'WC_SK_SUPP'.
There are 0 rows in 0 pages for object "WC_SK_SUPP".
DBCC results for 'AUTO_ASSIGN_ADJ'.
There are 0 rows in 0 pages for object "AUTO_ASSIGN_ADJ".
DBCC results for 'FEE_TABLES'.
There are 0 rows in 0 pages for object "FEE_TABLES".
DBCC results for 'DIS_CLASS_WAIT'.
There are 0 rows in 0 pages for object "DIS_CLASS_WAIT".
DBCC results for 'WC_IN_SUPP'.
There are 0 rows in 0 pages for object "WC_IN_SUPP".
DBCC results for 'CUST_RATE'.
There are 0 rows in 0 pages for object "CUST_RATE".
DBCC results for 'DCC_REPORTS_USER'.
There are 0 rows in 0 pages for object "DCC_REPORTS_USER".
DBCC results for 'WC_KS_SUPP'.
There are 0 rows in 0 pages for object "WC_KS_SUPP".
DBCC results for 'FISCAL_YEAR'.
There are 32 rows in 1 pages for object "FISCAL_YEAR".
DBCC results for 'PI_X_BODY_MEMBER'.
There are 0 rows in 0 pages for object "PI_X_BODY_MEMBER".
DBCC results for 'CUST_RATE_DETAIL'.
There are 0 rows in 0 pages for object "CUST_RATE_DETAIL".
DBCC results for 'GROUP_PROGR'.
There are 99 rows in 2 pages for object "GROUP_PROGR".
DBCC results for 'WC_KY_SUPP'.
There are 0 rows in 0 pages for object "WC_KY_SUPP".
DBCC results for 'FISCAL_YEAR_CLIENT'.
There are 11 rows in 1 pages for object "FISCAL_YEAR_CLIENT".
DBCC results for 'ACCT_REC'.
There are 0 rows in 0 pages for object "ACCT_REC".
DBCC results for 'LINKS'.
There are 0 rows in 0 pages for object "LINKS".
DBCC results for 'CLAIM_INCID'.
There are 5151 rows in 65 pages for object "CLAIM_INCID".
DBCC results for 'WC_LA_SUPP'.
There are 0 rows in 0 pages for object "WC_LA_SUPP".
DBCC results for 'FISCAL_YEAR_PERIOD'.
There are 2 rows in 1 pages for object "FISCAL_YEAR_PERIOD".
DBCC results for 'ACCT_REC_DETAIL'.
There are 0 rows in 0 pages for object "ACCT_REC_DETAIL".
DBCC results for 'CLAIM_X_SUBRO'.
There are 14 rows in 1 pages for object "CLAIM_X_SUBRO".
DBCC results for 'WC_MA_SUPP'.
There are 0 rows in 0 pages for object "WC_MA_SUPP".
DBCC results for 'ENTITY_NON_AVL'.
There are 0 rows in 0 pages for object "ENTITY_NON_AVL".
DBCC results for 'FORM_PRINT_DATA'.
There are 1735 rows in 19 pages for object "FORM_PRINT_DATA".
DBCC results for 'PATIENT'.
There are 4 rows in 1 pages for object "PATIENT".
DBCC results for 'ACC_SERVICE_CODE'.
There are 0 rows in 0 pages for object "ACC_SERVICE_CODE".
DBCC results for 'SUBROGATION_SUPP'.
There are 0 rows in 0 pages for object "SUBROGATION_SUPP".
DBCC results for 'WC_MD_SUPP'.
There are 0 rows in 0 pages for object "WC_MD_SUPP".
DBCC results for 'FORM_PRINT_PROCS'.
There are 100 rows in 1 pages for object "FORM_PRINT_PROCS".
DBCC results for 'WCP_FRIENDLY_CALC'.
There are 0 rows in 0 pages for object "WCP_FRIENDLY_CALC".
DBCC results for 'SUB_ACC_SERV_CODE'.
There are 0 rows in 0 pages for object "SUB_ACC_SERV_CODE".
DBCC results for 'WC_ME_SUPP'.
There are 0 rows in 0 pages for object "WC_ME_SUPP".
DBCC results for 'INVDETAIL_X_MOD'.
There are 0 rows in 0 pages for object "INVDETAIL_X_MOD".
DBCC results for 'ENTITY_X_ADDRESSES'.
There are 52016 rows in 498 pages for object "ENTITY_X_ADDRESSES".
DBCC results for 'FORM_STATES'.
There are 59 rows in 1 pages for object "FORM_STATES".
DBCC results for 'PATIENT_DRG_CODES'.
There are 0 rows in 0 pages for object "PATIENT_DRG_CODES".
DBCC results for 'PI_X_MMI_HIST'.
There are 0 rows in 0 pages for object "PI_X_MMI_HIST".
DBCC results for 'WC_MI_SUPP'.
There are 0 rows in 0 pages for object "WC_MI_SUPP".
DBCC results for 'FUNDS'.
There are 83491 rows in 4802 pages for object "FUNDS".
DBCC results for 'WCP_FRIENDLY_NAME'.
There are 0 rows in 0 pages for object "WCP_FRIENDLY_NAME".
DBCC results for 'DEMAND_OFFER'.
There are 0 rows in 0 pages for object "DEMAND_OFFER".
DBCC results for 'WC_MN_SUPP'.
There are 0 rows in 0 pages for object "WC_MN_SUPP".
DBCC results for 'OSHA_OPTIONS'.
There are 1 rows in 1 pages for object "OSHA_OPTIONS".
DBCC results for 'ADDRESS_X_PHONEINFO'.
There are 47719 rows in 169 pages for object "ADDRESS_X_PHONEINFO".
DBCC results for 'FUNDS_AUTO'.
There are 0 rows in 0 pages for object "FUNDS_AUTO".
DBCC results for 'PATIENT_ATTN_PHYS'.
There are 0 rows in 0 pages for object "PATIENT_ATTN_PHYS".
DBCC results for 'PARMS_NAME_VALUE'.
There are 111 rows in 3 pages for object "PARMS_NAME_VALUE".
DBCC results for 'DEMAND_OFFER_SUPP'.
There are 0 rows in 0 pages for object "DEMAND_OFFER_SUPP".
DBCC results for 'WC_MO_SUPP'.
There are 0 rows in 0 pages for object "WC_MO_SUPP".
DBCC results for 'FUNDS_AUTO_BATCH'.
There are 0 rows in 0 pages for object "FUNDS_AUTO_BATCH".
DBCC results for 'WC_MS_SUPP'.
There are 0 rows in 0 pages for object "WC_MS_SUPP".
DBCC results for 'CONF_EVENT_PERM'.
There are 0 rows in 0 pages for object "CONF_EVENT_PERM".
DBCC results for 'FUNDS_AUTO_SPLIT'.
There are 0 rows in 0 pages for object "FUNDS_AUTO_SPLIT".
DBCC results for 'WCP_PAYROL_PERID'.
There are 0 rows in 0 pages for object "WCP_PAYROL_PERID".
DBCC results for 'PATIENT_DIAGNOSIS'.
There are 0 rows in 0 pages for object "PATIENT_DIAGNOSIS".
DBCC results for 'PI_X_MED_COND'.
There are 0 rows in 0 pages for object "PI_X_MED_COND".
DBCC results for 'WC_MT_SUPP'.
There are 0 rows in 0 pages for object "WC_MT_SUPP".
DBCC results for 'GROUP_MAP'.
There are 0 rows in 0 pages for object "GROUP_MAP".
DBCC results for 'FUNDS_DEPOSIT'.
There are 0 rows in 0 pages for object "FUNDS_DEPOSIT".
DBCC results for 'PI_X_DIAG_HIST'.
There are 0 rows in 0 pages for object "PI_X_DIAG_HIST".
DBCC results for 'WC_NC_SUPP'.
There are 0 rows in 0 pages for object "WC_NC_SUPP".
DBCC results for 'ISO_CLAIM_SUB_HIST'.
There are 0 rows in 0 pages for object "ISO_CLAIM_SUB_HIST".
DBCC results for 'FUNDS_DET_LIMITS'.

checkdb results 2

There are 1 rows in 1 pages for object "FUNDS_DET_LIMITS".
DBCC results for 'CLAIM_AWW_X_ADD'.
There are 0 rows in 0 pages for object "CLAIM_AWW_X_ADD".
DBCC results for 'PATIENT_ACT_TAKEN'.
There are 0 rows in 0 pages for object "PATIENT_ACT_TAKEN".
DBCC results for 'CODE_X_CODE'.
There are 0 rows in 0 pages for object "CODE_X_CODE".
DBCC results for 'WC_ND_SUPP'.
There are 0 rows in 0 pages for object "WC_ND_SUPP".
DBCC results for 'CL_ISO_CODE_MAP'.
There are 0 rows in 0 pages for object "CL_ISO_CODE_MAP".
DBCC results for 'FUNDS_LIMITS'.
There are 1 rows in 1 pages for object "FUNDS_LIMITS".
DBCC results for 'PAT_X_RESC_INERVEN_PSO'.
There are 0 rows in 0 pages for object "PAT_X_RESC_INERVEN_PSO".
DBCC results for 'ENTITY_X_SELFINSUR'.
There are 1 rows in 1 pages for object "ENTITY_X_SELFINSUR".
DBCC results for 'CLAIM_X_ARB'.
There are 0 rows in 0 pages for object "CLAIM_X_ARB".
DBCC results for 'WC_NE_SUPP'.
There are 0 rows in 0 pages for object "WC_NE_SUPP".
DBCC results for 'CL_ISO_LOSS_TYPE_MAP'.
There are 0 rows in 0 pages for object "CL_ISO_LOSS_TYPE_MAP".
DBCC results for 'FUNDS_SUPP'.
There are 0 rows in 0 pages for object "FUNDS_SUPP".
DBCC results for 'PATIENT_PROCEDURE'.
There are 0 rows in 0 pages for object "PATIENT_PROCEDURE".
DBCC results for 'WC_NH_SUPP'.
There are 0 rows in 0 pages for object "WC_NH_SUPP".
DBCC results for 'FUNDS_TRANS_SPLIT'.
There are 86347 rows in 2220 pages for object "FUNDS_TRANS_SPLIT".
DBCC results for 'CLAIM_AWW_X_PERIOD'.
There are 0 rows in 0 pages for object "CLAIM_AWW_X_PERIOD".
DBCC results for 'SYS_TRANS_CLOSE'.
There are 0 rows in 0 pages for object "SYS_TRANS_CLOSE".
DBCC results for 'WC_NJ_SUPP'.
There are 0 rows in 0 pages for object "WC_NJ_SUPP".
DBCC results for 'GLOSSARY'.
There are 1352 rows in 11 pages for object "GLOSSARY".
DBCC results for 'OFFSET_MAPPING'.
There are 0 rows in 0 pages for object "OFFSET_MAPPING".
DBCC results for 'PATIENT_SUPP'.
There are 0 rows in 0 pages for object "PATIENT_SUPP".
DBCC results for 'PAT_X_RESC_INERVEN_NEO_PSO'.
There are 0 rows in 0 pages for object "PAT_X_RESC_INERVEN_NEO_PSO".
DBCC results for 'WEB_LINKS_PERMISSION'.
There are 0 rows in 0 pages for object "WEB_LINKS_PERMISSION".
DBCC results for 'WC_NM_SUPP'.
There are 0 rows in 0 pages for object "WC_NM_SUPP".
DBCC results for 'GLOSSARY_TEXT'.
There are 1362 rows in 8 pages for object "GLOSSARY_TEXT".
DBCC results for 'SYS_RES_AUTOADJ'.
There are 0 rows in 0 pages for object "SYS_RES_AUTOADJ".
DBCC results for 'WC_NV_SUPP'.
There are 0 rows in 0 pages for object "WC_NV_SUPP".
DBCC results for 'GRAPH_USERDEFINED'.
There are 0 rows in 0 pages for object "GRAPH_USERDEFINED".
DBCC results for 'ACCT_LOCK'.
There are 1 rows in 1 pages for object "ACCT_LOCK".
DBCC results for 'PATIENT_PROC_SUPP'.
There are 0 rows in 0 pages for object "PATIENT_PROC_SUPP".
DBCC results for 'RSV_SUP_APPROVAL_HIST'.
There are 0 rows in 0 pages for object "RSV_SUP_APPROVAL_HIST".
DBCC results for 'WC_NY_SUPP'.
There are 0 rows in 0 pages for object "WC_NY_SUPP".
DBCC results for 'PROPERTY_UNIT'.
There are 0 rows in 0 pages for object "PROPERTY_UNIT".
DBCC results for 'GROUP_PERMISSIONS'.
There are 21456 rows in 116 pages for object "GROUP_PERMISSIONS".
DBCC results for 'FL_CTL_NUMBER'.
There are 0 rows in 0 pages for object "FL_CTL_NUMBER".
DBCC results for 'EVENT_X_INTERVEN_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_INTERVEN_PSO".
DBCC results for 'CL_RES_PAY_LMTS'.
There are 0 rows in 0 pages for object "CL_RES_PAY_LMTS".
DBCC results for 'WC_OH_SUPP'.
There are 0 rows in 0 pages for object "WC_OH_SUPP".
DBCC results for 'HAZ_MAT'.
There are 0 rows in 0 pages for object "HAZ_MAT".
DBCC results for 'UNIT_THIRD_SUPP'.
There are 0 rows in 0 pages for object "UNIT_THIRD_SUPP".
DBCC results for 'PATIENT_TREATMENT'.
There are 0 rows in 0 pages for object "PATIENT_TREATMENT".
DBCC results for 'NET_LAYOUTS_MEMBERS'.
There are 4 rows in 1 pages for object "NET_LAYOUTS_MEMBERS".
DBCC results for 'WC_OK_SUPP'.
There are 0 rows in 0 pages for object "WC_OK_SUPP".
DBCC results for 'HELP_DEF'.
There are 327 rows in 3 pages for object "HELP_DEF".
DBCC results for 'SUPP_GRID_DICT'.
There are 0 rows in 0 pages for object "SUPP_GRID_DICT".
DBCC results for 'ENTITY_X_CODELICEN'.
There are 0 rows in 0 pages for object "ENTITY_X_CODELICEN".
DBCC results for 'WC_OR_SUPP'.
There are 0 rows in 0 pages for object "WC_OR_SUPP".
DBCC results for 'HELP_DEF_TEXT'.
There are 327 rows in 2 pages for object "HELP_DEF_TEXT".
DBCC results for 'PATIENT_BODY_PART'.
There are 0 rows in 0 pages for object "PATIENT_BODY_PART".
DBCC results for 'PAT_X_MAT_OUTCM_PSO'.
There are 0 rows in 0 pages for object "PAT_X_MAT_OUTCM_PSO".
DBCC results for 'POLICY_X_WEB'.
There are 0 rows in 0 pages for object "POLICY_X_WEB".
DBCC results for 'WC_PA_SUPP'.
There are 0 rows in 0 pages for object "WC_PA_SUPP".
DBCC results for 'INDICATOR'.
There are 18 rows in 1 pages for object "INDICATOR".
DBCC results for 'SUPP_GRID_VALUE'.
There are 0 rows in 0 pages for object "SUPP_GRID_VALUE".
DBCC results for 'ECU_TABLE_CHECK'.
There are 81 rows in 1 pages for object "ECU_TABLE_CHECK".
DBCC results for 'WC_RI_SUPP'.
There are 0 rows in 0 pages for object "WC_RI_SUPP".
DBCC results for 'INVDETAIL_X_DIAG'.
There are 0 rows in 0 pages for object "INVDETAIL_X_DIAG".
DBCC results for 'PATIENT_INJURY'.
There are 0 rows in 0 pages for object "PATIENT_INJURY".
DBCC results for 'CASE_MANAGEMENT'.
There are 0 rows in 0 pages for object "CASE_MANAGEMENT".
DBCC results for 'CLAIM_X_PROPERTYLOSS'.
There are 0 rows in 0 pages for object "CLAIM_X_PROPERTYLOSS".
DBCC results for 'WC_SC_SUPP'.
There are 0 rows in 0 pages for object "WC_SC_SUPP".
DBCC results for 'INVDETAIL_X_EOB'.
There are 0 rows in 0 pages for object "INVDETAIL_X_EOB".
DBCC results for 'GRID_SYS_PARMS'.
There are 0 rows in 0 pages for object "GRID_SYS_PARMS".
DBCC results for 'VBS_SCRIPTS'.
There are 0 rows in 0 pages for object "VBS_SCRIPTS".
DBCC results for 'TEMP_FH'.
There are 2269 rows in 4 pages for object "TEMP_FH".
DBCC results for 'PAT_X_MAT_OUTCM_PER_PSO'.
There are 0 rows in 0 pages for object "PAT_X_MAT_OUTCM_PER_PSO".
DBCC results for 'WC_SD_SUPP'.
There are 0 rows in 0 pages for object "WC_SD_SUPP".
DBCC results for 'INVOICE'.
There are 0 rows in 0 pages for object "INVOICE".
DBCC results for 'CM_X_HIST_SUPP'.
There are 0 rows in 0 pages for object "CM_X_HIST_SUPP".
DBCC results for 'PHYSICIAN'.
There are 0 rows in 0 pages for object "PHYSICIAN".
DBCC results for 'CM_X_CMGR_HIST'.
There are 0 rows in 0 pages for object "CM_X_CMGR_HIST".
DBCC results for 'POLICY_CODE_MAPPING'.
There are 0 rows in 0 pages for object "POLICY_CODE_MAPPING".
DBCC results for 'CLAIM_X_PROPERTYINVOLVED'.
There are 0 rows in 0 pages for object "CLAIM_X_PROPERTYINVOLVED".
DBCC results for 'WC_STATE_SUPP'.
There are 5 rows in 1 pages for object "WC_STATE_SUPP".
DBCC results for 'INVOICE_DETAIL'.
There are 0 rows in 0 pages for object "INVOICE_DETAIL".
DBCC results for 'CLAIM_X_PROPERTYLOSS_SUPP'.
There are 0 rows in 0 pages for object "CLAIM_X_PROPERTYLOSS_SUPP".
DBCC results for 'WC_TN_SUPP'.
There are 0 rows in 0 pages for object "WC_TN_SUPP".
DBCC results for 'JURIS_FORMS'.
There are 62 rows in 1 pages for object "JURIS_FORMS".
DBCC results for 'CM_X_CMTP_SUPP'.
There are 0 rows in 0 pages for object "CM_X_CMTP_SUPP".
DBCC results for 'PHYS_SUPP'.
There are 0 rows in 0 pages for object "PHYS_SUPP".
DBCC results for 'PAT_X_MAT_OUTCM_NEO_PSO'.
There are 0 rows in 0 pages for object "PAT_X_MAT_OUTCM_NEO_PSO".
DBCC results for 'CASE_MGR_NOTES'.
There are 0 rows in 0 pages for object "CASE_MGR_NOTES".
DBCC results for 'PI_CONFIG_MENU'.
There are 14 rows in 1 pages for object "PI_CONFIG_MENU".
DBCC results for 'WC_TX_SUPP'.
There are 0 rows in 0 pages for object "WC_TX_SUPP".
DBCC results for 'JURIS_FORMS_HIST'.
There are 0 rows in 0 pages for object "JURIS_FORMS_HIST".
DBCC results for 'POLICY_SRCH_CONFIG'.
There are 0 rows in 0 pages for object "POLICY_SRCH_CONFIG".
DBCC results for 'WC_UT_SUPP'.
There are 0 rows in 0 pages for object "WC_UT_SUPP".
DBCC results for 'LITIGATION_SUPP'.
There are 0 rows in 0 pages for object "LITIGATION_SUPP".
DBCC results for 'CM_X_CMMS_SUPP'.
There are 0 rows in 0 pages for object "CM_X_CMMS_SUPP".
DBCC results for 'PHYS_SUB_SPECIALTY'.
There are 0 rows in 0 pages for object "PHYS_SUB_SPECIALTY".
DBCC results for 'CM_X_TREATMENT_PLN'.
There are 0 rows in 0 pages for object "CM_X_TREATMENT_PLN".
DBCC results for 'WC_POLICY_EMPLOYEE'.
There are 1 rows in 1 pages for object "WC_POLICY_EMPLOYEE".
DBCC results for 'SALVAGE'.
There are 0 rows in 0 pages for object "SALVAGE".
DBCC results for 'WC_VA_SUPP'.
There are 0 rows in 0 pages for object "WC_VA_SUPP".
DBCC results for 'MAIN_SCHEDULE'.
There are 1 rows in 1 pages for object "MAIN_SCHEDULE".
DBCC results for 'PAT_X_MAT_INJ_PSO'.
There are 0 rows in 0 pages for object "PAT_X_MAT_INJ_PSO".
DBCC results for 'WC_VT_SUPP'.
There are 0 rows in 0 pages for object "WC_VT_SUPP".
DBCC results for 'MERGE_CAT'.
There are 17 rows in 2 pages for object "MERGE_CAT".
DBCC results for 'CM_X_ACOM_SUPP'.
There are 0 rows in 0 pages for object "CM_X_ACOM_SUPP".
DBCC results for 'PHYS_PRIVS'.
There are 0 rows in 0 pages for object "PHYS_PRIVS".
DBCC results for 'CM_X_MEDMGTSAVINGS'.
There are 0 rows in 0 pages for object "CM_X_MEDMGTSAVINGS".
DBCC results for 'WC_WA_SUPP'.
There are 0 rows in 0 pages for object "WC_WA_SUPP".
DBCC results for 'MERGE_DICTIONARY'.
There are 4465 rows in 56 pages for object "MERGE_DICTIONARY".
DBCC results for 'WC_WI_SUPP'.
There are 0 rows in 0 pages for object "WC_WI_SUPP".
DBCC results for 'PAYEE_CHECK_DETAIL'.
There are 0 rows in 0 pages for object "PAYEE_CHECK_DETAIL".
DBCC results for 'MERGE_FORM'.
There are 17 rows in 1 pages for object "MERGE_FORM".
DBCC results for 'CM_X_CMVR_SUPP'.
There are 0 rows in 0 pages for object "CM_X_CMVR_SUPP".
DBCC results for 'PHYS_CERTS'.
There are 0 rows in 0 pages for object "PHYS_CERTS".
DBCC results for 'PAT_X_MAT_INJ_PER_PSO'.
There are 0 rows in 0 pages for object "PAT_X_MAT_INJ_PER_PSO".
DBCC results for 'CM_X_VOCREHAB'.
There are 0 rows in 0 pages for object "CM_X_VOCREHAB".
DBCC results for 'SALVAGEHISTORY'.
There are 0 rows in 0 pages for object "SALVAGEHISTORY".
DBCC results for 'WC_WV_SUPP'.
There are 0 rows in 0 pages for object "WC_WV_SUPP".
DBCC results for 'MERGE_FORM_DEF'.
There are 190 rows in 6 pages for object "MERGE_FORM_DEF".
DBCC results for 'SCHEDULED_ACTIVITY'.
There are 0 rows in 0 pages for object "SCHEDULED_ACTIVITY".
DBCC results for 'WC_WY_SUPP'.
There are 0 rows in 0 pages for object "WC_WY_SUPP".
DBCC results for 'HOLD_CHECK_DETAIL'.
There are 0 rows in 0 pages for object "HOLD_CHECK_DETAIL".
DBCC results for 'MERGE_FORM_PERM'.
There are 17 rows in 3 pages for object "MERGE_FORM_PERM".
DBCC results for 'WCP_BEN_TYPE_LKUP'.
There are 4 rows in 1 pages for object "WCP_BEN_TYPE_LKUP".
DBCC results for 'CLAIM_PRG_NOTE'.
There are 191270 rows in 18592 pages for object "CLAIM_PRG_NOTE".
DBCC results for 'PHYS_EDUCATION'.
There are 0 rows in 0 pages for object "PHYS_EDUCATION".
DBCC results for 'WPA_AUTO_ACT'.
There are 1 rows in 1 pages for object "WPA_AUTO_ACT".
DBCC results for 'MODIFIER_VALUES'.
There are 0 rows in 0 pages for object "MODIFIER_VALUES".
DBCC results for 'PAT_X_MAT_INJ_NEO_PSO'.
There are 0 rows in 0 pages for object "PAT_X_MAT_INJ_NEO_PSO".
DBCC results for 'CM_X_ACCOMMODATION'.
There are 0 rows in 0 pages for object "CM_X_ACCOMMODATION".
DBCC results for 'ENTITY_X_MMSEA'.
There are 1 rows in 1 pages for object "ENTITY_X_MMSEA".
DBCC results for 'WPA_AUTO_FILTER'.
There are 1 rows in 1 pages for object "WPA_AUTO_FILTER".
DBCC results for 'FREEZE_BAT_DETAIL'.
There are 0 rows in 0 pages for object "FREEZE_BAT_DETAIL".
DBCC results for 'OBJSTORAGE'.
There are 0 rows in 0 pages for object "OBJSTORAGE".
DBCC results for 'NOTE_X_SYS_CNF'.
There are 0 rows in 0 pages for object "NOTE_X_SYS_CNF".
DBCC results for 'PHYS_PREV_HOSP'.
There are 0 rows in 0 pages for object "PHYS_PREV_HOSP".
DBCC results for 'CATASTROPHE'.
There are 0 rows in 0 pages for object "CATASTROPHE".
DBCC results for 'TEMP_FINHIST_CLAIMID_RUNTIME'.
There are 0 rows in 0 pages for object "TEMP_FINHIST_CLAIMID_RUNTIME".
DBCC results for 'SALVAGE_SUPP'.
There are 0 rows in 0 pages for object "SALVAGE_SUPP".

checkdb results 3

DBCC results for 'WPA_AUTO_SET'.
There are 1 rows in 1 pages for object "WPA_AUTO_SET".
DBCC results for 'ORG_HIERARCHY'.
There are 165 rows in 1 pages for object "ORG_HIERARCHY".
DBCC results for 'CATASTROPHE_STATES'.
There are 0 rows in 0 pages for object "CATASTROPHE_STATES".
DBCC results for 'FIN_HIST_ERR_LOG'.
There are 0 rows in 0 pages for object "FIN_HIST_ERR_LOG".
DBCC results for 'CLAIMANT_MMSEA'.
There are 1913 rows in 45 pages for object "CLAIMANT_MMSEA".
DBCC results for 'WPA_AUTO_USER'.
There are 0 rows in 1 pages for object "WPA_AUTO_USER".
DBCC results for 'PAYEE_CHECK_ENTITY'.
There are 0 rows in 0 pages for object "PAYEE_CHECK_ENTITY".
DBCC results for 'FROI_OPTIONS'.
There are 1 rows in 1 pages for object "FROI_OPTIONS".
DBCC results for 'PAY_NOTIFY_USERS'.
There are 0 rows in 0 pages for object "PAY_NOTIFY_USERS".
DBCC results for 'MED_STAFF'.
There are 0 rows in 0 pages for object "MED_STAFF".
DBCC results for 'PAT_X_NN_OUTCM_TYP_PSO'.
There are 0 rows in 0 pages for object "PAT_X_NN_OUTCM_TYP_PSO".
DBCC results for 'CATASTROPHE_LOSS_CAUSES'.
There are 0 rows in 0 pages for object "CATASTROPHE_LOSS_CAUSES".
DBCC results for 'TEMP_DOCUMENT_STORAGE'.
There are 0 rows in 0 pages for object "TEMP_DOCUMENT_STORAGE".
DBCC results for 'WPA_DIARY_ACT'.
There are 26640 rows in 171 pages for object "WPA_DIARY_ACT".
DBCC results for 'PAYEE_CHECK_SDN'.
There are 0 rows in 0 pages for object "PAYEE_CHECK_SDN".
DBCC results for 'PERSON_INVOLVED'.
There are 3518 rows in 228 pages for object "PERSON_INVOLVED".
DBCC results for 'CATASTROPHE_SUPP'.
There are 0 rows in 0 pages for object "CATASTROPHE_SUPP".
DBCC results for 'CLAIMANT_X_MMS_CLT'.
There are 0 rows in 0 pages for object "CLAIMANT_X_MMS_CLT".
DBCC results for 'CLAIM_X_LIABILITYLOSS'.
There are 0 rows in 0 pages for object "CLAIM_X_LIABILITYLOSS".
DBCC results for 'WPA_DIARY_ENTRY'.
There are 62747 rows in 2076 pages for object "WPA_DIARY_ENTRY".
DBCC results for 'PAYEE_CHK_SETTING'.
There are 0 rows in 0 pages for object "PAYEE_CHK_SETTING".
DBCC results for 'SYS_CLM_TYPE_RES'.
There are 0 rows in 0 pages for object "SYS_CLM_TYPE_RES".
DBCC results for 'PHARMACY_MOD'.
There are 0 rows in 0 pages for object "PHARMACY_MOD".
DBCC results for 'POLICY_X_BILL_ENH'.
There are 0 rows in 0 pages for object "POLICY_X_BILL_ENH".
DBCC results for 'MED_STAFF_SUPP'.
There are 0 rows in 0 pages for object "MED_STAFF_SUPP".
DBCC results for 'WRCMP_CPT'.
There are 0 rows in 0 pages for object "WRCMP_CPT".
DBCC results for 'EDI_HISTORY'.
There are 0 rows in 0 pages for object "EDI_HISTORY".
DBCC results for 'PI_SUPP'.
There are 0 rows in 0 pages for object "PI_SUPP".
DBCC results for 'EVENT_X_INTERVENT'.
There are 1 rows in 1 pages for object "EVENT_X_INTERVENT".
DBCC results for 'EVENT_X_MED_INV_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_MED_INV_PSO".
DBCC results for 'ENT_INSTRUCTIONS'.
There are 0 rows in 0 pages for object "ENT_INSTRUCTIONS".
DBCC results for 'PI_X_BODY_PART'.
There are 41 rows in 1 pages for object "PI_X_BODY_PART".
DBCC results for 'BILL_X_ACCOUNT'.
There are 0 rows in 0 pages for object "BILL_X_ACCOUNT".
DBCC results for 'STAFF_PRIVS'.
There are 0 rows in 0 pages for object "STAFF_PRIVS".
DBCC results for 'CATASTROPHE_COUNTIES'.
There are 0 rows in 0 pages for object "CATASTROPHE_COUNTIES".
DBCC results for 'CT_MMS_X_DIAGNOSIS'.
There are 10 rows in 1 pages for object "CT_MMS_X_DIAGNOSIS".
DBCC results for 'PI_X_DEP_SUPP'.
There are 0 rows in 0 pages for object "PI_X_DEP_SUPP".
DBCC results for 'EVENT_X_INT_CODES'.
There are 0 rows in 0 pages for object "EVENT_X_INT_CODES".
DBCC results for 'CLAIM_X_LIABILITYLOSS_SUPP'.
There are 0 rows in 0 pages for object "CLAIM_X_LIABILITYLOSS_SUPP".
DBCC results for 'CLIENT_LIMITS'.
There are 0 rows in 0 pages for object "CLIENT_LIMITS".
DBCC results for 'PI_X_DEPENDENT'.
There are 0 rows in 0 pages for object "PI_X_DEPENDENT".
DBCC results for 'BILL_X_INSTLMNT'.
There are 0 rows in 0 pages for object "BILL_X_INSTLMNT".
DBCC results for 'EVENT_X_INT_SUPP'.
There are 0 rows in 0 pages for object "EVENT_X_INT_SUPP".
DBCC results for 'STAFF_CERTS'.
There are 0 rows in 0 pages for object "STAFF_CERTS".
DBCC results for 'PAT_X_PRESS_ULC_PSO'.
There are 0 rows in 0 pages for object "PAT_X_PRESS_ULC_PSO".
DBCC results for 'FINANCIAL_HIST'.
There are 239070 rows in 2544 pages for object "FINANCIAL_HIST".
DBCC results for 'CLMT_MMSEA_TPOC'.
There are 56 rows in 1 pages for object "CLMT_MMSEA_TPOC".
DBCC results for 'PI_X_DIAGNOSIS'.
There are 41 rows in 1 pages for object "PI_X_DIAGNOSIS".
DBCC results for 'WC_NL_SUPP'.
There are 0 rows in 0 pages for object "WC_NL_SUPP".
DBCC results for 'TEMP_1099_WT'.
There are 2764 rows in 24 pages for object "TEMP_1099_WT".
DBCC results for 'LOB_SUP_APPROVAL'.
There are 0 rows in 0 pages for object "LOB_SUP_APPROVAL".
DBCC results for 'PROPERTY_UNIT_SUPP'.
There are 0 rows in 0 pages for object "PROPERTY_UNIT_SUPP".
DBCC results for 'PI_X_HOSPITAL'.
There are 46 rows in 1 pages for object "PI_X_HOSPITAL".
DBCC results for 'BILL_X_BILL_ITEM'.
There are 0 rows in 0 pages for object "BILL_X_BILL_ITEM".
DBCC results for 'POLICY_X_INSURER'.
There are 12 rows in 1 pages for object "POLICY_X_INSURER".
DBCC results for 'EVENT_QM'.
There are 4941 rows in 52 pages for object "EVENT_QM".
DBCC results for 'TPA_POLICY_PARMS'.
There are 0 rows in 0 pages for object "TPA_POLICY_PARMS".
DBCC results for 'PI_X_ILLNESS'.
There are 0 rows in 0 pages for object "PI_X_ILLNESS".
DBCC results for 'EVENT_X_CONTRI_FAC_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_CONTRI_FAC_PSO".
DBCC results for 'XML_IMPORT_HISTORY'.
There are 0 rows in 0 pages for object "XML_IMPORT_HISTORY".
DBCC results for 'JURIS_OPTIONS'.
There are 0 rows in 0 pages for object "JURIS_OPTIONS".
DBCC results for 'PI_X_INJURY'.
There are 41 rows in 1 pages for object "PI_X_INJURY".
DBCC results for 'BILL_X_PREM_ITEM'.
There are 0 rows in 0 pages for object "BILL_X_PREM_ITEM".
DBCC results for 'COL_X_FUNDS'.
There are 0 rows in 0 pages for object "COL_X_FUNDS".
DBCC results for 'PI_X_PHYSICIAN'.
There are 41 rows in 1 pages for object "PI_X_PHYSICIAN".
DBCC results for 'LEAVE_PLAN'.
There are 0 rows in 0 pages for object "LEAVE_PLAN".
DBCC results for 'WC_QC_SUPP'.
There are 0 rows in 0 pages for object "WC_QC_SUPP".
DBCC results for 'PI_X_PROC_SUPP'.
There are 0 rows in 0 pages for object "PI_X_PROC_SUPP".
DBCC results for 'BILL_X_RECEIPT'.
There are 0 rows in 0 pages for object "BILL_X_RECEIPT".
DBCC results for 'EVENT_X_CONTRI_FAC_NM_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_CONTRI_FAC_NM_PSO".
DBCC results for 'POLICY_X_UNIT'.
There are 0 rows in 0 pages for object "POLICY_X_UNIT".
DBCC results for 'TAX_MAPPING'.
There are 0 rows in 0 pages for object "TAX_MAPPING".
DBCC results for 'PI_X_PROCEDURE'.
There are 0 rows in 0 pages for object "PI_X_PROCEDURE".
DBCC results for 'LP_X_UPD_CODES'.
There are 0 rows in 0 pages for object "LP_X_UPD_CODES".
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object "dtproperties".
DBCC results for 'SYS_POL_RANGE'.
There are 0 rows in 0 pages for object "SYS_POL_RANGE".
DBCC results for 'PI_X_RESTRCT_SUPP'.
There are 0 rows in 0 pages for object "PI_X_RESTRCT_SUPP".
DBCC results for 'BILL_X_ADJSTMNT'.
There are 0 rows in 0 pages for object "BILL_X_ADJSTMNT".
DBCC results for 'LP_X_ENTITY'.
There are 0 rows in 0 pages for object "LP_X_ENTITY".
DBCC results for 'SYS_SETTINGS'.
There are 0 rows in 0 pages for object "SYS_SETTINGS".
DBCC results for 'POSTAL_CODES'.
There are 2681 rows in 20 pages for object "POSTAL_CODES".
DBCC results for 'PI_X_RESTRICT'.
There are 0 rows in 0 pages for object "PI_X_RESTRICT".
DBCC results for 'CLAIM_LV_X_HIST'.
There are 0 rows in 0 pages for object "CLAIM_LV_X_HIST".
DBCC results for 'EVENT_X_MED_DEV_IDENT_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_MED_DEV_IDENT_PSO".
DBCC results for 'PI_X_TREATMENT'.
There are 48 rows in 1 pages for object "PI_X_TREATMENT".
DBCC results for 'BILL_X_DSBRSMNT'.
There are 0 rows in 0 pages for object "BILL_X_DSBRSMNT".
DBCC results for 'FUNDS_DORMANCY'.
There are 0 rows in 0 pages for object "FUNDS_DORMANCY".
DBCC results for 'PI_X_VIOLATION'.
There are 0 rows in 0 pages for object "PI_X_VIOLATION".
DBCC results for 'CLAIM_LEAVE'.
There are 0 rows in 0 pages for object "CLAIM_LEAVE".
DBCC results for 'PI_X_WORK_LOSS'.
There are 0 rows in 0 pages for object "PI_X_WORK_LOSS".
DBCC results for 'BILL_X_BATCH'.
There are 0 rows in 0 pages for object "BILL_X_BATCH".
DBCC results for 'EVENT_X_MED_DEVICE_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_MED_DEVICE_PSO".
DBCC results for 'PI_X_WRKLOSS_SUPP'.
There are 0 rows in 0 pages for object "PI_X_WRKLOSS_SUPP".
DBCC results for 'CLAIM_LV_X_DETAIL'.
There are 0 rows in 0 pages for object "CLAIM_LV_X_DETAIL".
DBCC results for 'POLICY'.
There are 12 rows in 1 pages for object "POLICY".
DBCC results for 'BILL_X_INVOICE'.
There are 0 rows in 0 pages for object "BILL_X_INVOICE".
DBCC results for 'WC_VI_SUPP'.
There are 0 rows in 0 pages for object "WC_VI_SUPP".
DBCC results for 'ECU_HISTORY'.
There are 497 rows in 7 pages for object "ECU_HISTORY".
DBCC results for 'POLICY_SUPP'.
There are 0 rows in 0 pages for object "POLICY_SUPP".
DBCC results for 'RISK_MANAGEM'.
There are 57 rows in 5 pages for object "RISK_MANAGEM".
DBCC results for 'LEAVE_PLAN_SUPP'.
There are 0 rows in 0 pages for object "LEAVE_PLAN_SUPP".
DBCC results for 'ECU_HISTORY_DETAIL'.
There are 1989 rows in 12 pages for object "ECU_HISTORY_DETAIL".
DBCC results for 'CLAIM_X_PROPERTY'.
There are 0 rows in 0 pages for object "CLAIM_X_PROPERTY".
DBCC results for 'POLICY_X_CVG_TYPE'.
There are 20 rows in 1 pages for object "POLICY_X_CVG_TYPE".
DBCC results for 'BILL_X_INVOICE_DET'.
There are 0 rows in 0 pages for object "BILL_X_INVOICE_DET".
DBCC results for 'CLAIM_X_OVERRIDE'.
There are 0 rows in 0 pages for object "CLAIM_X_OVERRIDE".
DBCC results for 'POLICY_X_INSURED'.
There are 15 rows in 1 pages for object "POLICY_X_INSURED".
DBCC results for 'CLAIM_LV_SUPP'.
There are 0 rows in 0 pages for object "CLAIM_LV_SUPP".
DBCC results for 'POLICY_X_MCO'.
There are 0 rows in 0 pages for object "POLICY_X_MCO".
DBCC results for 'BILL_X_NOTICE'.
There are 0 rows in 0 pages for object "BILL_X_NOTICE".
DBCC results for 'EVENT_X_MEDICATION_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_MEDICATION_PSO".
DBCC results for 'RM_LSS_CODE_EXP'.
There are 0 rows in 0 pages for object "RM_LSS_CODE_EXP".
DBCC results for 'PROJ_TRACK'.
There are 0 rows in 0 pages for object "PROJ_TRACK".
DBCC results for 'RM_LSS_ADMIN_EXP'.
There are 1873 rows in 18 pages for object "RM_LSS_ADMIN_EXP".
DBCC results for 'PROP_MGT'.
There are 0 rows in 0 pages for object "PROP_MGT".
DBCC results for 'BILL_X_NOTICE_DET'.
There are 0 rows in 0 pages for object "BILL_X_NOTICE_DET".
DBCC results for 'ACCOUNT'.
There are 1 rows in 1 pages for object "ACCOUNT".
DBCC results for 'RM_LSS_CLAIM_EXP'.
There are 0 rows in 0 pages for object "RM_LSS_CLAIM_EXP".
DBCC results for 'ENTITY_X_WITHHOLDING'.
There are 0 rows in 0 pages for object "ENTITY_X_WITHHOLDING".
DBCC results for 'FUNDS_TRANS_SPLIT_SUPP'.
There are 0 rows in 0 pages for object "FUNDS_TRANS_SPLIT_SUPP".
DBCC results for 'ACCOUNT_SUPP'.
There are 0 rows in 0 pages for object "ACCOUNT_SUPP".
DBCC results for 'RM_LSS_PAYMNT_EXP'.
There are 76 rows in 6 pages for object "RM_LSS_PAYMNT_EXP".
DBCC results for 'PRT_CHECK_LIMITS'.
There are 1 rows in 1 pages for object "PRT_CHECK_LIMITS".
DBCC results for 'SYS_BILL_OPTIONS'.
There are 0 rows in 0 pages for object "SYS_BILL_OPTIONS".
DBCC results for 'ADJUST_DATED_TEXT'.
There are 0 rows in 0 pages for object "ADJUST_DATED_TEXT".
DBCC results for 'RM_LSS_PAYEE_EXP'.
There are 2060 rows in 22 pages for object "RM_LSS_PAYEE_EXP".
DBCC results for 'QE_DEF'.
There are 29 rows in 1 pages for object "QE_DEF".
DBCC results for 'SYS_BILL_BLNG_RULE'.
There are 0 rows in 0 pages for object "SYS_BILL_BLNG_RULE".
DBCC results for 'POLICY_X_INS_REINS'.
There are 0 rows in 0 pages for object "POLICY_X_INS_REINS".
DBCC results for 'BANK_ACC_RECON'.
There are 0 rows in 0 pages for object "BANK_ACC_RECON".
DBCC results for 'EVENT_X_LINK_EVT_INFO_PSO'.
There are 0 rows in 0 pages for object "EVENT_X_LINK_EVT_INFO_PSO".
DBCC results for 'RM_LSS_CHECK_EXP'.
There are 0 rows in 0 pages for object "RM_LSS_CHECK_EXP".
DBCC results for 'QE_DICTIONARY'.
There are 256 rows in 2 pages for object "QE_DICTIONARY".
DBCC results for 'BANK_ACC_SUB'.
There are 0 rows in 0 pages for object "BANK_ACC_SUB".
DBCC results for 'DX_REQUEST'.
There are 0 rows in 0 pages for object "DX_REQUEST".
DBCC results for 'QE_PERMISSIONS'.
There are 10 rows in 1 pages for object "QE_PERMISSIONS".
DBCC results for 'SYS_BILL_PAY_PLAN'.
There are 0 rows in 0 pages for object "SYS_BILL_PAY_PLAN".
DBCC results for 'BOND_ABS'.
There are 0 rows in 0 pages for object "BOND_ABS".
DBCC results for 'DX_REQUEST_EVENT'.
There are 0 rows in 0 pages for object "DX_REQUEST_EVENT".
DBCC results for 'QE_VIEWS'.
There are 2 rows in 1 pages for object "QE_VIEWS".
DBCC results for 'BRS_FEESCHD'.
There are 0 rows in 0 pages for object "BRS_FEESCHD".
DBCC results for 'DX_EVENTEXCEPTIONS'.
There are 0 rows in 0 pages for object "DX_EVENTEXCEPTIONS".
DBCC results for 'WRCMP_PERDIEM_OPT'.
There are 0 rows in 0 pages for object "WRCMP_PERDIEM_OPT".
DBCC results for 'QENTRY_PERM'.
There are 0 rows in 0 pages for object "QENTRY_PERM".
DBCC results for 'CVG_ENH_SUPP'.
There are 0 rows in 0 pages for object "CVG_ENH_SUPP".
DBCC results for 'BRS_MOD_VALUES'.
There are 0 rows in 0 pages for object "BRS_MOD_VALUES".
DBCC results for 'SYS_EVENT_TYPE_PSO'.
There are 0 rows in 0 pages for object "SYS_EVENT_TYPE_PSO".
DBCC results for 'DX_EVENTHISTORY'.
There are 0 rows in 0 pages for object "DX_EVENTHISTORY".
DBCC results for 'QENTRY_VIEWDEFS'.
There are 0 rows in 0 pages for object "QENTRY_VIEWDEFS".
DBCC results for 'EXP_ENH_SUPP'.
There are 0 rows in 0 pages for object "EXP_ENH_SUPP".
DBCC results for 'BRS_SYS_PARAMS'.
There are 1 rows in 1 pages for object "BRS_SYS_PARAMS".
DBCC results for 'DX_SUPPORT'.
There are 0 rows in 0 pages for object "DX_SUPPORT".
DBCC results for 'WC_MAX_RATE_CALC'.
There are 0 rows in 0 pages for object "WC_MAX_RATE_CALC".
DBCC results for 'QENTRY_VIEWS'.
There are 0 rows in 0 pages for object "QENTRY_VIEWS".
DBCC results for 'SYS_ERLY_PAY_DSCNT'.
There are 0 rows in 0 pages for object "SYS_ERLY_PAY_DSCNT".
DBCC results for 'CERTIFICATE'.
There are 1 rows in 1 pages for object "CERTIFICATE".
DBCC results for 'REQ_DEF'.
There are 2582 rows in 6 pages for object "REQ_DEF".
DBCC results for 'CHECK_BATCHES'.
There are 6929 rows in 46 pages for object "CHECK_BATCHES".
CHECKDB found 0 allocation errors and 2 consistency errors in database 'Production'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Seeing the DBCC output, I think you need to Run DBCC UPDATEUSAGE. I assume that this DB was migrated from SQL 2000. In earlier versions of SQL Server, the values for the per-table and per-index row count and page counts can become incorrect. Under certain circumstances, one or more of these values might even become negative. In SQL Server 2005, these values are always maintained correctly. Therefore, databases that are created on SQL Server 2005 should never contain incorrect counts; however, databases that are upgraded to SQL Server 2005 might. This is not a corruption of any data stored in the database. DBCC CHECKDB has been enhanced to detect when any one of these counts becomes negative. When negative counts are detected, the DBCC CHECKDB output contains a warning and a recommendation to run DBCC UPDATEUSAGE to correct the issue. Although it may appear as if upgrading the database to SQL Server 2005 has caused this issue, the incorrect counts were present before the upgrade procedure.

So your issue will get fixed by running UPDATEUSAGE and you wont need to repair.

https://msdn.microsoft.com/en-us/library/ms188414.aspx ----> Syntax

Thank you very much!

That is correct, it was migrated from SQL2000. It is currently SQL 2008 R2. I am going on vacation for a few days, so I will run DBCC UPDATEUSAGE when I return next week.

Thanks again.

G

OK let me know the update once you run.