Apr 18, 2008
Here's the dbcc of a corrupt database. I had to eventually run it with data loss and piece together the deleted records from an old backup and drop them in a clean db.
I apologize in advance if there's an faq out there already that explains my answer in detail...
The question I put to you is: 1) How do I we prevent our customers from having this occur again? I can guess the list would include: IO checks, battery backup, SQL 2000 sp4 applied (only sp3 is applied btw), SQL log checks, event log checks. 2) Our custom maint plan includes a dbcc reindex every night and some tables have over 200000 records and a mess of constraints. Is this a potential problem?
Thanks.
dbcc checkdb
-------------
DBCC results for 'mycustdb'.
DBCC results for 'sysobjects'.
There are 3221 rows in 60 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 2694 rows in 223 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 16338 rows in 410 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 2176 rows in 609 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 49 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 41985 rows in 214 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 547 rows in 4 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysCompany'.
There are 8 rows in 1 pages for object 'sysCompany'.
DBCC results for 'a_admResCensus'.
There are 0 rows in 0 pages for object 'a_admResCensus'.
DBCC results for 'sysTask'.
There are 0 rows in 0 pages for object 'sysTask'.
DBCC results for 'glJournalEntryTemplate'.
There are 7 rows in 1 pages for object 'glJournalEntryTemplate'.
DBCC results for 'admResUdAssessAns'.
There are 0 rows in 0 pages for object 'admResUdAssessAns'.
DBCC results for 'arTAC'.
There are 0 rows in 0 pages for object 'arTAC'.
DBCC results for 'arRecCharge'.
There are 2578 rows in 21 pages for object 'arRecCharge'.
DBCC results for 'arFormLocator'.
There are 1900 rows in 14 pages for object 'arFormLocator'.
DBCC results for 'rptVitalSigns'.
There are 0 rows in 0 pages for object 'rptVitalSigns'.
DBCC results for 'glMajorDepartment'.
There are 0 rows in 0 pages for object 'glMajorDepartment'.
DBCC results for 'a_arTAC'.
There are 0 rows in 0 pages for object 'a_arTAC'.
DBCC results for 'sysUserDefQuesAns'.
There are 5128 rows in 41 pages for object 'sysUserDefQuesAns'.
DBCC results for 'glTransaction'.
There are 67594 rows in 581 pages for object 'glTransaction'.
DBCC results for 'arOccupancyRate'.
There are 144 rows in 1 pages for object 'arOccupancyRate'.
DBCC results for 'sysErrorScreenLink'.
There are 60 rows in 1 pages for object 'sysErrorScreenLink'.
DBCC results for 'arResCaseMix'.
There are 2634 rows in 21 pages for object 'arResCaseMix'.
DBCC results for 'glTransImportTemp'.
There are 0 rows in 1 pages for object 'glTransImportTemp'.
DBCC results for 'arTAR'.
There are 0 rows in 0 pages for object 'arTAR'.
DBCC results for 'admContactTypeLink'.
There are 3460 rows in 15 pages for object 'admContactTypeLink'.
DBCC results for 'arResRoomAndBoard'.
There are 1839 rows in 16 pages for object 'arResRoomAndBoard'.
DBCC results for 'secAccountLink'.
There are 0 rows in 0 pages for object 'secAccountLink'.
DBCC results for 'glTransToArTransLink'.
There are 216168 rows in 478 pages for object 'glTransToArTransLink'.
DBCC results for 'arChargeHistory'.
There are 634 rows in 4 pages for object 'arChargeHistory'.
DBCC results for 'admContPhone'.
There are 3091 rows in 17 pages for object 'admContPhone'.
DBCC results for 'arRevenueCode'.
There are 18 rows in 1 pages for object 'arRevenueCode'.
DBCC results for 'glGroup'.
There are 1 rows in 1 pages for object 'glGroup'.
DBCC results for 'glUnits'.
There are 0 rows in 0 pages for object 'glUnits'.
DBCC results for 'mdsSectionDefinition'.
There are 1735 rows in 71 pages for object 'mdsSectionDefinition'.
DBCC results for 'sysUserDefQuesType'.
There are 6 rows in 1 pages for object 'sysUserDefQuesType'.
DBCC results for 'glUnitType'.
There are 0 rows in 0 pages for object 'glUnitType'.
DBCC results for 'arChargeUpdTemp'.
There are 0 rows in 0 pages for object 'arChargeUpdTemp'.
DBCC results for 'arChargeBatch'.
There are 2 rows in 1 pages for object 'arChargeBatch'.
DBCC results for 'sysWarning'.
There are 0 rows in 0 pages for object 'sysWarning'.
DBCC results for 'sysCustomReportLayouts'.
There are 3 rows in 1 pages for object 'sysCustomReportLayouts'.
DBCC results for 'arCheckPoint'.
There are 5922 rows in 85 pages for object 'arCheckPoint'.
DBCC results for 'arServiceCategory'.
There are 47 rows in 1 pages for object 'arServiceCategory'.
DBCC results for 'tblClassTemp'.
There are 0 rows in 0 pages for object 'tblClassTemp'.
DBCC results for 'secCompUserLink'.
Server: Msg 8941, Level 16, State 102, Line 1
Table error: Object ID 232387897, index ID 0, page (1:35630). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 100, offset 0x1 is invalid.
Server: Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 232387897, index ID 0, page (1:35630). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x64 overlaps with the prior row.
There are 33 rows in 1 pages for object 'secCompUserLink'.
DBCC results for 'sysRptMenu'.
There are 4 rows in 1 pages for object 'sysRptMenu'.
DBCC results for 'a_admResDiagnosis'.
There are 0 rows in 0 pages for object 'a_admResDiagnosis'.
DBCC results for 'arPaymentHistory'.
There are 0 rows in 1 pages for object 'arPaymentHistory'.
DBCC results for 'secPermissionLevel'.
There are 4 rows in 1 pages for object 'secPermissionLevel'.
DBCC results for 'arPaymentLink'.
There are 0 rows in 0 pages for object 'arPaymentLink'.
DBCC results for 'a_admResident'.
There are 0 rows in 0 pages for object 'a_admResident'.
DBCC results for 'tblECSLinkTemp'.
There are 0 rows in 0 pages for object 'tblECSLinkTemp'.
DBCC results for 'mdsVersion'.
There are 1 rows in 1 pages for object 'mdsVersion'.
DBCC results for 'arResExportDetail'.
There are 0 rows in 0 pages for object 'arResExportDetail'.
DBCC results for 'tblECSRecordTemp'.
There are 0 rows in 0 pages for object 'tblECSRecordTemp'.
DBCC results for 'sysRptToMenuLink'.
There are 9 rows in 1 pages for object 'sysRptToMenuLink'.
DBCC results for 'arResExportHistory'.
There are 0 rows in 0 pages for object 'arResExportHistory'.
DBCC results for 'arStmtDetailPP'.
There are 98372 rows in 887 pages for object 'arStmtDetailPP'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'arStmtDetailPP' (object ID 232387897).
DBCC results for 'a_admResInsurance'.
There are 0 rows in 0 pages for object 'a_admResInsurance'.
DBCC results for 'sysScrnSetting'.
There are 331 rows in 8 pages for object 'sysScrnSetting'.
DBCC results for 'arStmtChargeLink'.
There are 13594 rows in 148 pages for object 'arStmtChargeLink'.
DBCC results for 'arStmtDetailUB92'.
There are 19070 rows in 221 pages for object 'arStmtDetailUB92'.
DBCC results for 'admGender'.
There are 3 rows in 1 pages for object 'admGender'.
DBCC results for 'arStmtHeaderPP'.
There are 15188 rows in 690 pages for object 'arStmtHeaderPP'.
DBCC results for 'sysMasterFormLocator'.
There are 866 rows in 7 pages for object 'sysMasterFormLocator'.
DBCC results for 'rptMdsResCensusTemp'.
There are 82 rows in 2 pages for object 'rptMdsResCensusTemp'.
DBCC results for 'sysScrnSettingDetail'.
There are 3590 rows in 39 pages for object 'sysScrnSettingDetail'.
DBCC results for 'arTransHistory'.
There are 9767 rows in 57 pages for object 'arTransHistory'.
DBCC results for 'arCalculationType'.
There are 24 rows in 1 pages for object 'arCalculationType'.
DBCC results for 'tblglAcct'.
There are 0 rows in 0 pages for object 'tblglAcct'.
DBCC results for 'arRate'.
There are 1304 rows in 11 pages for object 'arRate'.
DBCC results for 'arStmtTransLink'.
There are 152635 rows in 324 pages for object 'arStmtTransLink'.
DBCC results for 'a_admResNotes'.
There are 0 rows in 0 pages for object 'a_admResNotes'.
DBCC results for 'admMaritalStatus'.
There are 6 rows in 1 pages for object 'admMaritalStatus'.
DBCC results for 'tblglBgtAcct'.
There are 0 rows in 0 pages for object 'tblglBgtAcct'.
DBCC results for 'sysSpellDict'.
There are 15438 rows in 94 pages for object 'sysSpellDict'.
DBCC results for 'arSpecRate'.
There are 40 rows in 1 pages for object 'arSpecRate'.
DBCC results for 'arTFIntsTemp'.
There are 0 rows in 0 pages for object 'arTFIntsTemp'.
DBCC results for 'sysInsuranceType'.
There are 81 rows in 1 pages for object 'sysInsuranceType'.
DBCC results for 'tblglDept'.
There are 0 rows in 0 pages for object 'tblglDept'.
DBCC results for 'tblSpellDict'.
There are 15357 rows in 91 pages for object 'tblSpellDict'.
DBCC results for 'arToGLTemp'.
There are 0 rows in 1 pages for object 'arToGLTemp'.
DBCC results for 'sysUdQuest'.
There are 0 rows in 0 pages for object 'sysUdQuest'.
DBCC results for 'tblglFNPeriod'.
There are 0 rows in 0 pages for object 'tblglFNPeriod'.
DBCC results for 'admResRoom'.
There are 1820 rows in 11 pages for object 'admResRoom'.
DBCC results for 'admResDiagnosis'.
There are 6480 rows in 63 pages for object 'admResDiagnosis'.
DBCC results for 'tblglTrans'.
There are 0 rows in 0 pages for object 'tblglTrans'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'arStatement'.
There are 17784 rows in 102 pages for object 'arStatement'.
DBCC results for 'sysMasterFormVersion'.
There are 51 rows in 1 pages for object 'sysMasterFormVersion'.
DBCC results for 'admComments'.
There are 0 rows in 0 pages for object 'admComments'.
DBCC results for 'tblglUnit'.
There are 0 rows in 0 pages for object 'tblglUnit'.
DBCC results for 'arPercentage'.
There are 2 rows in 1 pages for object 'arPercentage'.
DBCC results for 'arTransLink'.
There are 103583 rows in 372 pages for object 'arTransLink'.
DBCC results for 'a_admResRoom'.
There are 0 rows in 0 pages for object 'a_admResRoom'.
DBCC results for 'mdsAssessment'.
There are 9 rows in 2 pages for object 'mdsAssessment'.
DBCC results for 'arTransLinkTemp'.
There are 0 rows in 1 pages for object 'arTransLinkTemp'.
DBCC results for 'mdsAssessSummary'.
There are 3933 rows in 87 pages for object 'mdsAssessSummary'.
DBCC results for 'sysReportCategories'.
There are 53 rows in 1 pages for object 'sysReportCategories'.
DBCC results for 'a_admResSchdCodePassTime'.
There are 0 rows in 0 pages for object 'a_admResSchdCodePassTime'.
DBCC results for 'admPhyOrderPassTime'.
There are 51 rows in 1 pages for object 'admPhyOrderPassTime'.
DBCC results for 'admTaskData'.
There are 0 rows in 0 pages for object 'admTaskData'.
DBCC results for 'arTransOrigin'.
There are 12 rows in 1 pages for object 'arTransOrigin'.
DBCC results for 'ap1099Form'.
There are 89 rows in 5 pages for object 'ap1099Form'.
DBCC results for 'sysDiagnosis'.
There are 16464 rows in 165 pages for object 'sysDiagnosis'.
DBCC results for 'mdsRugsFormLocators'.
There are 9 rows in 1 pages for object 'mdsRugsFormLocators'.
DBCC results for 'admPhyOrdersHistory'.
There are 20165 rows in 300 pages for object 'admPhyOrdersHistory'.
DBCC results for 'rptTempTable'.
There are 4 rows in 1 pages for object 'rptTempTable'.
DBCC results for 'tblRandomNames'.
There are 0 rows in 0 pages for object 'tblRandomNames'.
DBCC results for 'mdsRugsMedicaid'.
There are 518 rows in 4 pages for object 'mdsRugsMedicaid'.
DBCC results for 'arTransType'.
There are 10 rows in 1 pages for object 'arTransType'.
DBCC results for 'mdsRugsMedicare'.
There are 582 rows in 5 pages for object 'mdsRugsMedicare'.
DBCC results for 'arECSError'.
There are 13 rows in 1 pages for object 'arECSError'.
DBCC results for 'apBatch'.
There are 1771 rows in 15 pages for object 'apBatch'.
DBCC results for 'arOrderTypeServiceLink'.
There are 0 rows in 0 pages for object 'arOrderTypeServiceLink'.
DBCC results for 'a_arBatch'.
There are 0 rows in 0 pages for object 'a_arBatch'.
DBCC results for 'arECSPayment'.
There are 0 rows in 0 pages for object 'arECSPayment'.
DBCC results for 'arTreatment'.
There are 0 rows in 0 pages for object 'arTreatment'.
DBCC results for 'apCheck'.
There are 8822 rows in 83 pages for object 'apCheck'.
DBCC results for 'arECSPmtAdjustment'.
There are 0 rows in 0 pages for object 'arECSPmtAdjustment'.
DBCC results for 'arStmtDetailCMS1500'.
There are 0 rows in 0 pages for object 'arStmtDetailCMS1500'.
DBCC results for 'admProfLink2'.
There are 1890 rows in 8 pages for object 'admProfLink2'.
DBCC results for 'a_arTreatment'.
There are 0 rows in 0 pages for object 'a_arTreatment'.
DBCC results for 'apCheckHistory'.
There are 8800 rows in 44 pages for object 'apCheckHistory'.
DBCC results for 'arStmtHeaderCMS1500'.
There are 0 rows in 0 pages for object 'arStmtHeaderCMS1500'.
DBCC results for 'sysCoPhone'.
There are 13 rows in 1 pages for object 'sysCoPhone'.
DBCC results for 'repUserRptCatLink'.
There are 63 rows in 1 pages for object 'repUserRptCatLink'.
DBCC results for 'dc_ecshst_d'.
There are 0 rows in 0 pages for object 'dc_ecshst_d'.
DBCC results for 'apCheckNumTemp'.
There are 0 rows in 1 pages for object 'apCheckNumTemp'.
DBCC results for 'sysECSAdjReasonCode'.
There are 40 rows in 1 pages for object 'sysECSAdjReasonCode'.
DBCC results for 'hl7ExceptionLog'.
There are 0 rows in 0 pages for object 'hl7ExceptionLog'.
DBCC results for 'apCheckPoint'.
There are 2848 rows in 40 pages for object 'apCheckPoint'.
DBCC results for 'rptErrorWarning'.
There are 66 rows in 5 pages for object 'rptErrorWarning'.
DBCC results for 'hl7MsgQueueIncoming'.
There are 0 rows in 0 pages for object 'hl7MsgQueueIncoming'.
DBCC results for 'admProfPhone'.
There are 155 rows in 1 pages for object 'admProfPhone'.
DBCC results for 'hl7ProcessingErrors'.
There are 0 rows in 0 pages for object 'hl7ProcessingErrors'.
DBCC results for 'arTFBatchDetail'.
There are 2 rows in 1 pages for object 'arTFBatchDetail'.
DBCC results for 'rptFacilityRUGReport'.
There are 0 rows in 0 pages for object 'rptFacilityRUGReport'.
DBCC results for 'hl7RawMsgIncoming'.
There are 0 rows in 0 pages for object 'hl7RawMsgIncoming'.
DBCC results for 'apInvoice'.
There are 12516 rows in 167 pages for object 'apInvoice'.
DBCC results for 'tblDiagSubject'.
There are 1217 rows in 7 pages for object 'tblDiagSubject'.
DBCC results for 'dc_ub92_d'.
There are 0 rows in 0 pages for object 'dc_ub92_d'.
DBCC results for 'mdsAssessSignature'.
There are 4322 rows in 59 pages for object 'mdsAssessSignature'.
DBCC results for 'a_arChargeTransLink'.
There are 0 rows in 0 pages for object 'a_arChargeTransLink'.
DBCC results for 'mdsCMLink'.
There are 105 rows in 2 pages for object 'mdsCMLink'.
DBCC results for 'dosConvertCriteria'.
There are 0 rows in 0 pages for object 'dosConvertCriteria'.
DBCC results for 'admRace'.
There are 6 rows in 1 pages for object 'admRace'.
DBCC results for 'rptMDSAssmtDue'.
There are 0 rows in 1 pages for object 'rptMDSAssmtDue'.
DBCC results for 'a_mdsAssessSignature'.
There are 0 rows in 0 pages for object 'a_mdsAssessSignature'.
DBCC results for 'a_arNote'.
There are 0 rows in 0 pages for object 'a_arNote'.
DBCC results for 'apInvoiceBatch'.
There are 966 rows in 5 pages for object 'apInvoiceBatch'.
DBCC results for 'dosConvertFields'.
There are 392 rows in 3 pages for object 'dosConvertFields'.
DBCC results for 'rptMDSAssmtDueByDate'.
There are 0 rows in 1 pages for object 'rptMDSAssmtDueByDate'.
DBCC results for 'mdsAssessSignTypes'.
There are 9 rows in 1 pages for object 'mdsAssessSignTypes'.
DBCC results for 'a_arPAWorksheetDetail'.
There are 0 rows in 0 pages for object 'a_arPAWorksheetDetail'.
DBCC results for 'apInvoiceBatchDetail'.
There are 47 rows in 1 pages for object 'apInvoiceBatchDetail'.
DBCC results for 'rptMDSCurrentECSItems'.
There are 0 rows in 0 pages for object 'rptMDSCurrentECSItems'.
DBCC results for 'a_arPayment'.
There are 0 rows in 0 pages for object 'a_arPayment'.
DBCC results for 'apInvoiceBatchTransDetail'.
There are 50 rows in 1 pages for object 'apInvoiceBatchTransDetail'.
DBCC results for 'mdsCMMaximizer'.
There are 15 rows in 1 pages for object 'mdsCMMaximizer'.
DBCC results for 'apInvoiceCheckLink'.
There are 12497 rows in 59 pages for object 'apInvoiceCheckLink'.
DBCC results for 'mdsRugsUserRateMC'.
There are 27 rows in 1 pages for object 'mdsRugsUserRateMC'.
DBCC results for 'dosConvertFiles'.
There are 1 rows in 1 pages for object 'dosConvertFiles'.
DBCC results for 'sysAllergyCodes'.
There are 249 rows in 2 pages for object 'sysAllergyCodes'.
DBCC results for 'sysECSFileCount'.
There are 0 rows in 0 pages for object 'sysECSFileCount'.
DBCC results for 'mdsStartDates'.
There are 0 rows in 0 pages for object 'mdsStartDates'.
DBCC results for 'a_arRecCharge'.
There are 0 rows in 0 pages for object 'a_arRecCharge'.
DBCC results for 'apInvoiceHistory'.
There are 12681 rows in 138 pages for object 'apInvoiceHistory'.
DBCC results for 'rptCurrentPrevalence'.
There are 0 rows in 0 pages for object 'rptCurrentPrevalence'.
DBCC results for 'admResAllergy'.
There are 762 rows in 7 pages for object 'admResAllergy'.
DBCC results for 'apMiscAdjMemo'.
There are 0 rows in 0 pages for object 'apMiscAdjMemo'.
DBCC results for 'sysFeatCompanyLink'.
There are 82 rows in 1 pages for object 'sysFeatCompanyLink'.
DBCC results for 'a_arResCaseMix'.
There are 0 rows in 0 pages for object 'a_arResCaseMix'.
DBCC results for 'apNote'.
There are 1 rows in 1 pages for object 'apNote'.
DBCC results for 'rptDiseaseProfile'.
There are 0 rows in 0 pages for object 'rptDiseaseProfile'.
DBCC results for 'a_arResRoomAndBoard'.
There are 0 rows in 0 pages for object 'a_arResRoomAndBoard'.
DBCC results for 'rptDiseaseProfileDetail'.
There are 0 rows in 0 pages for object 'rptDiseaseProfileDetail'.
DBCC results for 'a_arStatement'.
There are 0 rows in 0 pages for object 'a_arStatement'.
DBCC results for 'apPaymentBatch'.
There are 793 rows in 3 pages for object 'apPaymentBatch'.
DBCC results for 'arStmtAdjmtUB92'.
There are 0 rows in 0 pages for object 'arStmtAdjmtUB92'.
DBCC results for 'apPaymentTerms'.
There are 6 rows in 1 pages for object 'apPaymentTerms'.
DBCC results for 'rptFacLongProfile'.
There are 0 rows in 0 pages for object 'rptFacLongProfile'.
DBCC results for 'mdsAnswerNotes'.
There are 6270 rows in 91 pages for object 'mdsAnswerNotes'.
DBCC results for 'a_arStmtDetailCMS1500'.
There are 0 rows in 0 pages for object 'a_arStmtDetailCMS1500'.
DBCC results for 'mdsAnswerReasons'.
There are 28 rows in 1 pages for object 'mdsAnswerReasons'.
DBCC results for 'a_arStmtDetailPP'.
There are 0 rows in 0 pages for object 'a_arStmtDetailPP'.
DBCC results for 'apPmtBatchDetail'.
There are 0 rows in 1 pages for object 'apPmtBatchDetail'.
DBCC results for 'rptHistoricalPrevalence'.
There are 0 rows in 0 pages for object 'rptHistoricalPrevalence'.
DBCC results for 'a_arStmtDetailUB92'.
There are 0 rows in 0 pages for object 'a_arStmtDetailUB92'.
DBCC results for 'apRecInvDetail'.
There are 15 rows in 1 pages for object 'apRecInvDetail'.
DBCC results for 'admContact'.
There are 2346 rows in 18 pages for object 'admContact'.
DBCC results for 'mdsAssessSectionLink'.
There are 222 rows in 1 pages for object 'mdsAssessSectionLink'.
DBCC results for 'admCounty'.
There are 1301 rows in 5 pages for object 'admCounty'.
DBCC results for 'sysGridFilter'.
There are 88 rows in 1 pages for object 'sysGridFilter'.
DBCC results for 'a_arStmtHeaderCMS1500'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderCMS1500'.
DBCC results for 'apRecInvTemp'.
There are 0 rows in 1 pages for object 'apRecInvTemp'.
DBCC results for 'admContactRelation'.
There are 28 rows in 1 pages for object 'admContactRelation'.
DBCC results for 'rptLongResProfileDetail'.
There are 0 rows in 0 pages for object 'rptLongResProfileDetail'.
DBCC results for 'a_arStmtHeaderPP'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderPP'.
DBCC results for 'apRecurringInvoice'.
There are 14 rows in 1 pages for object 'apRecurringInvoice'.
DBCC results for 'admResident'.
There are 1018 rows in 16 pages for object 'admResident'.
DBCC results for 'rptLongResProfileHeader'.
There are 0 rows in 0 pages for object 'rptLongResProfileHeader'.
DBCC results for 'sysListMenu'.
There are 24 rows in 1 pages for object 'sysListMenu'.
DBCC results for 'a_arStmtHeaderUB92'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderUB92'.
DBCC results for 'sysFeature'.
There are 34 rows in 1 pages for object 'sysFeature'.
DBCC results for 'sysCountyIndex'.
There are 10331 rows in 76 pages for object 'sysCountyIndex'.
DBCC results for 'sysListSettings'.
There are 144 rows in 2 pages for object 'sysListSettings'.
DBCC results for 'a_arTransaction'.
There are 0 rows in 0 pages for object 'a_arTransaction'.
DBCC results for 'apStartPaidBalance'.
There are 0 rows in 0 pages for object 'apStartPaidBalance'.
DBCC results for 'admResNotes'.
There are 248 rows in 3 pages for object 'admResNotes'.
DBCC results for 'secDefaultGroups'.
There are 476 rows in 4 pages for object 'secDefaultGroups'.
DBCC results for 'apStatement'.
There are 0 rows in 0 pages for object 'apStatement'.
DBCC results for 'arService'.
There are 312 rows in 4 pages for object 'arService'.
DBCC results for 'secUserAlertLink'.
There are 3 rows in 1 pages for object 'secUserAlertLink'.
DBCC results for 'sysLaborPercentage'.
There are 10 rows in 1 pages for object 'sysLaborPercentage'.
DBCC results for 'audAccess'.
There are 145672 rows in 1092 pages for object 'audAccess'.
DBCC results for 'sysGovRelationship'.
There are 20 rows in 1 pages for object 'sysGovRelationship'.
DBCC results for 'sysAlert'.
There are 3 rows in 1 pages for object 'sysAlert'.
DBCC results for 'sysMasterForm'.
There are 6 rows in 1 pages for object 'sysMasterForm'.
DBCC results for 'audAction'.
There are 0 rows in 0 pages for object 'audAction'.
DBCC results for 'apStmtTransLink'.
There are 0 rows in 0 pages for object 'apStmtTransLink'.
DBCC results for 'arStmtHeaderUB92'.
There are 2234 rows in 315 pages for object 'arStmtHeaderUB92'.
DBCC results for 'mdsDiagnosisCPLink'.
There are 0 rows in 0 pages for object 'mdsDiagnosisCPLink'.
DBCC results for 'audEvent'.
There are 301723 rows in 1240 pages for object 'audEvent'.
DBCC results for 'apTransaction'.
There are 21579 rows in 181 pages for object 'apTransaction'.
DBCC results for 'sysImportLog'.
There are 998 rows in 8 pages for object 'sysImportLog'.
DBCC results for 'mdsECSBatchInfo'.
There are 585 rows in 7 pages for object 'mdsECSBatchInfo'.
DBCC results for 'audEventType'.
There are 17 rows in 1 pages for object 'audEventType'.
DBCC results for 'sysMasterCP'.
There are 23 rows in 1 pages for object 'sysMasterCP'.
DBCC results for 'sysCaseMixVersion'.
There are 9 rows in 1 pages for object 'sysCaseMixVersion'.
DBCC results for 'mdsLock'.
There are 0 rows in 1 pages for object 'mdsLock'.
DBCC results for 'audLogin'.
There are 5399 rows in 42 pages for object 'audLogin'.
DBCC results for 'apTransDetail'.
There are 45417 rows in 254 pages for object 'apTransDetail'.
DBCC results for 'sysCaseMixVersionLink'.
There are 343 rows in 1 pages for object 'sysCaseMixVersionLink'.
DBCC results for 'mdsMDSCPLink'.
There are 12 rows in 1 pages for object 'mdsMDSCPLink'.
DBCC results for 'audTableActionLink'.
There are 0 rows in 0 pages for object 'audTableActionLink'.
DBCC results for 'apTransDetailTemp'.
There are 0 rows in 1 pages for object 'apTransDetailTemp'.
DBCC results for 'sysMedAllergyLink'.
There are 0 rows in 0 pages for object 'sysMedAllergyLink'.
DBCC results for 'sysUdAssess'.
There are 0 rows in 0 pages for object 'sysUdAssess'.
DBCC results for 'mdsMedCPLink'.
There are 0 rows in 0 pages for object 'mdsMedCPLink'.
DBCC results for 'sysControlSubstance'.
There are 7 rows in 1 pages for object 'sysControlSubstance'.
DBCC results for 'a_ecsRecords'.
There are 0 rows in 0 pages for object 'a_ecsRecords'.
DBCC results for 'apTransDetailType'.
There are 9 rows in 1 pages for object 'apTransDetailType'.
DBCC results for 'sysMedia'.
There are 570 rows in 3 pages for object 'sysMedia'.
DBCC results for 'mdsRAPs'.
There are 18 rows in 1 pages for object 'mdsRAPs'.
DBCC results for 'sysProcess'.
There are 31953 rows in 147 pages for object 'sysProcess'.
DBCC results for 'apTransHistory'.
There are 20944 rows in 49 pages for object 'apTransHistory'.
DBCC results for 'sysResSumByProbRptList'.
There are 39 rows in 2 pages for object 'sysResSumByProbRptList'.
DBCC results for 'arUserDefRate'.
There are 32 rows in 1 pages for object 'arUserDefRate'.
DBCC results for 'mdsRAPTriggerCPLink'.
There are 0 rows in 0 pages for object 'mdsRAPTriggerCPLink'.
DBCC results for 'sysDiagSubject'.
There are 1240 rows in 7 pages for object 'sysDiagSubject'.
DBCC results for 'admDischargeCode'.
There are 17 rows in 1 pages for object 'admDischargeCode'.
DBCC results for 'apTransOrigin'.
There are 4 rows in 1 pages for object 'apTransOrigin'.
DBCC results for 'a_admCarePlan'.
There are 0 rows in 0 pages for object 'a_admCarePlan'.
DBCC results for 'sysUdQuestAns'.
There are 0 rows in 0 pages for object 'sysUdQuestAns'.
DBCC results for 'sysECSEntityQualifier'.
There are 25 rows in 1 pages for object 'sysECSEntityQualifier'.
DBCC results for 'admMilitaryBranch'.
There are 6 rows in 1 pages for object 'admMilitaryBranch'.
DBCC results for 'a_mdsAnswerNotes'.
There are 0 rows in 0 pages for object 'a_mdsAnswerNotes'.
DBCC results for 'apTransType'.
There are 4 rows in 1 pages for object 'apTransType'.
DBCC results for 'sysUdQuestType'.
There are 10 rows in 1 pages for object 'sysUdQuestType'.
DBCC results for 'mdsRAPVersionLink'.
There are 18 rows in 1 pages for object 'mdsRAPVersionLink'.
DBCC results for 'sysECSFileFormat'.
There are 3 rows in 1 pages for object 'sysECSFileFormat'.
DBCC results for 'a_mdsAnswerReasons'.
There are 0 rows in 0 pages for object 'a_mdsAnswerReasons'.
DBCC results for 'apVendor'.
There are 1776 rows in 13 pages for object 'apVendor'.
DBCC results for 'tblResSumByProbRptList'.
There are 37 rows in 1 pages for object 'tblResSumByProbRptList'.
DBCC results for 'sysECSFileFormatVer'.
There are 21 rows in 1 pages for object 'sysECSFileFormatVer'.
DBCC results for 'admReligion'.
There are 49 rows in 1 pages for object 'admReligion'.
DBCC results for 'sysReportCatFields'.
There are 1311 rows in 17 pages for object 'sysReportCatFields'.
DBCC results for 'a_mdsAssessSummary'.
There are 0 rows in 0 pages for object 'a_mdsAssessSummary'.
DBCC results for 'a_arCharge'.
There are 0 rows in 0 pages for object 'a_arCharge'.
DBCC results for 'sysMedWarningLink'.
There are 0 rows in 0 pages for object 'sysMedWarningLink'.
DBCC results for 'sysECSFormVerToFileFormatVerLink'.
There are 50 rows in 1 pages for object 'sysECSFormVerToFileFormatVerLink'.
DBCC results for 'sysECSSrcPmtCodeMap'.
There are 11 rows in 1 pages for object 'sysECSSrcPmtCodeMap'.
DBCC results for 'admState'.
There are 53 rows in 1 pages for object 'admState'.
DBCC results for 'arAccount'.
There are 1555 rows in 16 pages for object 'arAccount'.
DBCC results for 'sysFDACode'.
There are 7 rows in 1 pages for object 'sysFDACode'.
DBCC results for 'sysReportCatFK'.
There are 70 rows in 1 pages for object 'sysReportCatFK'.
DBCC results for 'apVendorContact'.
There are 13 rows in 1 pages for object 'apVendorContact'.
DBCC results for 'sysOrderType'.
There are 22 rows in 1 pages for object 'sysOrderType'.
DBCC results for 'a_secAccessControl'.
There are 0 rows in 0 pages for object 'a_secAccessControl'.
DBCC results for 'mdsReactionActions'.
There are 838 rows in 4 pages for object 'mdsReactionActions'.
DBCC results for 'arAccountType'.
There are 22 rows in 1 pages for object 'arAccountType'.
DBCC results for 'sysFreqCodes'.
There are 24 rows in 1 pages for object 'sysFreqCodes'.
DBCC results for 'a_secAccountLink'.
There are 0 rows in 0 pages for object 'a_secAccountLink'.
DBCC results for 'apVendorPhone'.
There are 567 rows in 3 pages for object 'apVendorPhone'.
DBCC results for 'rptCarePlan'.
There are 0 rows in 0 pages for object 'rptCarePlan'.
DBCC results for 'secAccountPwdHistory'.
There are 0 rows in 0 pages for object 'secAccountPwdHistory'.
DBCC results for 'apVoidReason'.
There are 23 rows in 1 pages for object 'apVoidReason'.
DBCC results for 'a_secAccounts'.
There are 0 rows in 0 pages for object 'a_secAccounts'.
DBCC results for 'a_arStmtHeaderUB04'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderUB04'.
DBCC results for 'sysResSumByProbRptECSKeys'.
There are 172 rows in 1 pages for object 'sysResSumByProbRptECSKeys'.
DBCC results for 'arStmtDetailUCF'.
There are 0 rows in 0 pages for object 'arStmtDetailUCF'.
DBCC results for 'arStmtHeaderUB04'.
There are 362 rows in 67 pages for object 'arStmtHeaderUB04'.
DBCC results for 'mdsReactionCauses'.
There are 932 rows in 4 pages for object 'mdsReactionCauses'.
DBCC results for 'rptKeyLookup'.
There are 85 rows in 2 pages for object 'rptKeyLookup'.
DBCC results for 'sysGridColumn'.
There are 768 rows in 10 pages for object 'sysGridColumn'.
DBCC results for 'admResSchdCodePassTime'.
There are 0 rows in 0 pages for object 'admResSchdCodePassTime'.
DBCC results for 'sysSQL'.
There are 17 rows in 7 pages for object 'sysSQL'.
DBCC results for 'a_arStmtDetailUCF'.
There are 0 rows in 0 pages for object 'a_arStmtDetailUCF'.
DBCC results for 'rptFlowsheetResidents'.
There are 0 rows in 0 pages for object 'rptFlowsheetResidents'.
DBCC results for 'sysPGA'.
There are 1166 rows in 19 pages for object 'sysPGA'.
DBCC results for 'arStmtHeaderUCF'.
There are 0 rows in 0 pages for object 'arStmtHeaderUCF'.
DBCC results for 'rptMDSResRoster'.
There are 84 rows in 3 pages for object 'rptMDSResRoster'.
DBCC results for 'a_arStmtHeaderUCF'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderUCF'.
DBCC results for 'rptNAAFormResidents'.
There are 0 rows in 0 pages for object 'rptNAAFormResidents'.
DBCC results for 'sysPGAMCPLink'.
There are 191 rows in 1 pages for object 'sysPGAMCPLink'.
DBCC results for 'sysUserScreenSettings'.
There are 25 rows in 1 pages for object 'sysUserScreenSettings'.
DBCC results for 'glAcctAttribute'.
There are 19 rows in 1 pages for object 'glAcctAttribute'.
DBCC results for 'rptResidentinfo'.
There are 2 rows in 1 pages for object 'rptResidentinfo'.
DBCC results for 'glAcctToDistCodeLink'.
There are 0 rows in 0 pages for object 'glAcctToDistCodeLink'.
DBCC results for 'admNATasks'.
There are 0 rows in 0 pages for object 'admNATasks'.
DBCC results for 'glAttribute'.
There are 4 rows in 1 pages for object 'glAttribute'.
DBCC results for 'admCarePlan'.
There are 671 rows in 14 pages for object 'admCarePlan'.
DBCC results for 'secAccessControl'.
There are 9474 rows in 44 pages for object 'secAccessControl'.
DBCC results for 'admPhyOrders'.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27978) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27979) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27980) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27981) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27982) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27983) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27984) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1395757021, index ID 0, page (1:27985), row 1. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 94 and 193.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1395757021, index ID 0, page (1:27985), row 1. Test (GetRecType (pRec) >= 0 && GetRecType (pRec) <= LAST_REC_TYPE) failed. Values are 14 and 12.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1395757021, index ID 1, and page (1:27977), slot 0, in object ID 1539757534, index ID 1, next refer to page (1:27978) but are not in the same object.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1395757021, index ID 1, and page (1:28007), slot 0, in object ID 1539757534, index ID 1, next refer to page (1:27984) but are not in the same object.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1395757021, index ID 1. B-tree chain linkage mismatch. (1:28007)->next = (1:27984), but (1:27984)->Prev = (1:27983).
Server: Msg 8937, Level 16, State 1, Line 1
Table error: Object ID 1539080819, index ID 20. B-tree page (1:14640) has two parent nodes (0:1), slot 0 and (0:0), slot 0.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27978) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27979) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27980) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27981) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27982) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27983) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27984) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1539757534, index ID 0: Page (1:27985) could not be processed. See other errors for details.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35629) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1539757534, index ID 0: Page (1:35630) could not be processed. See other errors for details.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35638) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35639) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35640) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35641) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35642) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35643) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35644) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1539757534, index ID 0: Page (1:35785) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 0, page (1:35785), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 133 and 57.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35786) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35787) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35788) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:27968) is missing a reference from previous page (1:27983). Possible chain linkage problem.
Server: Msg 8982, Level 16, State 1, Line 1
Table error: Cross object linkage. Page (1:27977)->next in object ID 1539757534, index ID 1 refers to page (1:27978) in object ID 1395757021, index ID 1 but is not in the same index.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 88, in object ID 1539757534, index ID 1, refers to page (1:27984), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (1:28984), slot 89, in object ID 1539757534, index ID 1, and page (1:27984), slot 0, in object ID 1395757021, index ID 1, next refer to page (1:27985) but are not in the same object.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 98, in object ID 1539757534, index ID 1, refers to page (1:27978), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 99, in object ID 1539757534, index ID 1, refers to page (1:27979), slot 0, in object ID 1395757021, index ID 1.
There are 4539 rows in 75 pages for object 'admPhyOrders'.
DBCC results for 'a_secCompUserLink'.
There are 0 rows in 0 pages for object 'a_secCompUserLink'.
DBCC results for 'glDueToDueFrom'.
There are 0 rows in 0 pages for object 'glDueToDueFrom'.
DBCC results for 'sysInfo'.
There are 1 rows in 1 pages for object 'sysInfo'.
DBCC results for 'arPayment'.
There are 24361 rows in 360 pages for object 'arPayment'.
CHECKDB found 0 allocation errors and 12 consistency errors in table 'arPayment' (object ID 1395757021).
DBCC results for 'glTransToAPTransLink'.
There are 44021 rows in 101 pages for object 'glTransToAPTransLink'.
DBCC results for 'secGenSettings'.
There are 1 rows in 1 pages for object 'secGenSettings'.
DBCC results for 'mdsQuestions'.
There are 1716 rows in 19 pages for object 'mdsQuestions'.
DBCC results for 'arBillingCategory'.
There are 13 rows in 1 pages for object 'arBillingCategory'.
DBCC results for 'sysTaskCodes'.
There are 0 rows in 0 pages for object 'sysTaskCodes'.
DBCC results for 'arBatch'.
There are 4147 rows in 45 pages for object 'arBatch'.
DBCC results for 'arBillingForm'.
There are 16 rows in 1 pages for object 'arBillingForm'.
DBCC results for 'arPaymentBatchDetail'.
There are 2 rows in 1 pages for object 'arPaymentBatchDetail'.
DBCC results for 'sysWizardPage'.
There are 67 rows in 1 pages for object 'sysWizardPage'.
DBCC results for 'tblapVendor'.
There are 0 rows in 0 pages for object 'tblapVendor'.
DBCC results for 'a_admPhyOrderAdmin'.
There are 0 rows in 0 pages for object 'a_admPhyOrderAdmin'.
DBCC results for 'arBillingParty'.
There are 64 rows in 1 pages for object 'arBillingParty'.
DBCC results for 'sysWizardSettings'.
There are 22 rows in 1 pages for object 'sysWizardSettings'.
DBCC results for 'a_secGenSettings'.
There are 0 rows in 0 pages for object 'a_secGenSettings'.
DBCC results for 'sysInsuranceProvider'.
There are 78 rows in 1 pages for object 'sysInsuranceProvider'.
DBCC results for 'a_admResPGA'.
There are 0 rows in 0 pages for object 'a_admResPGA'.
DBCC results for 'arCharge'.
There are 80123 rows in 1521 pages for object 'arCharge'.
DBCC results for 'admResCensus'.
There are 303 rows in 2 pages for object 'admResCensus'.
DBCC results for 'rptAssessmentScreening'.
There are 0 rows in 0 pages for object 'rptAssessmentScreening'.
DBCC results for 'arBPartyInsTypeLink'.
There are 26 rows in 1 pages for object 'arBPartyInsTypeLink'.
DBCC results for 'sysMedicationFile'.
There are 168 rows in 3 pages for object 'sysMedicationFile'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysMedicationFile' (object ID 1539080819).
DBCC results for 'arTransaction'.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 100, in object ID 1539757534, index ID 1, refers to page (1:27980), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 101, in object ID 1539757534, index ID 1, refers to page (1:27981), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 102, in object ID 1539757534, index ID 1, refers to page (1:27982), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 103, in object ID 1539757534, index ID 1, refers to page (1:27983), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35624) is missing a reference from previous page (1:35639). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35629) was not seen in the scan although its parent (1:36209) and previous (1:35628) refer to it. Check any previous errors.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35638) was not seen in the scan although its parent (1:36209) and previous (1:35637) refer to it. Check any previous errors.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 262 refers to child page (1:35639) and previous child (1:35638), but they were not encountered.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35640) was not seen in the scan although its parent (1:36209) and previous (1:35655) refer to it. Check any previous errors.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 248 refers to child page (1:35641) and previous child (1:35640), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 249 refers to child page (1:35642) and previous child (1:35641), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 250 refers to child page (1:35643) and previous child (1:35642), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 251 refers to child page (1:35644) and previous child (1:35643), but they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35645) is missing a reference from previous page (1:35644). Possible chain linkage problem.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 202 refers to child page (1:35787) and previous child (1:35786), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 203 refers to child page (1:35788) and previous child (1:35787), but they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35789) is missing a reference from previous page (1:35788). Possible chain linkage problem.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24303) (level 0) is not less than the low key value in the parent (1:24802), slot 160 of the next page (1:24288).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24304) (level 0) is not less than the low key value in the parent (1:24802), slot 145 of the next page (1:24305).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24305) (level 0) is not less than the low key value in the parent (1:24802), slot 146 of the next page (1:24306).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24306) (level 0) is not less than the low key value in the parent (1:24802), slot 147 of the next page (1:24307).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24307) (level 0) is not less than the low key value in the parent (1:24802), slot 148 of the next page (1:24308).
Server: Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24308) (level 0) is not less than the low key value in the parent (1:24802), slot 149 of the next page (1:24309).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24309) (level 0) is not less than the low key value in the parent (1:24802), slot 150 of the next page (1:24310).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 20. Keys out of order on page (1:24310), slots 332 and 333.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 20. Keys out of order on page (1:24310), slots 333 and 334.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The next pointer of (1:22815) refers to page (1:22760). Neither (1:22760) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. Page (1:22800) is missing a reference from previous page (1:22815). Possible chain linkage problem.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The high key value on page (1:22810) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:22811).
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22811) (level 0) is not >= the key value in the parent (1:23522) slot 321.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22812) (level 0) is not >= the key value in the parent (1:23522) slot 322.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22813) (level 0) is not >= the key value in the parent (1:23522) slot 323.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22814) (level 0) is not >= the key value in the parent (1:23522) slot 324.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22815) (level 0) is not >= the key value in the parent (1:23522) slot 325.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22816) (level 0) is not >= the key value in the parent (1:23522) slot 310.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22817) (level 0) is not >= the key value in the parent (1:23522) slot 311.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 21. Keys out of order on page (1:22825), slots 333 and 334.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 21. Keys out of order on page (1:22825), slots 546 and 547.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22826) (level 0) is not >= the key value in the parent (1:23522) slot 304.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22827) (level 0) is not >= the key value in the parent (1:23522) slot 305.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22828) (level 0) is not >= the key value in the parent (1:23522) slot 306.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22829) (level 0) is not >= the key value in the parent (1:23522) slot 307.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22830) (level 0) is not >= the key value in the parent (1:23522) slot 308.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22831) (level 0) is not >= the key value in the parent (1:23522) slot 309.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22832) (level 0) is not >= the key value in the parent (1:23522) slot 294.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The high key value on page (1:22847) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:22832).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20555) (level 0) is not less than the low key value in the parent (1:20578), slot 27 of the next page (1:20556).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20556) (level 0) is not less than the low key value in the parent (1:20578), slot 28 of the next page (1:20557).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20557) (level 0) is not less than the low key value in the parent (1:20578), slot 29 of the next page (1:20558).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20558) (level 0) is not less than the low key value in the parent (1:20578), slot 30 of the next page (1:20559).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20559) (level 0) is not less than the low key value in the parent (1:20578), slot 31 of the next page (1:20544).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 332 and 333.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 418 and 419.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 546 and 547.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20568) (level 0) is not less than the low key value in the parent (1:20578), slot 8 of the next page (1:20569).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20569) (level 0) is not less than the low key value in the parent (1:20578), slot 9 of the next page (1:20570).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20570) (level 0) is not less than the low key value in the parent (1:20578), slot 10 of the next page (1:20571).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19467) (level 0) is not less than the low key value in the parent (1:19922), slot 297 of the next page (1:19468).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19468) (level 0) is not less than the low key value in the parent (1:19922), slot 298 of the next page (1:19469).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19469) (level 0) is not less than the low key value in the parent (1:19922), slot 299 of the next page (1:19470).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19470) (level 0) is not less than the low key value in the parent (1:19922), slot 300 of the next page (1:19471).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19471) (level 0) is not less than the low key value in the parent (1:19922), slot 301 of the next page (1:19456).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19472) (level 0) is not less than the low key value in the parent (1:19922), slot 286 of the next page (1:19473).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19480) (level 0) is not less than the low key value in the parent (1:19922), slot 278 of the next page (1:19481).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19480), slots 417 and 418.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19480), slots 545 and 546.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19481) (level 0) is not less than the low key value in the parent (1:19922), slot 279 of the next page (1:19482).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19482) (level 0) is not less than the low key value in the parent (1:19922), slot 280 of the next page (1:19483).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19835) (level 0) is not less than the low key value in the parent (1:19922), slot 95 of the next page (1:19836).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19836) (level 0) is not less than the low key value in the parent (1:19922), slot 96 of the next page (1:19837).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19837) (level 0) is not less than the low key value in the parent (1:19922), slot 97 of the next page (1:19838).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19838) (level 0) is not less than the low key value in the parent (1:19922), slot 98 of the next page (1:19839).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19839) (level 0) is not less than the low key value in the parent (1:19922), slot 99 of the next page (1:19824).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19840), slots 332 and 333.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19850) (level 0) is not less than the low key value in the parent (1:19922), slot 78 of the next page (1:19851).
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1539757534, index ID 26, and page (1:18935), slot 0, in object ID 1539757534, index ID 27, next refer to page (1:18920) but are not in the same object.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1539757534, ind
View 7 Replies
View Related
Dec 17, 2007
I tried to paste the whole file but didn't work. So here is a small part of it. Anyone know how i could solve it. Thanks
v 16, State 1, Line 1 : DBCC results for 'SW_DS_FINAL_SUM'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 15 rows in 1 pages for object "SW_DS_FINAL_SUM". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'BOM_Active_Sku_DV_Report'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 12610 rows in 789 pages for object "BOM_Active_Sku_DV_Report". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ml_city'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 640 rows in 3 pages for object "ml_city". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Monthly_SalesReps_2006_2007_SalesReps_List'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 546 rows in 15 pages for object "Monthly_SalesReps_2006_2007_SalesReps_List". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ADHOC_2008_IPG_Comp_Program_Report'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 9 rows in 1 pages for object "ADHOC_2008_IPG_Comp_Program_Report". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'swidziun.TEMPCDVAR'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 21 rows in 1 pages for object "swidziun.TEMPCDVAR". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Adhoc_Dom_April_July'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 30522 rows in 3393 pages for object "Adhoc_Dom_April_July". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'SW_DS_QTD_FLEX'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 13 rows in 1 pages for object "SW_DS_QTD_FLEX". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'cr_parent_top10'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 0 pages for object "cr_parent_top10". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'laugusti.Sheet1$'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 518 rows in 2 pages for object "laugusti.Sheet1$". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'LUC_Top20_Step3'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 29412 rows in 898 pages for object "LUC_Top20_Step3". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ADHOC_STRETCH_2007_DOM_DATA_REPORT'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 844 rows in 21 pages for object "ADHOC_STRETCH_2007_DOM_DATA_REPORT". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'WEEKLY_SUBCLASS_BF_LQ'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 5610 rows in 99 pages for object "WEEKLY_SUBCLASS_BF_LQ". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ML_city_final'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 640 rows in 8 pages for object "ML_city_final". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ML_ORDERS_2007'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 299291 rows in 5173 pages for object "ML_ORDERS_2007". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ml_xpdex_user_name'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 97 pages for object "ml_xpdex_user_name". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'SW_DS_BOOKED_ORDERS'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 0 pages for object "SW_DS_BOOKED_ORDERS". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC res
http://www.sqlserverstudy.com
View 4 Replies
View Related