Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
d3ng
Yak Posting Veteran
83 Posts |
 Posted - 2007-10-19 : 00:44:28
|
| Hi experts. I would like to ask for this error that I've encountered(Error msg)Msg 5242, Level 22, State 1, Line 1An inconsistency was detected during an internal operation in database 'smartapp'(ID:9) on page (1:28827). Please contact technical support. Reference number 7.then I tried executing this:DBCC CHECKDB('Bizbox_training', 'smartapp')DBCC CHECKDB('Bizbox_training', 'smartapp')but this error still occurs, can you help me fixing this kind of problem. Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-19 : 00:51:20
|
| You'll need to post the entire output of the DBCC CHECKDB command into the Data Corruption forum here so that engineers can take a look and help you resolve it.Hopefully you've got good backups in place.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2007-10-19 : 01:19:07
|
| Result msg for REPAIR_ALLOW_DATA_LOSSDBCC results for 'smartapp'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.DBCC results for 'sys.sysrowsetcolumns'.There are 21765 rows in 173 pages for object "sys.sysrowsetcolumns".DBCC results for 'sys.sysrowsets'.There are 1798 rows in 13 pages for object "sys.sysrowsets".DBCC results for 'sysallocunits'.There are 2018 rows in 24 pages for object "sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syshobtcolumns'.There are 21765 rows in 196 pages for object "sys.syshobtcolumns".DBCC results for 'sys.syshobts'.There are 1798 rows in 13 pages for object "sys.syshobts".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysserefs'.There are 2018 rows in 10 pages for object "sys.sysserefs".DBCC results for 'sys.sysowners'.There are 14 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 134 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 10227 rows in 218 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.There are 18121 rows in 315 pages for object "sys.syscolpars".DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysxprops'.There are 10 rows in 1 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 27 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 4068 rows in 74 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 4115 rows in 32 pages for object "sys.sysiscols".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysobjvalues'.There are 13207 rows in 829 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 15 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 140 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 191 rows in 1 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysdbfiles'.There are 2 rows in 1 pages for object "sys.sysdbfiles".DBCC results for 'sys.sysguidrefs'.There are 1 rows in 1 pages for object "sys.sysguidrefs".DBCC results for 'sys.sysqnames'.There are 91 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 93 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 97 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 17 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 0 rows in 0 pages for object "sys.sysbinsubobjs".DBCC results for 'bloodchemistrytemp'.There are 0 rows in 0 pages for object "bloodchemistrytemp".DBCC results for 'projinv'.There are 0 rows in 0 pages for object "projinv".DBCC results for 'exm_urinalysis'.There are 0 rows in 0 pages for object "exm_urinalysis".DBCC results for 'msctrantype'.There are 43 rows in 2 pages for object "msctrantype".DBCC results for 'mcitem'.There are 0 rows in 0 pages for object "mcitem".DBCC results for 'auditsys'.There are 6700 rows in 233 pages for object "auditsys".DBCC results for 'issitem'.There are 0 rows in 1 pages for object "issitem".DBCC results for 'appsysverses'.There are 3 rows in 1 pages for object "appsysverses".DBCC results for 'ordiscdtls'.There are 0 rows in 0 pages for object "ordiscdtls".DBCC results for 'ultrasoundtemp'.There are 0 rows in 1 pages for object "ultrasoundtemp".DBCC results for 'itemtmpmaster'.There are 1 rows in 1 pages for object "itemtmpmaster".DBCC results for 'cvdtls'.There are 0 rows in 1 pages for object "cvdtls".DBCC results for 'itemldgrdepot'.There are 0 rows in 0 pages for object "itemldgrdepot".DBCC results for 'bankrecontemp'.There are 0 rows in 1 pages for object "bankrecontemp".DBCC results for 'dlsu_vitros'.There are 0 rows in 0 pages for object "dlsu_vitros".DBCC results for 'mschosprelate'.There are 0 rows in 1 pages for object "mschosprelate".DBCC results for 'smc_microscopy'.There are 0 rows in 0 pages for object "smc_microscopy".DBCC results for 'bloodchemistry05'.There are 0 rows in 0 pages for object "bloodchemistry05".DBCC results for 'supavitm'.There are 0 rows in 0 pages for object "supavitm".DBCC results for 'bloodchemistry06'.There are 0 rows in 0 pages for object "bloodchemistry06".DBCC results for 'ormstr'.There are 299 rows in 15 pages for object "ormstr".DBCC results for 'mcledger'.There are 455 rows in 143 pages for object "mcledger".DBCC results for 'wareitem'.There are 2603 rows in 69 pages for object "wareitem".DBCC results for 'hematologytempvmmc'.There are 0 rows in 0 pages for object "hematologytempvmmc".DBCC results for 'quoteitm'.There are 0 rows in 0 pages for object "quoteitm".DBCC results for 'mscphicmembership'.There are 18 rows in 1 pages for object "mscphicmembership".DBCC results for 'appsysrepfiles'.There are 324 rows in 19 pages for object "appsysrepfiles".DBCC results for 'mscdctrdept'.There are 0 rows in 0 pages for object "mscdctrdept".DBCC results for 'bdh_obstetric1'.There are 0 rows in 0 pages for object "bdh_obstetric1".DBCC results for 'performancetrace'.There are 0 rows in 0 pages for object "performancetrace".DBCC results for 'serology01'.There are 0 rows in 0 pages for object "serology01".DBCC results for 'datacenter'.There are 1602 rows in 119 pages for object "datacenter".DBCC results for 'ortranpatinv'.There are 0 rows in 0 pages for object "ortranpatinv".DBCC results for 'hematologyvmmc'.There are 10 rows in 1 pages for object "hematologyvmmc".DBCC results for 'profilersql'.There are 0 rows in 0 pages for object "profilersql".DBCC results for 'mscmodepay'.There are 5 rows in 1 pages for object "mscmodepay".DBCC results for 'immunology02temp'.There are 0 rows in 0 pages for object "immunology02temp".DBCC results for 'immunology04'.There are 0 rows in 0 pages for object "immunology04".DBCC results for 'audittrail'.There are 22819 rows in 617 pages for object "audittrail".DBCC results for 'hematologyexam'.There are 0 rows in 0 pages for object "hematologyexam".DBCC results for 'immunology01'.There are 0 rows in 0 pages for object "immunology01".DBCC results for 'roomclass'.There are 0 rows in 0 pages for object "roomclass".DBCC results for 'msctrangroup'.There are 18 rows in 1 pages for object "msctrangroup".DBCC results for 'nvtemplate'.There are 28 rows in 3 pages for object "nvtemplate".DBCC results for 'mmmc_hmo_dr'.There are 0 rows in 0 pages for object "mmmc_hmo_dr".DBCC results for 'mschospsharetype'.There are 0 rows in 0 pages for object "mschospsharetype".DBCC results for 'rooms'.There are 0 rows in 0 pages for object "rooms".DBCC results for 'ResultImages'.There are 0 rows in 0 pages for object "ResultImages".DBCC results for 'mscdisctype'.There are 22 rows in 1 pages for object "mscdisctype".DBCC results for 'mscdiscordinance'.There are 0 rows in 0 pages for object "mscdiscordinance".DBCC results for 'arcost'.There are 0 rows in 0 pages for object "arcost".DBCC results for 'exm_ape'.There are 0 rows in 0 pages for object "exm_ape".DBCC results for 'ositem'.There are 0 rows in 0 pages for object "ositem".DBCC results for 'mscitemcateg'.There are 44 rows in 1 pages for object "mscitemcateg".DBCC results for 'prdadjinv'.There are 0 rows in 0 pages for object "prdadjinv".DBCC results for 'supavinv'.There are 0 rows in 0 pages for object "supavinv".DBCC results for 'discordinance_child'.There are 0 rows in 0 pages for object "discordinance_child".DBCC results for 'lis_vitros'.There are 0 rows in 0 pages for object "lis_vitros".DBCC results for 'outpatient'.There are 13 rows in 4 pages for object "outpatient".DBCC results for 'jvmstr'.There are 0 rows in 1 pages for object "jvmstr".DBCC results for 'bdh_surgicalpath'.There are 0 rows in 0 pages for object "bdh_surgicalpath".DBCC results for 'sysdiagrams'.There are 0 rows in 0 pages for object "sysdiagrams".DBCC results for 'exm_bloodbankchild'.There are 0 rows in 0 pages for object "exm_bloodbankchild".DBCC results for 'budget'.There are 0 rows in 0 pages for object "budget".DBCC results for 'mcgta'.There are 0 rows in 0 pages for object "mcgta".DBCC results for 'serology03temp'.There are 0 rows in 0 pages for object "serology03temp".DBCC results for 'bloodchemspecialtemp'.There are 0 rows in 0 pages for object "bloodchemspecialtemp".DBCC results for 'radiology'.There are 1 rows in 1 pages for object "radiology".DBCC results for 'microbiologyvmmc'.There are 0 rows in 0 pages for object "microbiologyvmmc".DBCC results for 'patsalesmstr'.There are 0 rows in 1 pages for object "patsalesmstr".DBCC results for 'mscdosage'.There are 0 rows in 0 pages for object "mscdosage".DBCC results for 'bloodgasvmmctemp'.There are 0 rows in 0 pages for object "bloodgasvmmctemp".DBCC results for 'bdh_serology'.There are 0 rows in 0 pages for object "bdh_serology".DBCC results for 'mscewtcode'.There are 0 rows in 0 pages for object "mscewtcode".DBCC results for 'carotid'.There are 0 rows in 0 pages for object "carotid".DBCC results for 'hij_iaa'.There are 0 rows in 0 pages for object "hij_iaa".DBCC results for 'icdprimeclass'.There are 21 rows in 1 pages for object "icdprimeclass".DBCC results for 'mmmc_ecu'.There are 0 rows in 0 pages for object "mmmc_ecu".DBCC results for 'obcytopathology'.There are 0 rows in 0 pages for object "obcytopathology".DBCC results for 'exm_microscopy'.There are 358 rows in 58 pages for object "exm_microscopy".DBCC results for 'bmiref'.There are 0 rows in 0 pages for object "bmiref".DBCC results for 'msccaesariantype'.There are 0 rows in 0 pages for object "msccaesariantype".DBCC results for 'prinv'.There are 0 rows in 1 pages for object "prinv".DBCC results for 'bdh_cardiac'.There are 0 rows in 0 pages for object "bdh_cardiac".DBCC results for 'msccasetype'.There are 3 rows in 1 pages for object "msccasetype".DBCC results for 'patitemcomp'.There are 0 rows in 1 pages for object "patitemcomp".DBCC results for 'issinv'.There are 0 rows in 1 pages for object "issinv".DBCC results for 'whreqitm'.There are 0 rows in 1 pages for object "whreqitm".DBCC results for 'hivtesttemp'.There are 0 rows in 0 pages for object "hivtesttemp".DBCC results for 'prdadjitm'.There are 0 rows in 0 pages for object "prdadjitm".DBCC results for 'bdh_hematologytemp'.There are 0 rows in 0 pages for object "bdh_hematologytemp".DBCC results for 'his_lis'.There are 0 rows in 0 pages for object "his_lis".DBCC results for 'patledger2'.There are 0 rows in 72 pages for object "patledger2".DBCC results for 'icd10'.There are 13678 rows in 199 pages for object "icd10".DBCC results for 'diagnostic_abi'.There are 0 rows in 0 pages for object "diagnostic_abi".DBCC results for 'bdh_biophysical'.There are 0 rows in 0 pages for object "bdh_biophysical".DBCC results for 'poinv'.There are 0 rows in 1 pages for object "poinv".DBCC results for 'mscunits'.There are 42 rows in 1 pages for object "mscunits".DBCC results for 'glclass$'.There are 65 rows in 4 pages for object "glclass$".DBCC results for 'prepay'.There are 0 rows in 0 pages for object "prepay".DBCC results for 'bankrecondtls'.There are 0 rows in 1 pages for object "bankrecondtls".DBCC results for 'diagnostic_venous'.There are 0 rows in 0 pages for object "diagnostic_venous".DBCC results for 'bgh_bloodchemistrytemp'.There are 0 rows in 0 pages for object "bgh_bloodchemistrytemp".DBCC results for 'patitem'.There are 47997 rows in 3680 pages for object "patitem".DBCC results for 'rebatesdet'.There are 0 rows in 1 pages for object "rebatesdet".DBCC results for 'arterialduplex'.There are 0 rows in 0 pages for object "arterialduplex".DBCC results for 'diagnostic_carotid'.There are 0 rows in 0 pages for object "diagnostic_carotid".DBCC results for 'vendor'.There are 9 rows in 1 pages for object "vendor".DBCC results for 'arldgr'.There are 461 rows in 14 pages for object "arldgr".DBCC results for 'discmstr'.There are 234 rows in 7 pages for object "discmstr".DBCC results for 'diagnostic_arterialduplex'.There are 0 rows in 0 pages for object "diagnostic_arterialduplex".DBCC results for 'mscglsetup'.There are 1 rows in 1 pages for object "mscglsetup".DBCC results for 'jvtmstr'.There are 0 rows in 0 pages for object "jvtmstr".DBCC results for 'diagnostic_venouslower'.There are 0 rows in 0 pages for object "diagnostic_venouslower".DBCC results for 'iteminv'.There are 0 rows in 1 pages for object "iteminv".DBCC results for 'mscdept'.There are 80 rows in 1 pages for object "mscdept".DBCC results for 'bloodbanking'.There are 0 rows in 0 pages for object "bloodbanking".DBCC results for 'arinv'.There are 461 rows in 25 pages for object "arinv".DBCC results for 'invtyend'.There are 0 rows in 0 pages for object "invtyend".DBCC results for 'smc_bloodbank'.There are 0 rows in 0 pages for object "smc_bloodbank".DBCC results for 'psh_earlypreg'.There are 0 rows in 0 pages for object "psh_earlypreg".DBCC results for 'mmmc_cdrb'.There are 0 rows in 0 pages for object "mmmc_cdrb".DBCC results for 'miscellaneousvmmc'.There are 0 rows in 0 pages for object "miscellaneousvmmc".DBCC results for 'pcgh_sourceincome'.There are 0 rows in 0 pages for object "pcgh_sourceincome".DBCC results for 'exm_hematology'.There are 1103 rows in 104 pages for object "exm_hematology".DBCC results for 'sph_allergens'.There are 0 rows in 1 pages for object "sph_allergens".DBCC results for 'icdclasslevel3'.There are 2061 rows in 69 pages for object "icdclasslevel3".DBCC results for 'birthcertrecord'.There are 0 rows in 0 pages for object "birthcertrecord".DBCC results for 'prodinv'.There are 0 rows in 0 pages for object "prodinv".DBCC results for 'apinv'.There are 0 rows in 1 pages for object "apinv".DBCC results for 'pcgh_targetincome'.There are 0 rows in 0 pages for object "pcgh_targetincome".DBCC results for 'rch_ecg'.There are 0 rows in 0 pages for object "rch_ecg".DBCC results for 'mscdoclist'.There are 34 rows in 1 pages for object "mscdoclist".DBCC results for 'patient'.There are 1060 rows in 222 pages for object "patient".DBCC results for 'culturedet'.There are 0 rows in 0 pages for object "culturedet".DBCC results for 'mscdietlist'.There are 64 rows in 1 pages for object "mscdietlist".DBCC results for 'localizecaption'.There are 0 rows in 0 pages for object "localizecaption".DBCC results for 'ccdoc'.There are 92 rows in 1 pages for object "ccdoc".DBCC results for 'pritem'.There are 0 rows in 1 pages for object "pritem".DBCC results for 'dls_salmonella'.There are 0 rows in 0 pages for object "dls_salmonella".DBCC results for 'biochemistrytemp'.There are 1 rows in 1 pages for object "biochemistrytemp".DBCC results for 'miscdtl'.There are 0 rows in 0 pages for object "miscdtl".DBCC results for 'sn'.There are 0 rows in 0 pages for object "sn".DBCC results for 'microscopy03'.There are 0 rows in 0 pages for object "microscopy03".DBCC results for 'cmapplcust'.There are 0 rows in 1 pages for object "cmapplcust".DBCC results for 'generic'.There are 2396 rows in 35 pages for object "generic".DBCC results for 'electrocardiovmmc'.There are 0 rows in 0 pages for object "electrocardiovmmc".DBCC results for 'immunology02'.There are 0 rows in 0 pages for object "immunology02".DBCC results for 'msctowncity'.There are 1585 rows in 11 pages for object "msctowncity".DBCC results for 'proditem'.There are 0 rows in 0 pages for object "proditem".DBCC results for 'ape_coll'.There are 0 rows in 0 pages for object "ape_coll".DBCC results for 'psh_cyto'.There are 0 rows in 0 pages for object "psh_cyto".DBCC results for 'exm_serology'.There are 17 rows in 2 pages for object "exm_serology".DBCC results for 'mscterms'.There are 15 rows in 1 pages for object "mscterms".DBCC results for 'iteminven'.There are 0 rows in 0 pages for object "iteminven".DBCC results for 'bgh_hematology'.There are 0 rows in 0 pages for object "bgh_hematology".DBCC results for 'mmmc_eeg'.There are 0 rows in 0 pages for object "mmmc_eeg".DBCC results for 'arappl'.There are 0 rows in 1 pages for object "arappl".DBCC results for 'itemcomp'.There are 0 rows in 1 pages for object "itemcomp".DBCC results for 'bdh_hysterosal'.There are 0 rows in 0 pages for object "bdh_hysterosal".DBCC results for 'chemistryi'.There are 0 rows in 0 pages for object "chemistryi".DBCC results for 'ctscantemp'.There are 0 rows in 0 pages for object "ctscantemp".DBCC results for 'bdh_hemodialysis'.There are 0 rows in 0 pages for object "bdh_hemodialysis".DBCC results for 'debitcreditcateg'.There are 5 rows in 1 pages for object "debitcreditcateg".DBCC results for 'canvass'.There are 0 rows in 0 pages for object "canvass".DBCC results for 'olm_promissory'.There are 0 rows in 0 pages for object "olm_promissory".DBCC results for 'treadmill'.There are 0 rows in 0 pages for object "treadmill".DBCC results for 'mscpetclass'.There are 2 rows in 1 pages for object "mscpetclass".DBCC results for 'bgh_urinalysis'.There are 0 rows in 0 pages for object "bgh_urinalysis".DBCC results for 'dctrmaster'.There are 271 rows in 9 pages for object "dctrmaster".DBCC results for 'billmstr'.There are 0 rows in 1 pages for object "billmstr".DBCC results for 'mscqpriceupdt'.There are 0 rows in 0 pages for object "mscqpriceupdt".DBCC results for 'bdh_hematology'.There are 0 rows in 0 pages for object "bdh_hematology".DBCC results for 'appsysowner'.There are 1 rows in 1 pages for object "appsysowner".DBCC results for 'bloodchemistry'.There are 0 rows in 0 pages for object "bloodchemistry".DBCC results for 'msckittemplate'.There are 0 rows in 1 pages for object "msckittemplate".DBCC results for 'exmbiochemistry'.There are 0 rows in 0 pages for object "exmbiochemistry".DBCC results for 'dlsu_parasitology'.There are 0 rows in 0 pages for object "dlsu_parasitology".DBCC results for 'glclass'.There are 0 rows in 1 pages for object "glclass".DBCC results for 'bgh_bloodchemistry'.There are 0 rows in 0 pages for object "bgh_bloodchemistry".DBCC results for 'bacteriologyvmmc'.There are 0 rows in 0 pages for object "bacteriologyvmmc".DBCC results for 'orrangeuser'.There are 0 rows in 0 pages for object "orrangeuser".DBCC results for 'exm_chemistry'.There are 1205 rows in 199 pages for object "exm_chemistry".DBCC results for 'mscdisctemplate'.There are 30 rows in 1 pages for object "mscdisctemplate".DBCC results for 'discdtls'.There are 864 rows in 16 pages for object "discdtls".DBCC results for 'surgicalproc_child'.There are 0 rows in 0 pages for object "surgicalproc_child".DBCC results for 'mmmc_mammo'.There are 0 rows in 0 pages for object "mmmc_mammo".DBCC results for 'dlsu_abg'.There are 0 rows in 0 pages for object "dlsu_abg".DBCC results for 'exmbloodbanking'.There are 0 rows in 0 pages for object "exmbloodbanking".DBCC results for 'mmmc_tdc'.There are 0 rows in 0 pages for object "mmmc_tdc".DBCC results for 'appsyspcusers'.There are 69 rows in 4 pages for object "appsyspcusers".DBCC results for 'mmmc_nssdetails'.There are 0 rows in 0 pages for object "mmmc_nssdetails".DBCC results for 'mscassetclass'.There are 9 rows in 1 pages for object "mscassetclass".DBCC results for 'items'.There are 1988 rows in 368 pages for object "items".DBCC results for 'mmmc_cur'.There are 0 rows in 0 pages for object "mmmc_cur".DBCC results for 'diagnostic_venouslower2'.There are 0 rows in 0 pages for object "diagnostic_venouslower2".DBCC results for 'bdh_cardiactemp'.There are 0 rows in 0 pages for object "bdh_cardiactemp".DBCC results for 'discordinance_patitem'.There are 0 rows in 0 pages for object "discordinance_patitem".DBCC results for 'patupdowngrade'.There are 0 rows in 0 pages for object "patupdowngrade".DBCC results for 'hematology02'.There are 0 rows in 0 pages for object "hematology02".DBCC results for 'patpaydtls'.There are 632 rows in 16 pages for object "patpaydtls".DBCC results for 'exm_immunology'.There are 0 rows in 1 pages for object "exm_immunology".DBCC results for 'apitem'.There are 0 rows in 1 pages for object "apitem".DBCC results for 'patientdrugs'.There are 10 rows in 1 pages for object "patientdrugs".DBCC results for 'pcgh_groupincome'.There are 0 rows in 0 pages for object "pcgh_groupincome".DBCC results for 'mscallocatedbeds'.There are 12 rows in 1 pages for object "mscallocatedbeds".DBCC results for 'glgroupacct'.There are 0 rows in 1 pages for object "glgroupacct".DBCC results for 'dlsu_obstetric1'.There are 0 rows in 0 pages for object "dlsu_obstetric1".DBCC results for 'lis_vitrosdet'.There are 0 rows in 0 pages for object "lis_vitrosdet".DBCC results for 'gntrdoctordtls'.There are 48 rows in 1 pages for object "gntrdoctordtls".DBCC results for 'dlsu_radiology'.There are 0 rows in 0 pages for object "dlsu_radiology".DBCC results for 'alobitm'.There are 0 rows in 0 pages for object "alobitm".DBCC results for 'bacteriology02'.There are 0 rows in 0 pages for object "bacteriology02".DBCC results for 'mscFavorites'.There are 3 rows in 1 pages for object "mscFavorites".DBCC results for 'exmbloodbankvmmcreact'.There are 0 rows in 0 pages for object "exmbloodbankvmmcreact".DBCC results for 'orpay'.There are 299 rows in 8 pages for object "orpay".DBCC results for 'rtemplatemstr'.There are 0 rows in 0 pages for object "rtemplatemstr".DBCC results for 'cashflowtype'.There are 13 rows in 1 pages for object "cashflowtype".DBCC results for 'cptmstr'.There are 0 rows in 0 pages for object "cptmstr".DBCC results for 'mscfloatsrs'.There are 17 rows in 1 pages for object "mscfloatsrs".DBCC results for 'dlscmrb2'.There are 0 rows in 0 pages for object "dlscmrb2".DBCC results for 'mo_dtl'.There are 0 rows in 0 pages for object "mo_dtl".DBCC results for 'dlsu_rts'.There are 0 rows in 0 pages for object "dlsu_rts".DBCC results for 'pcgh_ecg'.There are 0 rows in 0 pages for object "pcgh_ecg".DBCC results for 'echocardiography'.There are 0 rows in 0 pages for object "echocardiography".DBCC results for 'apldgr'.There are 0 rows in 1 pages for object "apldgr".DBCC results for 'mscresultcateg'.There are 153 rows in 6 pages for object "mscresultcateg".DBCC results for 'bloodchemistry04temp'.There are 0 rows in 0 pages for object "bloodchemistry04temp".DBCC results for 'radfilmmstr'.There are 0 rows in 0 pages for object "radfilmmstr".DBCC results for 'dailyrevenuetemp'.There are 0 rows in 0 pages for object "dailyrevenuetemp".DBCC results for 'urinalysisvmmc'.There are 2 rows in 1 pages for object "urinalysisvmmc".DBCC results for 'mmmc_dischinstruct'.There are 0 rows in 0 pages for object "mmmc_dischinstruct".DBCC results for 'microbiologyvmmcchild'.There are 0 rows in 0 pages for object "microbiologyvmmcchild".DBCC results for 'smc_serologytemp'.There are 0 rows in 0 pages for object "smc_serologytemp".DBCC results for 'cmapplven'.There are 0 rows in 0 pages for object "cmapplven".DBCC results for 'poitem'.There are 0 rows in 1 pages for object "poitem".DBCC results for 'psh_ultra'.There are 0 rows in 0 pages for object "psh_ultra".DBCC results for 'mscopdservice'.There are 0 rows in 0 pages for object "mscopdservice".DBCC results for 'peripheralarterialvmmc'.There are 0 rows in 0 pages for object "peripheralarterialvmmc".DBCC results for 'hivtest'.There are 0 rows in 0 pages for object "hivtest".DBCC results for 'upperendoscopyvmmc'.There are 0 rows in 0 pages for object "upperendoscopyvmmc".DBCC results for 'itemtmpdetails'.There are 0 rows in 1 pages for object "itemtmpdetails".DBCC results for 'exm_abg'.There are 0 rows in 0 pages for object "exm_abg".DBCC results for 'surgicalproc'.There are 0 rows in 0 pages for object "surgicalproc".DBCC results for 'exm_histopath'.There are 0 rows in 0 pages for object "exm_histopath".DBCC results for 'diagnostic_arteriallower'.There are 0 rows in 0 pages for object "diagnostic_arteriallower".DBCC results for 'hosppl'.There are 0 rows in 0 pages for object "hosppl".DBCC results for 'exm_2dechotemp'.There are 0 rows in 0 pages for object "exm_2dechotemp".DBCC results for 'orrecord'.There are 0 rows in 0 pages for object "orrecord".DBCC results for 'mscreferrals'.There are 0 rows in 0 pages for object "mscreferrals".DBCC results for 'diettran'.There are 0 rows in 0 pages for object "diettran".DBCC results for 'patinv'.There are 23521 rows in 1951 pages for object "patinv".DBCC results for 'hospplan'.There are 6 rows in 1 pages for object "hospplan".DBCC results for 'rfroomclass'.There are 80 rows in 1 pages for object "rfroomclass".DBCC results for 'exm_bloodbank'.There are 31 rows in 3 pages for object "exm_bloodbank".DBCC results for 'bloodchemistry04'.There are 0 rows in 0 pages for object "bloodchemistry04".DBCC results for 'venousduplex'.There are 0 rows in 0 pages for object "venousduplex".DBCC results for 'chemistryii'.There are 0 rows in 0 pages for object "chemistryii".DBCC results for 'bdh_serumelectro'.There are 0 rows in 0 pages for object "bdh_serumelectro".DBCC results for 'bdh_abgtemp'.There are 0 rows in 0 pages for object "bdh_abgtemp".DBCC results for 'lismachine'.There are 1 rows in 1 pages for object "lismachine".DBCC results for 'exmbloodbankvmmc'.There are 0 rows in 0 pages for object "exmbloodbankvmmc".DBCC results for 'patledgersumm'.There are 1075 rows in 38 pages for object "patledgersumm".DBCC results for 'patfamilytree'.There are 0 rows in 0 pages for object "patfamilytree".DBCC results for 'mscfsgrp'.There are 5 rows in 1 pages for object "mscfsgrp".DBCC results for 'gntrledger'.There are 63 rows in 2 pages for object "gntrledger".DBCC results for 'packdealitem'.There are 0 rows in 1 pages for object "packdealitem".DBCC results for 'bdh_specialchemistry'.There are 0 rows in 0 pages for object "bdh_specialchemistry".DBCC results for 'urinechem'.There are 0 rows in 0 pages for object "urinechem".DBCC results for 'bankadj'.There are 0 rows in 0 pages for object "bankadj".DBCC results for 'alobinv'.There are 0 rows in 0 pages for object "alobinv".DBCC results for 'bloodgasvmmc'.There are 0 rows in 0 pages for object "bloodgasvmmc".DBCC results for 'holter'.There are 0 rows in 0 pages for object "holter".DBCC results for 'ortrandet'.There are 0 rows in 0 pages for object "ortrandet".DBCC results for 'tbperiodicsumm'.There are 0 rows in 0 pages for object "tbperiodicsumm".DBCC results for 'biochemistry'.There are 10 rows in 1 pages for object "biochemistry".DBCC results for 'mscallergylist'.There are 13 rows in 1 pages for object "mscallergylist".DBCC results for 'mscbarangay'.There are 0 rows in 1 pages for object "mscbarangay".DBCC results for 'mscdietmenu'.There are 0 rows in 0 pages for object "mscdietmenu".DBCC results for 'dctrledger'.There are 3134 rows in 131 pages for object "dctrledger".DBCC results for 'dietmenudtls'.There are 0 rows in 0 pages for object "dietmenudtls".DBCC results for 'ctscan'.There are 0 rows in 1 pages for object "ctscan".DBCC results for 'projitm'.There are 0 rows in 0 pages for object "projitm".DBCC results for 'adjhistory'.There are 0 rows in 0 pages for object "adjhistory".DBCC results for 'dctrrfitems'.There are 0 rows in 0 pages for object "dctrrfitems".DBCC results for 'assets'.There are 0 rows in 1 pages for object "assets".DBCC results for 'carotidduplexvmmc'.There are 0 rows in 0 pages for object "carotidduplexvmmc".DBCC results for 'mscservtype'.There are 13 rows in 1 pages for object "mscservtype".DBCC results for 'histmedicare'.There are 0 rows in 0 pages for object "histmedicare".DBCC results for 'icdsubclass'.There are 268 rows in 9 pages for object "icdsubclass".DBCC results for 'journaldepot'.There are 0 rows in 1 pages for object "journaldepot".DBCC results for 'mscnationality'.There are 23 rows in 1 pages for object "mscnationality".DBCC results for 'hematology02temp'.There are 0 rows in 0 pages for object "hematology02temp".DBCC results for 'dctrorders'.There are 0 rows in 0 pages for object "dctrorders".DBCC results for 'posub'.There are 0 rows in 1 pages for object "posub".DBCC results for 'glcostcenters'.There are 0 rows in 1 pages for object "glcostcenters".DBCC results for 'bloodbankvmmc'.There are 0 rows in 0 pages for object "bloodbankvmmc".DBCC results for 'mscroomclass'.There are 80 rows in 2 pages for object "mscroomclass".DBCC results for 'mscprovince'.There are 84 rows in 1 pages for object "mscprovince".DBCC results for 'bloodbankvmmcreact'.There are 0 rows in 0 pages for object "bloodbankvmmcreact".DBCC results for 'dctrsub'.There are 3128 rows in 70 pages for object "dctrsub".DBCC results for 'bacteriology01'.There are 0 rows in 0 pages for object "bacteriology01".DBCC results for 'appsysreports'.There are 13 rows in 1 pages for object "appsysreports".DBCC results for 'msccostcenters'.There are 0 rows in 1 pages for object "msccostcenters".DBCC results for 'pcgh_medico'.There are 0 rows in 0 pages for object "pcgh_medico".DBCC results for 'orfile'.There are 0 rows in 0 pages for object "orfile".DBCC results for 'wareitemcateg'.There are 0 rows in 1 pages for object "wareitemcateg".DBCC results for 'dctrsched'.There are 0 rows in 0 pages for object "dctrsched".DBCC results for 'mcrcta'.There are 0 rows in 0 pages for object "mcrcta".DBCC results for 'treadmilltemp'.There are 0 rows in 1 pages for object "treadmilltemp".DBCC results for 'exm_pathology'.There are 0 rows in 0 pages for object "exm_pathology".DBCC results for 'dlsu_semenalysis'.There are 0 rows in 0 pages for object "dlsu_semenalysis".DBCC results for 'dlsu_gynecology'.There are 0 rows in 0 pages for object "dlsu_gynecology".DBCC results for 'cvmstr'.There are 0 rows in 1 pages for object "cvmstr".DBCC results for 'mscsetupgl'.There are 0 rows in 0 pages for object "mscsetupgl".DBCC results for 'microbiologyvmmctemp'.There are 1 rows in 1 pages for object "microbiologyvmmctemp".DBCC results for 'referrals'.There are 0 rows in 0 pages for object "referrals".DBCC results for 'bloodchemistry06temp'.There are 0 rows in 0 pages for object "bloodchemistry06temp".DBCC results for 'exm_2Decho'.There are 8 rows in 1 pages for object "exm_2Decho".DBCC results for 'rtemplatedtls'.There are 0 rows in 0 pages for object "rtemplatedtls".DBCC results for 'bgh_stoolexamination'.There are 0 rows in 0 pages for object "bgh_stoolexamination".DBCC results for 'areaprice'.There are 0 rows in 0 pages for object "areaprice".DBCC results for 'mscbanks'.There are 14 rows in 1 pages for object "mscbanks".DBCC results for 'appsyscheckupdates'.There are 52 rows in 1 pages for object "appsyscheckupdates".DBCC results for 'consrepsetup'.There are 0 rows in 0 pages for object "consrepsetup".DBCC results for 'obstetric1st'.There are 0 rows in 0 pages for object "obstetric1st".DBCC results for 'gynecology01vmmc'.There are 0 rows in 0 pages for object "gynecology01vmmc".DBCC results for 'dlscmrb'.There are 0 rows in 0 pages for object "dlscmrb".DBCC results for 'gldtl'.There are 0 rows in 1 pages for object "gldtl".DBCC results for 'ancillarymaster'.There are 42 rows in 1 pages for object "ancillarymaster".DBCC results for 'itmprice'.There are 0 rows in 0 pages for object "itmprice".DBCC results for 'mscprintcateg'.There are 12 rows in 1 pages for object "mscprintcateg".DBCC results for 'lowerendoscopyvmmc'.There are 0 rows in 0 pages for object "lowerendoscopyvmmc".DBCC results for 'exm_bacteriology'.There are 0 rows in 1 pages for object "exm_bacteriology".DBCC results for 'warehousemaster'.There are 0 rows in 0 pages for object "warehousemaster".DBCC results for 'itemitm'.There are 0 rows in 1 pages for object "itemitm".DBCC results for 'serology04_temp'.There are 0 rows in 0 pages for object "serology04_temp".DBCC results for 'bdh_gynecology'.There are 0 rows in 0 pages for object "bdh_gynecology".DBCC results for 'mscGrpResType'.There are 0 rows in 0 pages for object "mscGrpResType".DBCC results for 'mscbilltemplate'.There are 38 rows in 1 pages for object "mscbilltemplate".DBCC results for 'apappl'.There are 0 rows in 0 pages for object "apappl".DBCC results for 'bloodchemspecial'.There are 0 rows in 0 pages for object "bloodchemspecial".DBCC results for 'rch_peripheral'.There are 0 rows in 0 pages for object "rch_peripheral".DBCC results for 'mscpersonnelcateg'.There are 20 rows in 1 pages for object "mscpersonnelcateg".DBCC results for 'petty'.There are 0 rows in 1 pages for object "petty".DBCC results for 'mmmc_dse'.There are 0 rows in 0 pages for object "mmmc_dse".DBCC results for 'resulttype'.There are 0 rows in 0 pages for object "resulttype".DBCC results for 'companyresult'.There are 0 rows in 0 pages for object "companyresult".DBCC results for 'packdealmstr'.There are 0 rows in 1 pages for object "packdealmstr".DBCC results for 'msccustclass'.There are 16 rows in 1 pages for object "msccustclass".DBCC results for 'immunology'.There are 0 rows in 1 pages for object "immunology".DBCC results for 'admission'.There are 1086 rows in 151 pages for object "admission".DBCC results for 'immunologytemp'.There are 0 rows in 0 pages for object "immunologytemp".DBCC results for 'mmmcSbrRooms'.There are 0 rows in 0 pages for object "mmmcSbrRooms".DBCC results for 'patsalesdtls'.There are 0 rows in 1 pages for object "patsalesdtls".DBCC results for 'cvpay'.There are 0 rows in 1 pages for object "cvpay".DBCC results for 'mscitemgroup'.There are 0 rows in 0 pages for object "mscitemgroup".DBCC results for 'diagnostic_studyno'.There are 0 rows in 0 pages for object "diagnostic_studyno".DBCC results for 'ultrasound'.There are 0 rows in 1 pages for object "ultrasound".DBCC results for 'resulttypedest'.There are 0 rows in 0 pages for object "resulttypedest".DBCC results for 'immunology03temp'.There are 0 rows in 0 pages for object "immunology03temp".DBCC results for 'urinechemtemp'.There are 0 rows in 0 pages for object "urinechemtemp".DBCC results for 'msccurrsub'.There are 6 rows in 1 pages for object "msccurrsub".DBCC results for 'mscrelation'.There are 20 rows in 1 pages for object "mscrelation".DBCC results for 'exm_microbiology'.There are 0 rows in 0 pages for object "exm_microbiology".DBCC results for 'agent'.There are 0 rows in 0 pages for object "agent".DBCC results for 'gntrsub'.There are 64 rows in 2 pages for object "gntrsub".DBCC results for 'itemldgr'.Repair: The Nonclustered index successfully rebuilt for the object "dbo.itemldgr, deptid" in database "smartapp".Repair: The page (1:38301) has been deallocated from object ID 1548584605, index ID 6, partition ID 72057594080985088, alloc unit ID 72057594088914944 (type In-row data).Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1548584605, index ID 6 will be rebuilt. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1548584605, index ID 6, partition ID 72057594080985088, alloc unit ID 72057594088914944 (type In-row data). Page (1:15065) is missing a reference from previous page (1:38301). Possible chain linkage problem. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1548584605, index ID 6, partition ID 72057594080985088, alloc unit ID 72057594088914944 (type In-row data): Page (1:38301) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1548584605, index ID 6, partition ID 72057594080985088, alloc unit ID 72057594088914944 (type In-row data). Page (1:38301) was not seen in the scan although its parent (1:22328) and previous (1:4761) refer to it. Check any previous errors. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1548584605, index ID 6, partition ID 72057594080985088, alloc unit ID 72057594088914944 (type In-row data), page (1:38301), row 65. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2392 and 14. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1548584605, index ID 6, partition ID 72057594080985088, alloc unit ID 72057594088914944 (type In-row data), page (1:38301), row 65. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2392 and 14. The error has been repaired.There are 39458 rows in 1146 pages for object "itemldgr".CHECKDB found 0 allocation errors and 5 consistency errors in table 'itemldgr' (object ID 1548584605).CHECKDB fixed 0 allocation errors and 5 consistency errors in table 'itemldgr' (object ID 1548584605).DBCC results for 'mscsetup'.There are 1 rows in 1 pages for object "mscsetup".DBCC results for 'hematologyexamtemp'.There are 0 rows in 0 pages for object "hematologyexamtemp".DBCC results for 'rfap'.There are 0 rows in 0 pages for object "rfap".DBCC results for 'patsalesjrnldtls'.There are 0 rows in 1 pages for object "patsalesjrnldtls".DBCC results for 'pediatric'.There are 0 rows in 0 pages for object "pediatric".DBCC results for 'mscitemclass'.There are 113 rows in 3 pages for object "mscitemclass".DBCC results for 'mscdatagroup'.There are 6 rows in 1 pages for object "mscdatagroup".DBCC results for 'urinalysis'.There are 0 rows in 0 pages for object "urinalysis".DBCC results for 'jvdtl'.There are 0 rows in 1 pages for object "jvdtl".DBCC results for 'dlsu_obstetric23'.There are 0 rows in 0 pages for object "dlsu_obstetric23".DBCC results for 'mcinv'.There are 0 rows in 0 pages for object "mcinv".DBCC results for 'reports'.There are 0 rows in 0 pages for object "reports".DBCC results for 'reqitem'.There are 0 rows in 0 pages for object "reqitem".DBCC results for 'ordtls'.There are 0 rows in 1 pages for object "ordtls".DBCC results for 'msctypeofdeath'.There are 10 rows in 1 pages for object "msctypeofdeath".DBCC results for 'mscdocpic'.There are 0 rows in 0 pages for object "mscdocpic".DBCC results for 'hematology'.There are 0 rows in 0 pages for object "hematology".DBCC results for 'fecalysis'.There are 2 rows in 1 pages for object "fecalysis".DBCC results for 'mscadjclass'.There are 0 rows in 1 pages for object "mscadjclass".DBCC results for 'customer'.There are 239 rows in 7 pages for object "customer".DBCC results for 'osinv'.There are 0 rows in 0 pages for object "osinv".DBCC results for 'mcpayment'.There are 0 rows in 0 pages for object "mcpayment".DBCC results for 'smc_chemistry'.There are 0 rows in 0 pages for object "smc_chemistry".DBCC results for 'markuphistory'.There are 0 rows in 0 pages for object "markuphistory".DBCC results for 'mcremittran'.There are 0 rows in 0 pages for object "mcremittran".DBCC results for 'mri'.There are 0 rows in 0 pages for object "mri".DBCC results for 'mritemp'.There are 0 rows in 0 pages for object "mritemp".DBCC results for 'jvpatdtls'.There are 0 rows in 1 pages for object "jvpatdtls".DBCC results for 'subservicetype'.There are 33 rows in 1 pages for object "subservicetype".DBCC results for 'custacti'.There are 0 rows in 0 pages for object "custacti".DBCC results for 'gynecology02vmmc'.There are 0 rows in 0 pages for object "gynecology02vmmc".DBCC results for 'pettygl'.There are 0 rows in 0 pages for object "pettygl".DBCC results for 'netrefund'.There are 0 rows in 1 pages for object "netrefund".DBCC results for 'roomtrans'.There are 242 rows in 6 pages for object "roomtrans".DBCC results for 'exm_bacteriologychild'.There are 0 rows in 0 pages for object "exm_bacteriologychild".DBCC results for 'antibiotics'.There are 0 rows in 0 pages for object "antibiotics".DBCC results for 'bdh_spermanalysis'.There are 0 rows in 0 pages for object "bdh_spermanalysis".DBCC results for 'appsyspclevel'.There are 152 rows in 3 pages for object "appsyspclevel".DBCC results for 'mscrooms'.There are 81 rows in 2 pages for object "mscrooms".DBCC results for 'chemistryhba1ctemp'.There are 0 rows in 0 pages for object "chemistryhba1ctemp".DBCC results for 'pfgntrpayment'.There are 0 rows in 0 pages for object "pfgntrpayment".DBCC results for 'mscdiscounttype'.There are 0 rows in 1 pages for object "mscdiscounttype".DBCC results for 'phentinv'.There are 0 rows in 1 pages for object "phentinv".DBCC results for 'hij_dcr'.There are 0 rows in 0 pages for object "hij_dcr".DBCC results for 'msccurrency'.There are 1 rows in 1 pages for object "msccurrency".DBCC results for 'echocardiographytemp'.There are 0 rows in 0 pages for object "echocardiographytemp".DBCC results for 'mscdocrep'.There are 83 rows in 2 pages for object "mscdocrep".DBCC results for 'bronchoscopyvmmc'.There are 0 rows in 0 pages for object "bronchoscopyvmmc".DBCC results for 'gntrhospbilldtls'.There are 86 rows in 1 pages for object "gntrhospbilldtls".DBCC results for 'aritem'.There are 0 rows in 0 pages for object "aritem".DBCC results for 'serology02'.There are 0 rows in 0 pages for object "serology02".DBCC results for 'admdctrledger'.There are 968 rows in 24 pages for object "admdctrledger".DBCC results for 'serologyvmmc'.There are 2 rows in 1 pages for object "serologyvmmc".DBCC results for 'argl'.There are 0 rows in 1 pages for object "argl".DBCC results for 'itempricescheme'.There are 0 rows in 0 pages for object "itempricescheme".DBCC results for 'hospchargecashtemp'.There are 0 rows in 0 pages for object "hospchargecashtemp".DBCC results for 'smc_serology'.There are 0 rows in 0 pages for object "smc_serology".DBCC results for 'psh_ultra23'.There are 0 rows in 0 pages for object "psh_ultra23".DBCC results for 'exmbiochemistrytemp'.There are 0 rows in 0 pages for object "exmbiochemistrytemp".DBCC results for 'orseries'.There are 8 rows in 1 pages for object "orseries".DBCC results for 'whitem'.There are 0 rows in 1 pages for object "whitem".DBCC results for 'patpaymstr'.There are 1307 rows in 54 pages for object "patpaymstr".DBCC results for 'immunology03'.There are 0 rows in 0 pages for object "immunology03".DBCC results for 'mscpricescheme'.There are 11 rows in 1 pages for object "mscpricescheme".DBCC results for 'setupgl'.There are 0 rows in 0 pages for object "setupgl".DBCC results for 'msccards'.There are 4 rows in 1 pages for object "msccards".DBCC results for 'radfilmitem'.There are 0 rows in 0 pages for object "radfilmitem".DBCC results for 'prevyr'.There are 0 rows in 0 pages for object "prevyr".DBCC results for 'whreqinv'.There are 0 rows in 1 pages for object "whreqinv".DBCC results for 'mscsbr'.There are 0 rows in 0 pages for object "mscsbr".DBCC results for 'userdept'.There are 7 rows in 1 pages for object "userdept".DBCC results for 'bdh_cytology'.There are 0 rows in 0 pages for object "bdh_cytology".DBCC results for 'mscBranch'.There are 0 rows in 0 pages for object "mscBranch".DBCC results for 'mscsettletype'.There are 8 rows in 1 pages for object "mscsettletype".DBCC results for 'patrooms'.There are 3257 rows in 53 pages for object "patrooms".DBCC results for 'glacct'.There are 1257 rows in 18 pages for object "glacct".DBCC results for 'immunology04temp'.There are 0 rows in 0 pages for object "immunology04temp".DBCC results for 'mmmc_dischinstruct1'.There are 0 rows in 0 pages for object "mmmc_dischinstruct1".DBCC results for 'bdh_hearingcare'.There are 0 rows in 0 pages for object "bdh_hearingcare".DBCC results for 'trialend'.There are 0 rows in 0 pages for object "trialend".DBCC results for 'smc_chemistrytemp'.There are 0 rows in 0 pages for object "smc_chemistrytemp".DBCC results for 'mscpatclassification'.There are 24 rows in 1 pages for object "mscpatclassification".DBCC results for 'mscmctemplate'.There are 35 rows in 1 pages for object "mscmctemplate".DBCC results for 'mscGroup'.There are 0 rows in 0 pages for object "mscGroup".DBCC results for 'nuclearimagingvmmc'.There are 0 rows in 0 pages for object "nuclearimagingvmmc".DBCC results for 'patledger'.Repair: The Clustered index successfully rebuilt for the object "dbo.patledger" in database "smartapp".Repair: The page (1:28827) has been deallocated from object ID 1869353824, index ID 1, partition ID 72057594133807104, alloc unit ID 72057594147110912 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, PK_patledger_1" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, acctcode" in database "smartapp".Repair: The page (1:12138) has been deallocated from object ID 1869353824, index ID 3, partition ID 72057594133938176, alloc unit ID 72057594147241984 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, canceldate" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, csnum" in database "smartapp".Repair: The page (1:11249) has been deallocated from object ID 1869353824, index ID 5, partition ID 72057594134069248, alloc unit ID 72057594147373056 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, ctrlno" in database "smartapp".Repair: The page (1:11257) has been deallocated from object ID 1869353824, index ID 6, partition ID 72057594134134784, alloc unit ID 72057594147438592 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, dcno" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, docno" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, doctype" in database "smartapp".Repair: The page (1:28128) has been deallocated from object ID 1869353824, index ID 9, partition ID 72057594134331392, alloc unit ID 72057594147635200 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, gntrdcno" in database "smartapp".Repair: The page (1:32324) has been deallocated from object ID 1869353824, index ID 10, partition ID 72057594134396928, alloc unit ID 72057594147700736 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, netrefdate" in database "smartapp".Repair: The page (1:11273) has been deallocated from object ID 1869353824, index ID 11, partition ID 72057594134462464, alloc unit ID 72057594147766272 (type In-row data).Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, orno" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, pattranno" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, pattrantype" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, trackno" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, trancode" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, trandate" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, trantype" in database "smartapp".Repair: The Nonclustered index successfully rebuilt for the object "dbo.patledger, warecode" in database "smartapp".Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 1 will be rebuilt. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 1, partition ID 72057594133807104, alloc unit ID 72057594147110912 (type In-row data). Page (1:10517) is missing a reference from previous page (1:28827). Possible chain linkage problem. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 1, partition ID 72057594133807104, alloc unit ID 72057594147110912 (type In-row data): Page (1:28827) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 1, partition ID 72057594133807104, alloc unit ID 72057594147110912 (type In-row data). Page (1:28827) was not seen in the scan although its parent (1:17870) and previous (1:4853) refer to it. Check any previous errors. The error has been repaired.Msg 8944, Level 16, State 17, Line 1Table error: Object ID 1869353824, index ID 1, partition ID 72057594133807104, alloc unit ID 72057594147110912 (type In-row data), page (1:28827), row 9. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 210 and 161. The error has been repaired.Msg 8944, Level 16, State 17, Line 1Table error: Object ID 1869353824, index ID 1, partition ID 72057594133807104, alloc unit ID 72057594147110912 (type In-row data), page (1:28827), row 9. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 210 and 161. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 2 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 3 will be rebuilt. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 3, partition ID 72057594133938176, alloc unit ID 72057594147241984 (type In-row data): Page (1:12138) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 3, partition ID 72057594133938176, alloc unit ID 72057594147241984 (type In-row data). Page (1:12138) was not seen in the scan although its parent (1:22330) and previous (1:44889) refer to it. Check any previous errors. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1869353824, index ID 3, partition ID 72057594133938176, alloc unit ID 72057594147241984 (type In-row data), page (1:12138), row 92. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2324 and 14. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1869353824, index ID 3, partition ID 72057594133938176, alloc unit ID 72057594147241984 (type In-row data), page (1:12138), row 92. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2324 and 14. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 3, partition ID 72057594133938176, alloc unit ID 72057594147241984 (type In-row data). Page (1:37746) is missing a reference from previous page (1:12138). Possible chain linkage problem. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 4 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 5 will be rebuilt. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 5, partition ID 72057594134069248, alloc unit ID 72057594147373056 (type In-row data): Page (1:11249) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 5, partition ID 72057594134069248, alloc unit ID 72057594147373056 (type In-row data). Page (1:11249) was not seen in the scan although its parent (1:20852) and previous (1:35488) refer to it. Check any previous errors. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1869353824, index ID 5, partition ID 72057594134069248, alloc unit ID 72057594147373056 (type In-row data), page (1:11249), row 50. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2679 and 18. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1869353824, index ID 5, partition ID 72057594134069248, alloc unit ID 72057594147373056 (type In-row data), page (1:11249), row 50. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2679 and 18. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 5, partition ID 72057594134069248, alloc unit ID 72057594147373056 (type In-row data). Page (1:32792) is missing a reference from previous page (1:11249). Possible chain linkage problem. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 6 will be rebuilt. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 6, partition ID 72057594134134784, alloc unit ID 72057594147438592 (type In-row data): Page (1:11257) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 6, partition ID 72057594134134784, alloc unit ID 72057594147438592 (type In-row data). Page (1:11257) was not seen in the scan although its parent (1:21020) and previous (1:35576) refer to it. Check any previous errors. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1869353824, index ID 6, partition ID 72057594134134784, alloc unit ID 72057594147438592 (type In-row data), page (1:11257), row 52. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2903 and 18. The error has been repaired.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 1869353824, index ID 6, partition ID 72057594134134784, alloc unit ID 72057594147438592 (type In-row data), page (1:11257), row 52. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2903 and 18. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 6, partition ID 72057594134134784, alloc unit ID 72057594147438592 (type In-row data). Page (1:32800) is missing a reference from previous page (1:11257). Possible chain linkage problem. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 7 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 8 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 9 will be rebuilt. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 9, partition ID 72057594134331392, alloc unit ID 72057594147635200 (type In-row data). Page (1:4734) is missing a reference from previous page (1:28128). Possible chain linkage problem. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 9, partition ID 72057594134331392, alloc unit ID 72057594147635200 (type In-row data): Page (1:28128) could not be processed. See other errors for details. The error has been repaired.Msg 8939, Level 16, State 8, Line 1Table error: Object ID 1869353824, index ID 9, partition ID 72057594134331392, alloc unit ID 72057594147635200 (type In-row data), page (1:28128). Test (m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 10828 and 8096. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 9, partition ID 72057594134331392, alloc unit ID 72057594147635200 (type In-row data). Page (1:28128) was not seen in the scan although its parent (1:21741) and previous (1:10209) refer to it. Check any previous errors. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 10 will be rebuilt. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 10, partition ID 72057594134396928, alloc unit ID 72057594147700736 (type In-row data). Page (1:11265) is missing a reference from previous page (1:32324). Possible chain linkage problem. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 10, partition ID 72057594134396928, alloc unit ID 72057594147700736 (type In-row data): Page (1:32324) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 10, partition ID 72057594134396928, alloc unit ID 72057594147700736 (type In-row data). Page (1:32324) was not seen in the scan although its parent (1:21827) and previous (1:10179) refer to it. Check any previous errors. The error has been repaired.Msg 8944, Level 16, State 12, Line 1Table error: Object ID 1869353824, index ID 10, partition ID 72057594134396928, alloc unit ID 72057594147700736 (type In-row data), page (1:32324), row 268. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 15 and 10. The error has been repaired.Msg 8944, Level 16, State 12, Line 1Table error: Object ID 1869353824, index ID 10, partition ID 72057594134396928, alloc unit ID 72057594147700736 (type In-row data), page (1:32324), row 268. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 15 and 10. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 11 will be rebuilt. The error has been repaired.Msg 8928, Level 16, State 1, Line 1Object ID 1869353824, index ID 11, partition ID 72057594134462464, alloc unit ID 72057594147766272 (type In-row data): Page (1:11273) could not be processed. See other errors for details. The error has been repaired.Msg 8939, Level 16, State 7, Line 1Table error: Object ID 1869353824, index ID 11, partition ID 72057594134462464, alloc unit ID 72057594147766272 (type In-row data), page (1:11273). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 17062 and 7680. The error has been repaired.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 11, partition ID 72057594134462464, alloc unit ID 72057594147766272 (type In-row data). Page (1:11273) was not seen in the scan although its parent (1:21875) and previous (1:35496) refer to it. Check any previous errors. The error has been repaired.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 11, partition ID 72057594134462464, alloc unit ID 72057594147766272 (type In-row data). Page (1:32816) is missing a reference from previous page (1:11273). Possible chain linkage problem. The error has been repaired.Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 11, partition ID 72057594134462464, alloc unit ID 72057594147766272 (type In-row data). Keys out of order on page (1:51793), slots 101 and 102. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 12 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 13 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 14 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 15 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 16 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 17 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 18 will be rebuilt. The error has been repaired.Msg 8945, Level 16, State 1, Line 1Table error: Object ID 1869353824, index ID 19 will be rebuilt. The error has been repaired.There are 30842 rows in 945 pages for object "patledger".CHECKDB found 0 allocation errors and 34 consistency errors in table 'patledger' (object ID 1869353824).CHECKDB fixed 0 allocation errors and 34 consistency errors in table 'patledger' (object ID 1869353824).DBCC results for 'mscPhicCasetype'.There are 18 rows in 1 pages for object "mscPhicCasetype".DBCC results for 'bgh_hematologytemp'.There are 0 rows in 0 pages for object "bgh_hematologytemp".DBCC results for 'bdh_spobstetric'.There are 0 rows in 0 pages for object "bdh_spobstetric".DBCC results for 'radiologytemp'.There are 25 rows in 1 pages for object "radiologytemp".DBCC results for 'bdh_abg'.There are 0 rows in 0 pages for object "bdh_abg".DBCC results for 'dritem'.There are 0 rows in 0 pages for object "dritem".DBCC results for 'bdh_serumelectrotemp'.There are 0 rows in 0 pages for object "bdh_serumelectrotemp".DBCC results for 'mcm_papsmear'.There are 0 rows in 0 pages for object "mcm_papsmear".DBCC results for 'mscglphiccateg'.There are 302 rows in 4 pages for object "mscglphiccateg".DBCC results for 'mscHospitals'.There are 0 rows in 0 pages for object "mscHospitals".DBCC results for 'pfpayment'.There are 0 rows in 0 pages for object "pfpayment".DBCC results for 'addrmstr'.There are 3463 rows in 281 pages for object "addrmstr".DBCC results for 'rch_histopath'.There are 0 rows in 0 pages for object "rch_histopath".DBCC results for 'bdh_pathologytemp'.There are 0 rows in 0 pages for object "bdh_pathologytemp".DBCC results for 'whinv'.There are 0 rows in 1 pages for object "whinv".DBCC results for 'radioimmunoassayvmmc'.There are 0 rows in 0 pages for object "radioimmunoassayvmmc".DBCC results for 'itemizedgntrdtls'.There are 0 rows in 0 pages for object "itemizedgntrdtls".DBCC results for 'custprod'.There are 0 rows in 0 pages for object "custprod".DBCC results for 'deathcertrecord'.There are 0 rows in 0 pages for object "deathcertrecord".DBCC results for 'labsections'.There are 30 rows in 1 pages for object "labsections".DBCC results for 'mscnrstation'.There are 4 rows in 1 pages for object "mscnrstation".DBCC results for 'drinv'.There are 0 rows in 0 pages for object "drinv".DBCC results for 'exm_spermanalysis'.There are 0 rows in 0 pages for object "exm_spermanalysis".DBCC results for 'appsysquotes'.There are 0 rows in 0 pages for object "appsysquotes".DBCC results for 'arldgrtemp'.There are 0 rows in 0 pages for object "arldgrtemp".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for 'surgicalpathologyvmmc'.There are 0 rows in 0 pages for object "surgicalpathologyvmmc".DBCC results for 'mscproccateg'.There are 0 rows in 0 pages for object "mscproccateg".DBCC results for 'patfinalicd'.There are 546 rows in 5 pages for object "patfinalicd".DBCC results for 'reminders'.There are 1 rows in 1 pages for object "reminders".DBCC results for 'mscreligion'.There are 27 rows in 1 pages for object "mscreligion".DBCC results for 'serology04'.There are 0 rows in 0 pages for object "serology04".DBCC results for 'obstetric2nd'.There are 0 rows in 0 pages for object "obstetric2nd".DBCC results for 'assembly'.There are 0 rows in 0 pages for object "assembly".DBCC results for 'msccountry'.There are 120 rows in 1 pages for object "msccountry".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for 'appsysconfig'.There are 1 rows in 1 pages for object "appsysconfig".DBCC results for 'pcgh_medimage'.There are 0 rows in 0 pages for object "pcgh_medimage".DBCC results for 'mscempfile'.There are 0 rows in 0 pages for object "mscempfile".DBCC results for 'rebates'.There are 0 rows in 0 pages for object "rebates".DBCC results for 'reqinv'.There are 0 rows in 0 pages for object "reqinv".DBCC results for 'bdh_clinmicroscopy'.There are 0 rows in 0 pages for object "bdh_clinmicroscopy".DBCC results for 'PatientResult'.There are 0 rows in 0 pages for object "PatientResult".DBCC results for 'collfu'.There are 0 rows in 0 pages for object "collfu".DBCC results for 'phentitem'.There are 0 rows in 1 pages for object "phentitem".DBCC results for 'quoteinv'.There are 0 rows in 0 pages for object "quoteinv".DBCC results for 'assetsdet'.There are 0 rows in 1 pages for object "assetsdet".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'packdealtran'.There are 0 rows in 1 pages for object "packdealtran".DBCC results for 'chemistryhba1c'.There are 0 rows in 0 pages for object "chemistryhba1c".DBCC results for 'jvtdtl'.There are 0 rows in 0 pages for object "jvtdtl".DBCC results for 'cytopathologyvmmc'.There are 0 rows in 0 pages for object "cytopathologyvmmc".DBCC results for 'mscdiscountservice'.There are 0 rows in 1 pages for object "mscdiscountservice".DBCC results for 'bdh_obstetric23'.There are 0 rows in 0 pages for object "bdh_obstetric23".DBCC results for 'seriesdocno'.There are 200 rows in 2 pages for object "seriesdocno".DBCC results for 'mscwarehouse'.There are 200 rows in 11 pages for object "mscwarehouse".DBCC results for 'nvtemplatedet'.There are 989 rows in 72 pages for object "nvtemplatedet".DBCC results for 'drsub'.There are 0 rows in 0 pages for object "drsub".DBCC results for 'parasitology'.There are 0 rows in 0 pages for object "parasitology".DBCC results for 'transudate'.There are 0 rows in 0 pages for object "transudate".DBCC results for 'bdh_specialchemistrytemp'.There are 0 rows in 0 pages for object "bdh_specialchemistrytemp".DBCC results for 'serology03'.There are 0 rows in 0 pages for object "serology03".DBCC results for 'appsysrepoptions'.There are 43 rows in 1 pages for object "appsysrepoptions".DBCC results for 'bdh_pathology'.There are 0 rows in 0 pages for object "bdh_pathology".DBCC results for 'venousduplexvmmc'.There are 0 rows in 0 pages for object "venousduplexvmmc".DBCC results for 'patdiscount'.There are 233 rows in 2 pages for object "patdiscount".DBCC results for 'mscarea'.There are 1982 rows in 10 pages for object "mscarea".DBCC results for 'mcappl'.There are 0 rows in 0 pages for object "mcappl".CHECKDB found 0 allocation errors and 39 consistency errors in database 'smartapp'.CHECKDB fixed 0 allocation errors and 39 consistency errors in database 'smartapp'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Result msg for REPAIR_REBUILDDBCC results for 'smartapp'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.DBCC results for 'sys.sysrowsetcolumns'.There are 21765 rows in 173 pages for object "sys.sysrowsetcolumns".DBCC results for 'sys.sysrowsets'.There are 1798 rows in 13 pages for object "sys.sysrowsets".DBCC results for 'sysallocunits'.There are 2018 rows in 24 pages for object "sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syshobtcolumns'.There are 21765 rows in 197 pages for object "sys.syshobtcolumns".DBCC results for 'sys.syshobts'.There are 1798 rows in 13 pages for object "sys.syshobts".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysserefs'.There are 2018 rows in 10 pages for object "sys.sysserefs".DBCC results for 'sys.sysowners'.There are 14 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 134 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 10227 rows in 218 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.There are 18121 rows in 315 pages for object "sys.syscolpars".DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysxprops'.There are 10 rows in 1 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 27 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 4068 rows in 74 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 4115 rows in 32 pages for object "sys.sysiscols".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysobjvalues'.There are 13207 rows in 829 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 15 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 140 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 191 rows in 1 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysdbfiles'.There are 2 rows in 1 pages for object "sys.sysdbfiles".DBCC results for 'sys.sysguidrefs'.There are 1 rows in 1 pages for object "sys.sysguidrefs".DBCC results for 'sys.sysqnames'.There are 91 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 93 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 97 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 17 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 0 rows in 0 pages for object "sys.sysbinsubobjs".DBCC results for 'bloodchemistrytemp'.There are 0 rows in 0 pages for object "bloodchemistrytemp".DBCC results for 'projinv'.There are 0 rows in 0 pages for object "projinv".DBCC results for 'exm_urinalysis'.There are 0 rows in 0 pages for object "exm_urinalysis".DBCC results for 'msctrantype'.There are 43 rows in 2 pages for object "msctrantype".DBCC results for 'mcitem'.There are 0 rows in 0 pages for object "mcitem".DBCC results for 'auditsys'.There are 6700 rows in 233 pages for object "auditsys".DBCC results for 'issitem'.There are 0 rows in 1 pages for object "issitem".DBCC results for 'appsysverses'.There are 3 rows in 1 pages for object "appsysverses".DBCC results for 'ordiscdtls'.There are 0 rows in 0 pages for object "ordiscdtls".DBCC results for 'ultrasoundtemp'.There are 0 rows in 1 pages for object "ultrasoundtemp".DBCC results for 'itemtmpmaster'.There are 1 rows in 1 pages for object "itemtmpmaster".DBCC results for 'cvdtls'.There are 0 rows in 1 pages for object "cvdtls".DBCC results for 'itemldgrdepot'.There are 0 rows in 0 pages for object "itemldgrdepot".DBCC results for 'bankrecontemp'.There are 0 rows in 1 pages for object "bankrecontemp".DBCC results for 'dlsu_vitros'.There are 0 rows in 0 pages for object "dlsu_vitros".DBCC results for 'mschosprelate'.There are 0 rows in 1 pages for object "mschosprelate".DBCC results for 'smc_microscopy'.There are 0 rows in 0 pages for object "smc_microscopy".DBCC results for 'bloodchemistry05'.There are 0 rows in 0 pages for object "bloodchemistry05".DBCC results for 'supavitm'.There are 0 rows in 0 pages for object "supavitm".DBCC results for 'bloodchemistry06'.There are 0 rows in 0 pages for object "bloodchemistry06".DBCC results for 'ormstr'.There are 299 rows in 15 pages for object "ormstr".DBCC results for 'mcledger'.There are 455 rows in 143 pages for object "mcledger".DBCC results for 'wareitem'.There are 2603 rows in 69 pages for object "wareitem".DBCC results for 'hematologytempvmmc'.There are 0 rows in 0 pages for object "hematologytempvmmc".DBCC results for 'quoteitm'.There are 0 rows in 0 pages for object "quoteitm".DBCC results for 'mscphicmembership'.There are 18 rows in 1 pages for object "mscphicmembership".DBCC results for 'appsysrepfiles'.There are 324 rows in 19 pages for object "appsysrepfiles".DBCC results for 'mscdctrdept'.There are 0 rows in 0 pages for object "mscdctrdept".DBCC results for 'bdh_obstetric1'.There are 0 rows in 0 pages for object "bdh_obstetric1".DBCC results for 'performancetrace'.There are 0 rows in 0 pages for object "performancetrace".DBCC results for 'serology01'.There are 0 rows in 0 pages for object "serology01".DBCC results for 'datacenter'.There are 1602 rows in 119 pages for object "datacenter".DBCC results for 'ortranpatinv'.There are 0 rows in 0 pages for object "ortranpatinv".DBCC results for 'hematologyvmmc'.There are 10 rows in 1 pages for object "hematologyvmmc".DBCC results for 'profilersql'.There are 0 rows in 0 pages for object "profilersql".DBCC results for 'mscmodepay'.There are 5 rows in 1 pages for object "mscmodepay".DBCC results for 'immunology02temp'.There are 0 rows in 0 pages for object "immunology02temp".DBCC results for 'immunology04'.There are 0 rows in 0 pages for object "immunology04".DBCC results for 'audittrail'.There are 22819 rows in 617 pages for object "audittrail".DBCC results for 'hematologyexam'.There are 0 rows in 0 pages for object "hematologyexam".DBCC results for 'immunology01'.There are 0 rows in 0 pages for object "immunology01".DBCC results for 'roomclass'.There are 0 rows in 0 pages for object "roomclass".DBCC results for 'msctrangroup'.There are 18 rows in 1 pages for object "msctrangroup".DBCC results for 'nvtemplate'.There are 28 rows in 3 pages for object "nvtemplate".DBCC results for 'mmmc_hmo_dr'.There are 0 rows in 0 pages for object "mmmc_hmo_dr".DBCC results for 'mschospsharetype'.There are 0 rows in 0 pages for object "mschospsharetype".DBCC results for 'rooms'.There are 0 rows in 0 pages for object "rooms".DBCC results for 'ResultImages'.There are 0 rows in 0 pages for object "ResultImages".DBCC results for 'mscdisctype'.There are 22 rows in 1 pages for object "mscdisctype".DBCC results for 'mscdiscordinance'.There are 0 rows in 0 pages for object "mscdiscordinance".DBCC results for 'arcost'.There are 0 rows in 0 pages for object "arcost".DBCC results for 'exm_ape'.There are 0 rows in 0 pages for object "exm_ape".DBCC results for 'ositem'.There are 0 rows in 0 pages for object "ositem".DBCC results for 'mscitemcateg'.There are 44 rows in 1 pages for object "mscitemcateg".DBCC results for 'prdadjinv'.There are 0 rows in 0 pages for object "prdadjinv".DBCC results for 'supavinv'.There are 0 rows in 0 pages for object "supavinv".DBCC results for 'discordinance_child'.There are 0 rows in 0 pages for object "discordinance_child".DBCC results for 'lis_vitros'.There are 0 rows in 0 pages for object "lis_vitros".DBCC results for 'outpatient'.There are 13 rows in 4 pages for object "outpatient".DBCC results for 'jvmstr'.There are 0 rows in 1 pages for object "jvmstr".DBCC results for 'bdh_surgicalpath'.There are 0 rows in 0 pages for object "bdh_surgicalpath".DBCC results for 'sysdiagrams'.There are 0 rows in 0 pages for object "sysdiagrams".DBCC results for 'exm_bloodbankchild'.There are 0 rows in 0 pages for object "exm_bloodbankchild".DBCC results for 'budget'.There are 0 rows in 0 pages for object "budget".DBCC results for 'mcgta'.There are 0 rows in 0 pages for object "mcgta".DBCC results for 'serology03temp'.There are 0 rows in 0 pages for object "serology03temp".DBCC results for 'bloodchemspecialtemp'.There are 0 rows in 0 pages for object "bloodchemspecialtemp".DBCC results for 'radiology'.There are 1 rows in 1 pages for object "radiology".DBCC results for 'microbiologyvmmc'.There are 0 rows in 0 pages for object "microbiologyvmmc".DBCC results for 'patsalesmstr'.There are 0 rows in 1 pages for object "patsalesmstr".DBCC results for 'mscdosage'.There are 0 rows in 0 pages for object "mscdosage".DBCC results for 'bloodgasvmmctemp'.There are 0 rows in 0 pages for object "bloodgasvmmctemp".DBCC results for 'bdh_serology'.There are 0 rows in 0 pages for object "bdh_serology".DBCC results for 'mscewtcode'.There are 0 rows in 0 pages for object "mscewtcode".DBCC results for 'carotid'.There are 0 rows in 0 pages for object "carotid".DBCC results for 'hij_iaa'.There are 0 rows in 0 pages for object "hij_iaa".DBCC results for 'icdprimeclass'.There are 21 rows in 1 pages for object "icdprimeclass".DBCC results for 'mmmc_ecu'.There are 0 rows in 0 pages for object "mmmc_ecu".DBCC results for 'obcytopathology'.There are 0 rows in 0 pages for object "obcytopathology".DBCC results for 'exm_microscopy'.There are 358 rows in 58 pages for object "exm_microscopy".DBCC results for 'bmiref'.There are 0 rows in 0 pages for object "bmiref".DBCC results for 'msccaesariantype'.There are 0 rows in 0 pages for object "msccaesariantype".DBCC results for 'prinv'.There are 0 rows in 1 pages for object "prinv".DBCC results for 'bdh_cardiac'.There are 0 rows in 0 pages for object "bdh_cardiac".DBCC results for 'msccasetype'.There are 3 rows in 1 pages for object "msccasetype".DBCC results for 'patitemcomp'.There are 0 rows in 1 pages for object "patitemcomp".DBCC results for 'issinv'.There are 0 rows in 1 pages for object "issinv".DBCC results for 'whreqitm'.There are 0 rows in 1 pages for object "whreqitm".DBCC results for 'hivtesttemp'.There are 0 rows in 0 pages for object "hivtesttemp".DBCC results for 'prdadjitm'.There are 0 rows in 0 pages for object "prdadjitm".DBCC results for 'bdh_hematologytemp'.There are 0 rows in 0 pages for object "bdh_hematologytemp".DBCC results for 'his_lis'.There are 0 rows in 0 pages for object "his_lis".DBCC results for 'patledger2'.There are 0 rows in 72 pages for object "patledger2".DBCC results for 'icd10'.There are 13678 rows in 199 pages for object "icd10".DBCC results for 'diagnostic_abi'.There are 0 rows in 0 pages for object "diagnostic_abi".DBCC results for 'bdh_biophysical'.There are 0 rows in 0 pages for object "bdh_biophysical".DBCC results for 'poinv'.There are 0 rows in 1 pages for object "poinv".DBCC results for 'mscunits'.There are 42 rows in 1 pages for object "mscunits".DBCC results for 'glclass$'.There are 65 rows in 4 pages for object "glclass$".DBCC results for 'prepay'.There are 0 rows in 0 pages for object "prepay".DBCC results for 'bankrecondtls'.There are 0 rows in 1 pages for object "bankrecondtls".DBCC results for 'diagnostic_venous'.There are 0 rows in 0 pages for object "diagnostic_venous".DBCC results for 'bgh_bloodchemistrytemp'.There are 0 rows in 0 pages for object "bgh_bloodchemistrytemp".DBCC results for 'patitem'.There are 47997 rows in 3680 pages for object "patitem".DBCC results for 'rebatesdet'.There are 0 rows in 1 pages for object "rebatesdet".DBCC results for 'arterialduplex'.There are 0 rows in 0 pages for object "arterialduplex".DBCC results for 'diagnostic_carotid'.There are 0 rows in 0 pages for object "diagnostic_carotid".DBCC results for 'vendor'.There are 9 rows in 1 pages for object "vendor".DBCC results for 'arldgr'.There are 461 rows in 14 pages for object "arldgr".DBCC results for 'discmstr'.There are 234 rows in 7 pages for object "discmstr".DBCC results for 'diagnostic_arterialduplex'.There are 0 rows in 0 pages for object "diagnostic_arterialduplex".DBCC results for 'mscglsetup'.There are 1 rows in 1 pages for object "mscglsetup".DBCC results for 'jvtmstr'.There are 0 rows in 0 pages for object "jvtmstr".DBCC results for 'diagnostic_venouslower'.There are 0 rows in 0 pages for object "diagnostic_venouslower".DBCC results for 'iteminv'.There are 0 rows in 1 pages for object "iteminv".DBCC results for 'mscdept'.There are 80 rows in 1 pages for object "mscdept".DBCC results for 'bloodbanking'.There are 0 rows in 0 pages for object "bloodbanking".DBCC results for 'arinv'.There are 461 rows in 25 pages for object "arinv".DBCC results for 'invtyend'.There are 0 rows in 0 pages for object "invtyend".DBCC results for 'smc_bloodbank'.There are 0 rows in 0 pages for object "smc_bloodbank".DBCC results for 'psh_earlypreg'.There are 0 rows in 0 pages for object "psh_earlypreg".DBCC results for 'mmmc_cdrb'.There are 0 rows in 0 pages for object "mmmc_cdrb".DBCC results for 'miscellaneousvmmc'.There are 0 rows in 0 pages for object "miscellaneousvmmc".DBCC results for 'pcgh_sourceincome'.There are 0 rows in 0 pages for object "pcgh_sourceincome".DBCC results for 'exm_hematology'.There are 1103 rows in 104 pages for object "exm_hematology".DBCC results for 'sph_allergens'.There are 0 rows in 1 pages for object "sph_allergens".DBCC results for 'icdclasslevel3'.There are 2061 rows in 69 pages for object "icdclasslevel3".DBCC results for 'birthcertrecord'.There are 0 rows in 0 pages for object "birthcertrecord".DBCC results for 'prodinv'.There are 0 rows in 0 pages for object "prodinv".DBCC results for 'apinv'.There are 0 rows in 1 pages for object "apinv".DBCC results for 'pcgh_targetincome'.There are 0 rows in 0 pages for object "pcgh_targetincome".DBCC results for 'rch_ecg'.There are 0 rows in 0 pages for object "rch_ecg".DBCC results for 'mscdoclist'.There are 34 rows in 1 pages for object "mscdoclist".DBCC results for 'patient'.There are 1060 rows in 222 pages for object "patient".DBCC results for 'culturedet'.There are 0 rows in 0 pages for object "culturedet".DBCC results for 'mscdietlist'.There are 64 rows in 1 pages for object "mscdietlist".DBCC results for 'localizecaption'.There are 0 rows in 0 pages for object "localizecaption".DBCC results for 'ccdoc'.There are 92 rows in 1 pages for object "ccdoc".DBCC results for 'pritem'.There are 0 rows in 1 pages for object "pritem".DBCC results for 'dls_salmonella'.There are 0 rows in 0 pages for object "dls_salmonella".DBCC results for 'biochemistrytemp'.There are 1 rows in 1 pages for object "biochemistrytemp".DBCC results for 'miscdtl'.There are 0 rows in 0 pages for object "miscdtl".DBCC results for 'sn'.There are 0 rows in 0 pages for object "sn".DBCC results for 'microscopy03'.There are 0 rows in 0 pages for object "microscopy03".DBCC results for 'cmapplcust'.There are 0 rows in 1 pages for object "cmapplcust".DBCC results for 'generic'.There are 2396 rows in 35 pages for object "generic".DBCC results for 'electrocardiovmmc'.There are 0 rows in 0 pages for object "electrocardiovmmc".DBCC results for 'immunology02'.There are 0 rows in 0 pages for object "immunology02".DBCC results for 'msctowncity'.There are 1585 rows in 11 pages for object "msctowncity".DBCC results for 'proditem'.There are 0 rows in 0 pages for object "proditem".DBCC results for 'ape_coll'.There are 0 rows in 0 pages for object "ape_coll".DBCC results for 'psh_cyto'.There are 0 rows in 0 pages for object "psh_cyto".DBCC results for 'exm_serology'.There are 17 rows in 2 pages for object "exm_serology".DBCC results for 'mscterms'.There are 15 rows in 1 pages for object "mscterms".DBCC results for 'iteminven'.There are 0 rows in 0 pages for object "iteminven".DBCC results for 'bgh_hematology'.There are 0 rows in 0 pages for object "bgh_hematology".DBCC results for 'mmmc_eeg'.There are 0 rows in 0 pages for object "mmmc_eeg".DBCC results for 'arappl'.There are 0 rows in 1 pages for object "arappl".DBCC results for 'itemcomp'.There are 0 rows in 1 pages for object "itemcomp".DBCC results for 'bdh_hysterosal'.There are 0 rows in 0 pages for object "bdh_hysterosal".DBCC results for 'chemistryi'.There are 0 rows in 0 pages for object "chemistryi".DBCC results for 'ctscantemp'.There are 0 rows in 0 pages for object "ctscantemp".DBCC results for 'bdh_hemodialysis'.There are 0 rows in 0 pages for object "bdh_hemodialysis".DBCC results for 'debitcreditcateg'.There are 5 rows in 1 pages for object "debitcreditcateg".DBCC results for 'canvass'.There are 0 rows in 0 pages for object "canvass".DBCC results for 'olm_promissory'.There are 0 rows in 0 pages for object "olm_promissory".DBCC results for 'treadmill'.There are 0 rows in 0 pages for object "treadmill".DBCC results for 'mscpetclass'.There are 2 rows in 1 pages for object "mscpetclass".DBCC results for 'bgh_urinalysis'.There are 0 rows in 0 pages for object "bgh_urinalysis".DBCC results for 'dctrmaster'.There are 271 rows in 9 pages for object "dctrmaster".DBCC results for 'billmstr'.There are 0 rows in 1 pages for object "billmstr".DBCC results for 'mscqpriceupdt'.There are 0 rows in 0 pages for object "mscqpriceupdt".DBCC results for 'bdh_hematology'.There are 0 rows in 0 pages for object "bdh_hematology".DBCC results for 'appsysowner'.There are 1 rows in 1 pages for object "appsysowner".DBCC results for 'bloodchemistry'.There are 0 rows in 0 pages for object "bloodchemistry".DBCC results for 'msckittemplate'.There are 0 rows in 1 pages for object "msckittemplate".DBCC results for 'exmbiochemistry'.There are 0 rows in 0 pages for object "exmbiochemistry".DBCC results for 'dlsu_parasitology'.There are 0 rows in 0 pages for object "dlsu_parasitology".DBCC results for 'glclass'.There are 0 rows in 1 pages for object "glclass".DBCC results for 'bgh_bloodchemistry'.There are 0 rows in 0 pages for object "bgh_bloodchemistry".DBCC results for 'bacteriologyvmmc'.There are 0 rows in 0 pages for object "bacteriologyvmmc".DBCC results for 'orrangeuser'.There are 0 rows in 0 pages for object "orrangeuser".DBCC results for 'exm_chemistry'.There are 1205 rows in 199 pages for object "exm_chemistry".DBCC results for 'mscdisctemplate'.There are 30 rows in 1 pages for object "mscdisctemplate".DBCC results for 'discdtls'.There are 864 rows in 16 pages for object "discdtls".DBCC results for 'surgicalproc_child'.There are 0 rows in 0 pages for object "surgicalproc_child".DBCC results for 'mmmc_mammo'.There are 0 rows in 0 pages for object "mmmc_mammo".DBCC results for 'dlsu_abg'.There are 0 rows in 0 pages for object "dlsu_abg".DBCC results for 'exmbloodbanking'.There are 0 rows in 0 pages for object "exmbloodbanking".DBCC results for 'mmmc_tdc'.There are 0 rows in 0 pages for object "mmmc_tdc".DBCC results for 'appsyspcusers'.There are 69 rows in 4 pages for object "appsyspcusers".DBCC results for 'mmmc_nssdetails'.There are 0 rows in 0 pages for object "mmmc_nssdetails".DBCC results for 'mscassetclass'.There are 9 rows in 1 pages for object "mscassetclass".DBCC results for 'items'.There are 1988 rows in 368 pages for object "items".DBCC results for 'mmmc_cur'.There are 0 rows in 0 pages for object "mmmc_cur".DBCC results for 'diagnostic_venouslower2'.There are 0 rows in 0 pages for object "diagnostic_venouslower2".DBCC results for 'bdh_cardiactemp'.There are 0 rows in 0 pages for object "bdh_cardiactemp".DBCC results for 'discordinance_patitem'.There are 0 rows in 0 pages for object "discordinance_patitem".DBCC results for 'patupdowngrade'.There are 0 rows in 0 pages for object "patupdowngrade".DBCC results for 'hematology02'.There are 0 rows in 0 pages for object "hematology02".DBCC results for 'patpaydtls'.There are 632 rows in 16 pages for object "patpaydtls".DBCC results for 'exm_immunology'.There are 0 rows in 1 pages for object "exm_immunology".DBCC results for 'apitem'.There are 0 rows in 1 pages for object "apitem".DBCC results for 'patientdrugs'.There are 10 rows in 1 pages for object "patientdrugs".DBCC results for 'pcgh_groupincome'.There are 0 rows in 0 pages for object "pcgh_groupincome".DBCC results for 'mscallocatedbeds'.There are 12 rows in 1 pages for object "mscallocatedbeds".DBCC results for 'glgroupacct'.There are 0 rows in 1 pages for object "glgroupacct".DBCC results for 'dlsu_obstetric1'.There are 0 rows in 0 pages for object "dlsu_obstetric1".DBCC results for 'lis_vitrosdet'.There are 0 rows in 0 pages for object "lis_vitrosdet".DBCC results for 'gntrdoctordtls'.There are 48 rows in 1 pages for object "gntrdoctordtls".DBCC results for 'dlsu_radiology'.There are 0 rows in 0 pages for object "dlsu_radiology".DBCC results for 'alobitm'.There are 0 rows in 0 pages for object "alobitm".DBCC results for 'bacteriology02'.There are 0 rows in 0 pages for object "bacteriology02".DBCC results for 'mscFavorites'.There are 3 rows in 1 pages for object "mscFavorites".DBCC results for 'exmbloodbankvmmcreact'.There are 0 rows in 0 pages for object "exmbloodbankvmmcreact".DBCC results for 'orpay'.There are 299 rows in 8 pages for object "orpay".DBCC results for 'rtemplatemstr'.There are 0 rows in 0 pages for object "rtemplatemstr".DBCC results for 'cashflowtype'.There are 13 rows in 1 pages for object "cashflowtype".DBCC results for 'cptmstr'.There are 0 rows in 0 pages for object "cptmstr".DBCC results for 'mscfloatsrs'.There are 17 rows in 1 pages for object "mscfloatsrs".DBCC results for 'dlscmrb2'.There are 0 rows in 0 pages for object "dlscmrb2".DBCC results for 'mo_dtl'.There are 0 rows in 0 pages for object "mo_dtl".DBCC results for 'dlsu_rts'.There are 0 rows in 0 pages for object "dlsu_rts".DBCC results for 'pcgh_ecg'.There are 0 rows in 0 pages for object "pcgh_ecg".DBCC results for 'echocardiography'.There are 0 rows in 0 pages for object "echocardiography".DBCC results for 'apldgr'.There are 0 rows in 1 pages for object "apldgr".DBCC results for 'mscresultcateg'.There are 153 rows in 6 pages for object "mscresultcateg".DBCC results for 'bloodchemistry04temp'.There are 0 rows in 0 pages for object "bloodchemistry04temp".DBCC results for 'radfilmmstr'.There are 0 rows in 0 pages for object "radfilmmstr".DBCC results for 'dailyrevenuetemp'.There are 0 rows in 0 pages for object "dailyrevenuetemp".DBCC results for 'urinalysisvmmc'.There are 2 rows in 1 pages for object "urinalysisvmmc".DBCC results for 'mmmc_dischinstruct'.There are 0 rows in 0 pages for object "mmmc_dischinstruct".DBCC results for 'microbiologyvmmcchild'.There are 0 rows in 0 pages for object "microbiologyvmmcchild".DBCC results for 'smc_serologytemp'.There are 0 rows in 0 pages for object "smc_serologytemp".DBCC results for 'cmapplven'.There are 0 rows in 0 pages for object "cmapplven".DBCC results for 'poitem'.There are 0 rows in 1 pages for object "poitem".DBCC results for 'psh_ultra'.There are 0 rows in 0 pages for object "psh_ultra".DBCC results for 'mscopdservice'.There are 0 rows in 0 pages for object "mscopdservice".DBCC results for 'peripheralarterialvmmc'.There are 0 rows in 0 pages for object "peripheralarterialvmmc".DBCC results for 'hivtest'.There are 0 rows in 0 pages for object "hivtest".DBCC results for 'upperendoscopyvmmc'.There are 0 rows in 0 pages for object "upperendoscopyvmmc".DBCC results for 'itemtmpdetails'.There are 0 rows in 1 pages for object "itemtmpdetails".DBCC results for 'exm_abg'.There are 0 rows in 0 pages for object "exm_abg".DBCC results for 'surgicalproc'.There are 0 rows in 0 pages for object "surgicalproc".DBCC results for 'exm_histopath'.There are 0 rows in 0 pages for object "exm_histopath".DBCC results for 'diagnostic_arteriallower'.There are 0 rows in 0 pages for object "diagnostic_arteriallower".DBCC results for 'hosppl'.There are 0 rows in 0 pages for object "hosppl".DBCC results for 'exm_2dechotemp'.There are 0 rows in 0 pages for object "exm_2dechotemp".DBCC results for 'orrecord'.There are 0 rows in 0 pages for object "orrecord".DBCC results for 'mscreferrals'.There are 0 rows in 0 pages for object "mscreferrals".DBCC results for 'diettran'.There are 0 rows in 0 pages for object "diettran".DBCC results for 'patinv'.There are 23521 rows in 1951 pages for object "patinv".DBCC results for 'hospplan'.There are 6 rows in 1 pages for object "hospplan".DBCC results for 'rfroomclass'.There are 80 rows in 1 pages for object "rfroomclass".DBCC results for 'exm_bloodbank'.There are 31 rows in 3 pages for object "exm_bloodbank".DBCC results for 'bloodchemistry04'.There are 0 rows in 0 pages for object "bloodchemistry04".DBCC results for 'venousduplex'.There are 0 rows in 0 pages for object "venousduplex".DBCC results for 'chemistryii'.There are 0 rows in 0 pages for object "chemistryii".DBCC results for 'bdh_serumelectro'.There are 0 rows in 0 pages for object "bdh_serumelectro".DBCC results for 'bdh_abgtemp'.There are 0 rows in 0 pages for object "bdh_abgtemp".DBCC results for 'lismachine'.There are 1 rows in 1 pages for object "lismachine".DBCC results for 'exmbloodbankvmmc'.There are 0 rows in 0 pages for object "exmbloodbankvmmc".DBCC results for 'patledgersumm'.There are 1075 rows in 38 pages for object "patledgersumm".DBCC results for 'patfamilytree'.There are 0 rows in 0 pages for object "patfamilytree".DBCC results for 'mscfsgrp'.There are 5 rows in 1 pages for object "mscfsgrp".DBCC results for 'gntrledger'.There are 63 rows in 2 pages for object "gntrledger".DBCC results for 'packdealitem'.There are 0 rows in 1 pages for object "packdealitem".DBCC results for 'bdh_specialchemistry'.There are 0 rows in 0 pages for object "bdh_specialchemistry".DBCC results for 'urinechem'.There are 0 rows in 0 pages for object "urinechem".DBCC results for 'bankadj'.There are 0 rows in 0 pages for object "bankadj".DBCC results for 'alobinv'.There are 0 rows in 0 pages for object "alobinv".DBCC results for 'bloodgasvmmc'.There are 0 rows in 0 pages for object "bloodgasvmmc".DBCC results for 'holter'.There are 0 rows in 0 pages for object "holter".DBCC results for 'ortrandet'.There are 0 rows in 0 pages for object "ortrandet".DBCC results for 'tbperiodicsumm'.There are 0 rows in 0 pages for object "tbperiodicsumm".DBCC results for 'biochemistry'.There are 10 rows in 1 pages for object "biochemistry".DBCC results for 'mscallergylist'.There are 13 rows in 1 pages for object "mscallergylist".DBCC results for 'mscbarangay'.There are 0 rows in 1 pages for object "mscbarangay".DBCC results for 'mscdietmenu'.There are 0 rows in 0 pages for object "mscdietmenu".DBCC results for 'dctrledger'.There are 3134 rows in 131 pages for object "dctrledger".DBCC results for 'dietmenudtls'.There are 0 rows in 0 pages for object "dietmenudtls".DBCC results for 'ctscan'.There are 0 rows in 1 pages for object "ctscan".DBCC results for 'projitm'.There are 0 rows in 0 pages for object "projitm".DBCC results for 'adjhistory'.There are 0 rows in 0 pages for object "adjhistory".DBCC results for 'dctrrfitems'.There are 0 rows in 0 pages for object "dctrrfitems".DBCC results for 'assets'.There are 0 rows in 1 pages for object "assets".DBCC results for 'carotidduplexvmmc'.There are 0 rows in 0 pages for object "carotidduplexvmmc".DBCC results for 'mscservtype'.There are 13 rows in 1 pages for object "mscservtype".DBCC results for 'histmedicare'.There are 0 rows in 0 pages for object "histmedicare".DBCC results for 'icdsubclass'.There are 268 rows in 9 pages for object "icdsubclass".DBCC results for 'journaldepot'.There are 0 rows in 1 pages for object "journaldepot".DBCC results for 'mscnationality'.There are 23 rows in 1 pages for object "mscnationality".DBCC results for 'hematology02temp'.There are 0 rows in 0 pages for object "hematology02temp".DBCC results for 'dctrorders'.There are 0 rows in 0 pages for object "dctrorders".DBCC results for 'posub'.There are 0 rows in 1 pages for object "posub".DBCC results for 'glcostcenters'.There are 0 rows in 1 pages for object "glcostcenters".DBCC results for 'bloodbankvmmc'.There are 0 rows in 0 pages for object "bloodbankvmmc".DBCC results for 'mscroomclass'.There are 80 rows in 2 pages for object "mscroomclass".DBCC results for 'mscprovince'.There are 84 rows in 1 pages for object "mscprovince".DBCC results for 'bloodbankvmmcreact'.There are 0 rows in 0 pages for object "bloodbankvmmcreact".DBCC results for 'dctrsub'.There are 3128 rows in 70 pages for object "dctrsub".DBCC results for 'bacteriology01'.There are 0 rows in 0 pages for object "bacteriology01".DBCC results for 'appsysreports'.There are 13 rows in 1 pages for object "appsysreports".DBCC results for 'msccostcenters'.There are 0 rows in 1 pages for object "msccostcenters".DBCC results for 'pcgh_medico'.There are 0 rows in 0 pages for object "pcgh_medico".DBCC results for 'orfile'.There are 0 rows in 0 pages for object "orfile".DBCC results for 'wareitemcateg'.There are 0 rows in 1 pages for object "wareitemcateg".DBCC results for 'dctrsched'.There are 0 rows in 0 pages for object "dctrsched".DBCC results for 'mcrcta'.There are 0 rows in 0 pages for object "mcrcta".DBCC results for 'treadmilltemp'.There are 0 rows in 1 pages for object "treadmilltemp".DBCC results for 'exm_pathology'.There are 0 rows in 0 pages for object "exm_pathology".DBCC results for 'dlsu_semenalysis'.There are 0 rows in 0 pages for object "dlsu_semenalysis".DBCC results for 'dlsu_gynecology'.There are 0 rows in 0 pages for object "dlsu_gynecology".DBCC results for 'cvmstr'.There are 0 rows in 1 pages for object "cvmstr".DBCC results for 'mscsetupgl'.There are 0 rows in 0 pages for object "mscsetupgl".DBCC results for 'microbiologyvmmctemp'.There are 1 rows in 1 pages for object "microbiologyvmmctemp".DBCC results for 'referrals'.There are 0 rows in 0 pages for object "referrals".DBCC results for 'bloodchemistry06temp'.There are 0 rows in 0 pages for object "bloodchemistry06temp".DBCC results for 'exm_2Decho'.There are 8 rows in 1 pages for object "exm_2Decho".DBCC results for 'rtemplatedtls'.There are 0 rows in 0 pages for object "rtemplatedtls".DBCC results for 'bgh_stoolexamination'.There are 0 rows in 0 pages for object "bgh_stoolexamination".DBCC results for 'areaprice'.There are 0 rows in 0 pages for object "areaprice".DBCC results for 'mscbanks'.There are 14 rows in 1 pages for object "mscbanks".DBCC results for 'appsyscheckupdates'.There are 52 rows in 1 pages for object "appsyscheckupdates".DBCC results for 'consrepsetup'.There are 0 rows in 0 pages for object "consrepsetup".DBCC results for 'obstetric1st'.There are 0 rows in 0 pages for object "obstetric1st".DBCC results for 'gynecology01vmmc'.There are 0 rows in 0 pages for object "gynecology01vmmc".DBCC results for 'dlscmrb'.There are 0 rows in 0 pages for object "dlscmrb".DBCC results for 'gldtl'.There are 0 rows in 1 pages for object "gldtl".DBCC results for 'ancillarymaster'.There are 42 rows in 1 pages for object "ancillarymaster".DBCC results for 'itmprice'.There are 0 rows in 0 pages for object "itmprice".DBCC results for 'mscprintcateg'.There are 12 rows in 1 pages for object "mscprintcateg".DBCC results for 'lowerendoscopyvmmc'.There are 0 rows in 0 pages for object "lowerendoscopyvmmc".DBCC results for 'exm_bacteriology'.There are 0 rows in 1 pages for object "exm_bacteriology".DBCC results for 'warehousemaster'.There are 0 rows in 0 pages for object "warehousemaster".DBCC results for 'itemitm'.There are 0 rows in 1 pages for object "itemitm".DBCC results for 'serology04_temp'.There are 0 rows in 0 pages for object "serology04_temp".DBCC results for 'bdh_gynecology'.There are 0 rows in 0 pages for object "bdh_gynecology".DBCC results for 'mscGrpResType'.There are 0 rows in 0 pages for object "mscGrpResType".DBCC results for 'mscbilltemplate'.There are 38 rows in 1 pages for object "mscbilltemplate".DBCC results for 'apappl'.There are 0 rows in 0 pages for object "apappl".DBCC results for 'bloodchemspecial'.There are 0 rows in 0 pages for object "bloodchemspecial".DBCC results for 'rch_peripheral'.There are 0 rows in 0 pages for object "rch_peripheral".DBCC results for 'mscpersonnelcateg'.There are 20 rows in 1 pages for object "mscpersonnelcateg".DBCC results for 'petty'.There are 0 rows in 1 pages for object "petty".DBCC results for 'mmmc_dse'.There are 0 rows in 0 pages for object "mmmc_dse".DBCC results for 'resulttype'.There are 0 rows in 0 pages for object "resulttype".DBCC results for 'companyresult'.There are 0 rows in 0 pages for object "companyresult".DBCC results for 'packdealmstr'.There are 0 rows in 1 pages for object "packdealmstr".DBCC results for 'msccustclass'.There are 16 rows in 1 pages for object "msccustclass".DBCC results for 'immunology'.There are 0 rows in 1 pages for object "immunology".DBCC results for 'admission'.There are 1086 rows in 151 pages for object "admission".DBCC results for 'immunologytemp'.There are 0 rows in 0 pages for object "immunologytemp".DBCC results for 'mmmcSbrRooms'.There are 0 rows in 0 pages for object "mmmcSbrRooms".DBCC results for 'patsalesdtls'.There are 0 rows in 1 pages for object "patsalesdtls".DBCC results for 'cvpay'.There are 0 rows in 1 pages for object "cvpay".DBCC results for 'mscitemgroup'.There are 0 rows in 0 pages for object "mscitemgroup".DBCC results for 'diagnostic_studyno'.There are 0 rows in 0 pages for object "diagnostic_studyno".DBCC results for 'ultrasound'.There are 0 rows in 1 pages for object "ultrasound".DBCC results for 'resulttypedest'.There are 0 rows in 0 pages for object "resulttypedest".DBCC results for 'immunology03temp'.There are 0 rows in 0 pages for object "immunology03temp".DBCC results for 'urinechemtemp'.There are 0 rows in 0 pages for object "urinechemtemp".DBCC results for 'msccurrsub'.There are 6 rows in 1 pages for object "msccurrsub".DBCC results for 'mscrelation'.There are 20 rows in 1 pages for object "mscrelation".DBCC results for 'exm_microbiology'.There are 0 rows in 0 pages for object "exm_microbiology".DBCC results for 'agent'.There are 0 rows in 0 pages for object "agent".DBCC results for 'gntrsub'.There are 64 rows in 2 pages for object "gntrsub".DBCC results for 'itemldgr'.There are 39458 rows in 1146 pages for object "itemldgr".DBCC results for 'mscsetup'.There are 1 rows in 1 pages for object "mscsetup".DBCC results for 'hematologyexamtemp'.There are 0 rows in 0 pages for object "hematologyexamtemp".DBCC results for 'rfap'.There are 0 rows in 0 pages for object "rfap".DBCC results for 'patsalesjrnldtls'.There are 0 rows in 1 pages for object "patsalesjrnldtls".DBCC results for 'pediatric'.There are 0 rows in 0 pages for object "pediatric".DBCC results for 'mscitemclass'.There are 113 rows in 3 pages for object "mscitemclass".DBCC results for 'mscdatagroup'.There are 6 rows in 1 pages for object "mscdatagroup".DBCC results for 'urinalysis'.There are 0 rows in 0 pages for object "urinalysis".DBCC results for 'jvdtl'.There are 0 rows in 1 pages for object "jvdtl".DBCC results for 'dlsu_obstetric23'.There are 0 rows in 0 pages for object "dlsu_obstetric23".DBCC results for 'mcinv'.There are 0 rows in 0 pages for object "mcinv".DBCC results for 'reports'.There are 0 rows in 0 pages for object "reports".DBCC results for 'reqitem'.There are 0 rows in 0 pages for object "reqitem".DBCC results for 'ordtls'.There are 0 rows in 1 pages for object "ordtls".DBCC results for 'msctypeofdeath'.There are 10 rows in 1 pages for object "msctypeofdeath".DBCC results for 'mscdocpic'.There are 0 rows in 0 pages for object "mscdocpic".DBCC results for 'hematology'.There are 0 rows in 0 pages for object "hematology".DBCC results for 'fecalysis'.There are 2 rows in 1 pages for object "fecalysis".DBCC results for 'mscadjclass'.There are 0 rows in 1 pages for object "mscadjclass".DBCC results for 'customer'.There are 239 rows in 7 pages for object "customer".DBCC results for 'osinv'.There are 0 rows in 0 pages for object "osinv".DBCC results for 'mcpayment'.There are 0 rows in 0 pages for object "mcpayment".DBCC results for 'smc_chemistry'.There are 0 rows in 0 pages for object "smc_chemistry".DBCC results for 'markuphistory'.There are 0 rows in 0 pages for object "markuphistory".DBCC results for 'mcremittran'.There are 0 rows in 0 pages for object "mcremittran".DBCC results for 'mri'.There are 0 rows in 0 pages for object "mri".DBCC results for 'mritemp'.There are 0 rows in 0 pages for object "mritemp".DBCC results for 'jvpatdtls'.There are 0 rows in 1 pages for object "jvpatdtls".DBCC results for 'subservicetype'.There are 33 rows in 1 pages for object "subservicetype".DBCC results for 'custacti'.There are 0 rows in 0 pages for object "custacti".DBCC results for 'gynecology02vmmc'.There are 0 rows in 0 pages for object "gynecology02vmmc".DBCC results for 'pettygl'.There are 0 rows in 0 pages for object "pettygl".DBCC results for 'netrefund'.There are 0 rows in 1 pages for object "netrefund".DBCC results for 'roomtrans'.There are 242 rows in 6 pages for object "roomtrans".DBCC results for 'exm_bacteriologychild'.There are 0 rows in 0 pages for object "exm_bacteriologychild".DBCC results for 'antibiotics'.There are 0 rows in 0 pages for object "antibiotics".DBCC results for 'bdh_spermanalysis'.There are 0 rows in 0 pages for object "bdh_spermanalysis".DBCC results for 'appsyspclevel'.There are 152 rows in 3 pages for object "appsyspclevel".DBCC results for 'mscrooms'.There are 81 rows in 2 pages for object "mscrooms".DBCC results for 'chemistryhba1ctemp'.There are 0 rows in 0 pages for object "chemistryhba1ctemp".DBCC results for 'pfgntrpayment'.There are 0 rows in 0 pages for object "pfgntrpayment".DBCC results for 'mscdiscounttype'.There are 0 rows in 1 pages for object "mscdiscounttype".DBCC results for 'phentinv'.There are 0 rows in 1 pages for object "phentinv".DBCC results for 'hij_dcr'.There are 0 rows in 0 pages for object "hij_dcr".DBCC results for 'msccurrency'.There are 1 rows in 1 pages for object "msccurrency".DBCC results for 'echocardiographytemp'.There are 0 rows in 0 pages for object "echocardiographytemp".DBCC results for 'mscdocrep'.There are 83 rows in 2 pages for object "mscdocrep".DBCC results for 'bronchoscopyvmmc'.There are 0 rows in 0 pages for object "bronchoscopyvmmc".DBCC results for 'gntrhospbilldtls'.There are 86 rows in 1 pages for object "gntrhospbilldtls".DBCC results for 'aritem'.There are 0 rows in 0 pages for object "aritem".DBCC results for 'serology02'.There are 0 rows in 0 pages for object "serology02".DBCC results for 'admdctrledger'.There are 968 rows in 24 pages for object "admdctrledger".DBCC results for 'serologyvmmc'.There are 2 rows in 1 pages for object "serologyvmmc".DBCC results for 'argl'.There are 0 rows in 1 pages for object "argl".DBCC results for 'itempricescheme'.There are 0 rows in 0 pages for object "itempricescheme".DBCC results for 'hospchargecashtemp'.There are 0 rows in 0 pages for object "hospchargecashtemp".DBCC results for 'smc_serology'.There are 0 rows in 0 pages for object "smc_serology".DBCC results for 'psh_ultra23'.There are 0 rows in 0 pages for object "psh_ultra23".DBCC results for 'exmbiochemistrytemp'.There are 0 rows in 0 pages for object "exmbiochemistrytemp".DBCC results for 'orseries'.There are 8 rows in 1 pages for object "orseries".DBCC results for 'whitem'.There are 0 rows in 1 pages for object "whitem".DBCC results for 'patpaymstr'.There are 1307 rows in 54 pages for object "patpaymstr".DBCC results for 'immunology03'.There are 0 rows in 0 pages for object "immunology03".DBCC results for 'mscpricescheme'.There are 11 rows in 1 pages for object "mscpricescheme".DBCC results for 'setupgl'.There are 0 rows in 0 pages for object "setupgl".DBCC results for 'msccards'.There are 4 rows in 1 pages for object "msccards".DBCC results for 'radfilmitem'.There are 0 rows in 0 pages for object "radfilmitem".DBCC results for 'prevyr'.There are 0 rows in 0 pages for object "prevyr".DBCC results for 'whreqinv'.There are 0 rows in 1 pages for object "whreqinv".DBCC results for 'mscsbr'.There are 0 rows in 0 pages for object "mscsbr".DBCC results for 'userdept'.There are 7 rows in 1 pages for object "userdept".DBCC results for 'bdh_cytology'.There are 0 rows in 0 pages for object "bdh_cytology".DBCC results for 'mscBranch'.There are 0 rows in 0 pages for object "mscBranch".DBCC results for 'mscsettletype'.There are 8 rows in 1 pages for object "mscsettletype".DBCC results for 'patrooms'.There are 3257 rows in 53 pages for object "patrooms".DBCC results for 'glacct'.There are 1257 rows in 18 pages for object "glacct".DBCC results for 'immunology04temp'.There are 0 rows in 0 pages for object "immunology04temp".DBCC results for 'mmmc_dischinstruct1'.There are 0 rows in 0 pages for object "mmmc_dischinstruct1".DBCC results for 'bdh_hearingcare'.There are 0 rows in 0 pages for object "bdh_hearingcare".DBCC results for 'trialend'.There are 0 rows in 0 pages for object "trialend".DBCC results for 'smc_chemistrytemp'.There are 0 rows in 0 pages for object "smc_chemistrytemp".DBCC results for 'mscpatclassification'.There are 24 rows in 1 pages for object "mscpatclassification".DBCC results for 'mscmctemplate'.There are 35 rows in 1 pages for object "mscmctemplate".DBCC results for 'mscGroup'.There are 0 rows in 0 pages for object "mscGroup".DBCC results for 'nuclearimagingvmmc'.There are 0 rows in 0 pages for object "nuclearimagingvmmc".DBCC results for 'patledger'.There are 30842 rows in 631 pages for object "patledger".DBCC results for 'mscPhicCasetype'.There are 18 rows in 1 pages for object "mscPhicCasetype".DBCC results for 'bgh_hematologytemp'.There are 0 rows in 0 pages for object "bgh_hematologytemp".DBCC results for 'bdh_spobstetric'.There are 0 rows in 0 pages for object "bdh_spobstetric".DBCC results for 'radiologytemp'.There are 25 rows in 1 pages for object "radiologytemp".DBCC results for 'bdh_abg'.There are 0 rows in 0 pages for object "bdh_abg".DBCC results for 'dritem'.There are 0 rows in 0 pages for object "dritem".DBCC results for 'bdh_serumelectrotemp'.There are 0 rows in 0 pages for object "bdh_serumelectrotemp".DBCC results for 'mcm_papsmear'.There are 0 rows in 0 pages for object "mcm_papsmear".DBCC results for 'mscglphiccateg'.There are 302 rows in 4 pages for object "mscglphiccateg".DBCC results for 'mscHospitals'.There are 0 rows in 0 pages for object "mscHospitals".DBCC results for 'pfpayment'.There are 0 rows in 0 pages for object "pfpayment".DBCC results for 'addrmstr'.There are 3463 rows in 281 pages for object "addrmstr".DBCC results for 'rch_histopath'.There are 0 rows in 0 pages for object "rch_histopath".DBCC results for 'bdh_pathologytemp'.There are 0 rows in 0 pages for object "bdh_pathologytemp".DBCC results for 'whinv'.There are 0 rows in 1 pages for object "whinv".DBCC results for 'radioimmunoassayvmmc'.There are 0 rows in 0 pages for object "radioimmunoassayvmmc".DBCC results for 'itemizedgntrdtls'.There are 0 rows in 0 pages for object "itemizedgntrdtls".DBCC results for 'custprod'.There are 0 rows in 0 pages for object "custprod".DBCC results for 'deathcertrecord'.There are 0 rows in 0 pages for object "deathcertrecord".DBCC results for 'labsections'.There are 30 rows in 1 pages for object "labsections".DBCC results for 'mscnrstation'.There are 4 rows in 1 pages for object "mscnrstation".DBCC results for 'drinv'.There are 0 rows in 0 pages for object "drinv".DBCC results for 'exm_spermanalysis'.There are 0 rows in 0 pages for object "exm_spermanalysis".DBCC results for 'appsysquotes'.There are 0 rows in 0 pages for object "appsysquotes".DBCC results for 'arldgrtemp'.There are 0 rows in 0 pages for object "arldgrtemp".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for 'surgicalpathologyvmmc'.There are 0 rows in 0 pages for object "surgicalpathologyvmmc".DBCC results for 'mscproccateg'.There are 0 rows in 0 pages for object "mscproccateg".DBCC results for 'patfinalicd'.There are 546 rows in 5 pages for object "patfinalicd".DBCC results for 'reminders'.There are 1 rows in 1 pages for object "reminders".DBCC results for 'mscreligion'.There are 27 rows in 1 pages for object "mscreligion".DBCC results for 'serology04'.There are 0 rows in 0 pages for object "serology04".DBCC results for 'obstetric2nd'.There are 0 rows in 0 pages for object "obstetric2nd".DBCC results for 'assembly'.There are 0 rows in 0 pages for object "assembly".DBCC results for 'msccountry'.There are 120 rows in 1 pages for object "msccountry".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for 'appsysconfig'.There are 1 rows in 1 pages for object "appsysconfig".DBCC results for 'pcgh_medimage'.There are 0 rows in 0 pages for object "pcgh_medimage".DBCC results for 'mscempfile'.There are 0 rows in 0 pages for object "mscempfile".DBCC results for 'rebates'.There are 0 rows in 0 pages for object "rebates".DBCC results for 'reqinv'.There are 0 rows in 0 pages for object "reqinv".DBCC results for 'bdh_clinmicroscopy'.There are 0 rows in 0 pages for object "bdh_clinmicroscopy".DBCC results for 'PatientResult'.There are 0 rows in 0 pages for object "PatientResult".DBCC results for 'collfu'.There are 0 rows in 0 pages for object "collfu".DBCC results for 'phentitem'.There are 0 rows in 1 pages for object "phentitem".DBCC results for 'quoteinv'.There are 0 rows in 0 pages for object "quoteinv".DBCC results for 'assetsdet'.There are 0 rows in 1 pages for object "assetsdet".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'packdealtran'.There are 0 rows in 1 pages for object "packdealtran".DBCC results for 'chemistryhba1c'.There are 0 rows in 0 pages for object "chemistryhba1c".DBCC results for 'jvtdtl'.There are 0 rows in 0 pages for object "jvtdtl".DBCC results for 'cytopathologyvmmc'.There are 0 rows in 0 pages for object "cytopathologyvmmc".DBCC results for 'mscdiscountservice'.There are 0 rows in 1 pages for object "mscdiscountservice".DBCC results for 'bdh_obstetric23'.There are 0 rows in 0 pages for object "bdh_obstetric23".DBCC results for 'seriesdocno'.There are 200 rows in 2 pages for object "seriesdocno".DBCC results for 'mscwarehouse'.There are 200 rows in 11 pages for object "mscwarehouse".DBCC results for 'nvtemplatedet'.There are 989 rows in 72 pages for object "nvtemplatedet".DBCC results for 'drsub'.There are 0 rows in 0 pages for object "drsub".DBCC results for 'parasitology'.There are 0 rows in 0 pages for object "parasitology".DBCC results for 'transudate'.There are 0 rows in 0 pages for object "transudate".DBCC results for 'bdh_specialchemistrytemp'.There are 0 rows in 0 pages for object "bdh_specialchemistrytemp".DBCC results for 'serology03'.There are 0 rows in 0 pages for object "serology03".DBCC results for 'appsysrepoptions'.There are 43 rows in 1 pages for object "appsysrepoptions".DBCC results for 'bdh_pathology'.There are 0 rows in 0 pages for object "bdh_pathology".DBCC results for 'venousduplexvmmc'.There are 0 rows in 0 pages for object "venousduplexvmmc".DBCC results for 'patdiscount'.There are 233 rows in 2 pages for object "patdiscount".DBCC results for 'mscarea'.There are 1982 rows in 10 pages for object "mscarea".DBCC results for 'mcappl'.There are 0 rows in 0 pages for object "mcappl".CHECKDB found 0 allocation errors and 0 consistency errors in database 'smartapp'.DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-19 : 01:29:28
|
| Like I said, you'll need to post this in the Data Corruption forum here. But I guess I can move the topic. It would just be better to start a new thread over there as ones with posts in them might not get the same attention.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2007-10-19 : 01:38:48
|
| Sorry, I thought you wanted the results. Is this error still fixable? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-19 : 01:43:44
|
| I don't know as I can't read DBCC CHECKDB output. But others who check this specific forum can. I always immediately contact MS when I've got errors from DBCC CHECKDB, but our servers are mission critical so I can't waste time waiting for online help.Do you have good backups in case the data is not salvageable?Also, data corruption issues are typically hardware-related and most commonly disk-related. So if that is the case and you don't fix the actual issue, you'll have errors again. Check Event Viewer for hardware errors and do hardware diagnostics.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2007-10-19 : 04:33:22
|
| Our client have everyday backups, but the problem is all the succeding data and transactions, and I dont think having differential backup to restore will not help them. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-10-19 : 13:35:13
|
| Well, you fixed them by running REPAIR_ALLOW_DATA_LOSS but I think you lost data in the process - the CHECKDB output shows that it deleted some pages from the clustered index. Without looking at the database I can't tell whether these are data or index pages.It's strange that the same errors show up in all the non-clustered indexes too - like a row has a corrupt value in that's been propagated to all the non-clustered indexes too.I would call Product Support to help you out with this one.Paul RandalManaging Director, SQLskills.com |
|
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2007-10-19 : 22:16:25
|
| I did some fixes and it works. I just want to share, I tried to delete the index of the table affected. Then I executed again the scipts to repair the data corrupted.ALTER DATABASE myDatabase SET MULTI_USER DBCC CHECKDB('myDatabase ', REPAIR_ALLOW_DATA_LOSS)DBCC CHECKDB('myDatabase ', REPAIR_REBUILD)after I executed this, I tried to re-create again all the indexes for this table..and it works. |
|
|
|
|
|
|
|
|
SQL 2005 Error Msg 5242