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 |
|
sstuart
Starting Member
5 Posts |
 Posted - 2007-03-14 : 13:23:04
|
| Hi all, Here is my DBCC CHECKDB output. I keep REPAIRing the problem and it keeps coming back. I would love to get rid of the objectID in question, but do not know how, or if that would fix the problem. This is running on a MSDE 2000 SP3a. It is also only the "Events" Table that seems to be affected.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67702), slots 174 and 175.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67875), slots 246 and 247.DBCC results for 'AccessControl'.DBCC results for 'sysobjects'.There are 1130 rows in 20 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 1397 rows in 55 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 3047 rows in 47 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 572 rows in 52 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 51 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 13 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 1017 rows in 6 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 13 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'GLOBAL_IO_LINKAGE'.There are 0 rows in 0 pages for object 'GLOBAL_IO_LINKAGE'.DBCC results for 'PANEL_USER_GROUP'.There are 0 rows in 0 pages for object 'PANEL_USER_GROUP'.DBCC results for 'PRECACGRP'.There are 0 rows in 0 pages for object 'PRECACGRP'.DBCC results for 'GLOBAL_IO_OUTPUT_ACTION'.There are 0 rows in 0 pages for object 'GLOBAL_IO_OUTPUT_ACTION'.DBCC results for 'PANEL_USER'.There are 0 rows in 0 pages for object 'PANEL_USER'.DBCC results for 'USERS_ACCESSLEVEL_LINK'.There are 0 rows in 0 pages for object 'USERS_ACCESSLEVEL_LINK'.DBCC results for 'PRECGRPLINK'.There are 0 rows in 0 pages for object 'PRECGRPLINK'.DBCC results for 'EMP_SEGMENT_LINK'.There are 0 rows in 0 pages for object 'EMP_SEGMENT_LINK'.DBCC results for 'KNOWHO_SERVER'.There are 0 rows in 0 pages for object 'KNOWHO_SERVER'.DBCC results for 'ASSET_MMOBJS'.There are 0 rows in 0 pages for object 'ASSET_MMOBJS'.DBCC results for 'GOS_MESSAGE'.There are 1 rows in 1 pages for object 'GOS_MESSAGE'.DBCC results for 'QUEUED_EVENTS'.There are 0 rows in 1 pages for object 'QUEUED_EVENTS'.DBCC results for 'DDTBL'.There are 23 rows in 1 pages for object 'DDTBL'.DBCC results for 'ACCESSLVL_ASSIGNABLE_SEGMENT'.There are 0 rows in 0 pages for object 'ACCESSLVL_ASSIGNABLE_SEGMENT'.DBCC results for 'PERSON_DATA_SOURCE'.There are 6 rows in 1 pages for object 'PERSON_DATA_SOURCE'.DBCC results for 'IE_BADGE_ACC'.There are 0 rows in 0 pages for object 'IE_BADGE_ACC'.DBCC results for 'DEPT'.There are 1 rows in 1 pages for object 'DEPT'.DBCC results for 'USER_PERM_REPORT_GROUP_MEMBER'.There are 0 rows in 0 pages for object 'USER_PERM_REPORT_GROUP_MEMBER'.DBCC results for 'DEVICE_GROUP'.There are 3 rows in 1 pages for object 'DEVICE_GROUP'.DBCC results for 'BADGE_AREA_LOCATION_REPL'.There are 0 rows in 0 pages for object 'BADGE_AREA_LOCATION_REPL'.DBCC results for 'ACCTRANS_RESTORED'.There are 2478 rows in 47 pages for object 'ACCTRANS_RESTORED'.DBCC results for 'LNL_CERTIFICATE'.There are 0 rows in 0 pages for object 'LNL_CERTIFICATE'.DBCC results for 'TRANSMITTER'.There are 0 rows in 0 pages for object 'TRANSMITTER'.DBCC results for 'DEVICE_GROUP_LINK'.There are 186 rows in 1 pages for object 'DEVICE_GROUP_LINK'.DBCC results for 'ALARM_ACK_ACTION'.There are 0 rows in 0 pages for object 'ALARM_ACK_ACTION'.DBCC results for 'ACCTRANS_REPL'.There are 0 rows in 0 pages for object 'ACCTRANS_REPL'.DBCC results for 'CERTIFICATE_AUTHORITY'.There are 0 rows in 0 pages for object 'CERTIFICATE_AUTHORITY'.DBCC results for 'ACCTRANS'.There are 22500 rows in 435 pages for object 'ACCTRANS'.DBCC results for 'DIALUP'.There are 0 rows in 0 pages for object 'DIALUP'.DBCC results for 'ICONTYPE_COMMAND'.There are 3 rows in 1 pages for object 'ICONTYPE_COMMAND'.DBCC results for 'CARDHOLDER_ACCOUNT'.There are 0 rows in 0 pages for object 'CARDHOLDER_ACCOUNT'.DBCC results for 'ACCESSLVL_EXTENDED'.There are 0 rows in 0 pages for object 'ACCESSLVL_EXTENDED'.DBCC results for 'RDR_CARDFORMATS'.There are 0 rows in 0 pages for object 'RDR_CARDFORMATS'.DBCC results for 'DIVISION'.There are 1 rows in 1 pages for object 'DIVISION'.DBCC results for 'MOBILE_VERIFY_GATE'.There are 0 rows in 0 pages for object 'MOBILE_VERIFY_GATE'.DBCC results for 'DOWNLOADDB'.There are 0 rows in 0 pages for object 'DOWNLOADDB'.DBCC results for 'ACCGPLINK'.There are 0 rows in 0 pages for object 'ACCGPLINK'.DBCC results for 'ARCHIVE_SERVER'.There are 1 rows in 1 pages for object 'ARCHIVE_SERVER'.DBCC results for 'RDTZCTLIST'.There are 0 rows in 0 pages for object 'RDTZCTLIST'.DBCC results for 'ELEVATORHW'.There are 0 rows in 0 pages for object 'ELEVATORHW'.DBCC results for 'ACCLVLINK'.There are 0 rows in 0 pages for object 'ACCLVLINK'.DBCC results for 'ARCHIVE_SERVER_LOCATION'.There are 1 rows in 1 pages for object 'ARCHIVE_SERVER_LOCATION'.DBCC results for 'BDG2TRN'.There are 0 rows in 0 pages for object 'BDG2TRN'.DBCC results for 'READER'.There are 0 rows in 0 pages for object 'READER'.DBCC results for 'MOBILE_VERIFY_GATE_RDR_LINK'.There are 0 rows in 0 pages for object 'MOBILE_VERIFY_GATE_RDR_LINK'.DBCC results for 'TRANSMITTER_INPUT'.There are 0 rows in 0 pages for object 'TRANSMITTER_INPUT'.DBCC results for 'EVENT'.There are 1249 rows in 11 pages for object 'EVENT'.DBCC results for 'USER_OPTIONS'.There are 5 rows in 1 pages for object 'USER_OPTIONS'.DBCC results for 'NV_FIRMWARE_DOWNLOAD_ACTION'.There are 0 rows in 0 pages for object 'NV_FIRMWARE_DOWNLOAD_ACTION'.DBCC results for 'READER_ENTRANCE'.There are 0 rows in 0 pages for object 'READER_ENTRANCE'.DBCC results for 'TRANSMITTER_LINK'.There are 0 rows in 0 pages for object 'TRANSMITTER_LINK'.DBCC results for 'EA_DIAGNOSTIC_CFG'.There are 0 rows in 0 pages for object 'EA_DIAGNOSTIC_CFG'.DBCC results for 'NV_FIRMWARE_DOWNLOAD_DEVICE'.There are 0 rows in 0 pages for object 'NV_FIRMWARE_DOWNLOAD_DEVICE'.DBCC results for 'READER_ENTRANCE_LOITERING'.There are 0 rows in 0 pages for object 'READER_ENTRANCE_LOITERING'.DBCC results for 'RELAYOUTPT'.There are 0 rows in 0 pages for object 'RELAYOUTPT'.DBCC results for 'EVENT_GIOFUNCLISTLINK'.There are 0 rows in 0 pages for object 'EVENT_GIOFUNCLISTLINK'.DBCC results for 'ACISLOG'.There are 8 rows in 1 pages for object 'ACISLOG'.DBCC results for 'VISIT_TYPE'.There are 1 rows in 1 pages for object 'VISIT_TYPE'.DBCC results for 'BADGE_EXPECTED_PASSAGE'.There are 0 rows in 0 pages for object 'BADGE_EXPECTED_PASSAGE'.DBCC results for 'ALARM'.There are 1249 rows in 18 pages for object 'ALARM'.DBCC results for 'EA_RESULTCOL_CFG'.There are 1 rows in 1 pages for object 'EA_RESULTCOL_CFG'.DBCC results for 'REPORTCFG'.There are 126 rows in 5 pages for object 'REPORTCFG'.DBCC results for 'EVENTGRP'.There are 1 rows in 1 pages for object 'EVENTGRP'.DBCC results for 'VISIT_RESTORED'.There are 0 rows in 0 pages for object 'VISIT_RESTORED'.DBCC results for 'SNMP_MIB_DATA'.There are 0 rows in 0 pages for object 'SNMP_MIB_DATA'.DBCC results for 'ALARMINPUT'.There are 48 rows in 2 pages for object 'ALARMINPUT'.DBCC results for 'EA_RESULTCOL_DDFLD_LINK'.There are 5 rows in 1 pages for object 'EA_RESULTCOL_DDFLD_LINK'.DBCC results for 'RESISTOR'.There are 0 rows in 0 pages for object 'RESISTOR'.DBCC results for 'EVENTGRPLNK'.There are 316 rows in 2 pages for object 'EVENTGRPLNK'.DBCC results for 'GOS_EA_ALERT'.There are 0 rows in 0 pages for object 'GOS_EA_ALERT'.DBCC results for 'EVENTS_VIDEO_RESTORED'.There are 0 rows in 0 pages for object 'EVENTS_VIDEO_RESTORED'.DBCC results for 'SNMP_AGENT'.There are 0 rows in 0 pages for object 'SNMP_AGENT'.DBCC results for 'ALARMMASKGROUP'.There are 0 rows in 0 pages for object 'ALARMMASKGROUP'.DBCC results for 'USER_LNL_DB_LINK'.There are 0 rows in 0 pages for object 'USER_LNL_DB_LINK'.DBCC results for 'SAVEDEVENTS'.There are 2611 rows in 41 pages for object 'SAVEDEVENTS'.DBCC results for 'EVENT_PARAM'.There are 340 rows in 4 pages for object 'EVENT_PARAM'.DBCC results for 'ACTION_REPLICATOR'.There are 0 rows in 0 pages for object 'ACTION_REPLICATOR'.DBCC results for 'OPC_SOURCE'.There are 0 rows in 0 pages for object 'OPC_SOURCE'.DBCC results for 'ALARMMASKGROUPLINK'.There are 0 rows in 0 pages for object 'ALARMMASKGROUPLINK'.DBCC results for 'AUTO_TOUR_ACTION'.There are 0 rows in 0 pages for object 'AUTO_TOUR_ACTION'.DBCC results for 'VERSIT'.There are 29 rows in 1 pages for object 'VERSIT'.DBCC results for 'EVENT_TO_EVENT_PARAM_LINK'.There are 936 rows in 3 pages for object 'EVENT_TO_EVENT_PARAM_LINK'.DBCC results for 'USER_PTZ_PRIORITY'.There are 4 rows in 1 pages for object 'USER_PTZ_PRIORITY'.DBCC results for 'GSC'.There are 46 rows in 1 pages for object 'GSC'.DBCC results for 'ALARMPANEL'.There are 4 rows in 1 pages for object 'ALARMPANEL'.DBCC results for 'AUTO_TOUR_MONSTATION_LINK'.There are 0 rows in 0 pages for object 'AUTO_TOUR_MONSTATION_LINK'.DBCC results for 'ASSET_CLASS'.There are 0 rows in 0 pages for object 'ASSET_CLASS'.DBCC results for 'EVENTS'.There are 3692794 rows in 53947 pages for object 'EVENTS'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'EVENTS' (object ID 562101043).DBCC results for 'LNL_DIRECTORY'.There are 1 rows in 1 pages for object 'LNL_DIRECTORY'.DBCC results for 'SWEVENT_GUARANTEE'.There are 0 rows in 0 pages for object 'SWEVENT_GUARANTEE'.DBCC results for 'DMV'.There are 29 rows in 1 pages for object 'DMV'.DBCC results for 'ASSET_GROUP_ASSET_CLASS_LINK'.There are 0 rows in 0 pages for object 'ASSET_GROUP_ASSET_CLASS_LINK'.DBCC results for 'PTZ_PRIORITY_LOCK'.There are 0 rows in 0 pages for object 'PTZ_PRIORITY_LOCK'.DBCC results for 'ALARMPANELLINKS'.There are 0 rows in 0 pages for object 'ALARMPANELLINKS'.DBCC results for 'IVCHANNELCONFIG'.There are 0 rows in 0 pages for object 'IVCHANNELCONFIG'.DBCC results for 'EVENTS_GUARANTEE'.There are 0 rows in 0 pages for object 'EVENTS_GUARANTEE'.DBCC results for 'CAC'.There are 41 rows in 1 pages for object 'CAC'.DBCC results for 'ASSET_ASSET_CLASS_LINK'.There are 0 rows in 0 pages for object 'ASSET_ASSET_CLASS_LINK'.DBCC results for 'SEGMENT_GROUP_MEMBER'.There are 0 rows in 0 pages for object 'SEGMENT_GROUP_MEMBER'.DBCC results for 'ALARMSACK'.There are 30309 rows in 239 pages for object 'ALARMSACK'.DBCC results for 'EVENTS_GUARANTEE_DONE'.There are 0 rows in 0 pages for object 'EVENTS_GUARANTEE_DONE'.DBCC results for 'CISCO_AIC_DEVICE'.There are 0 rows in 0 pages for object 'CISCO_AIC_DEVICE'.DBCC results for 'CAMERA_PRESET_TOUR'.There are 0 rows in 0 pages for object 'CAMERA_PRESET_TOUR'.DBCC results for 'CHASSIS'.There are 3 rows in 1 pages for object 'CHASSIS'.DBCC results for 'STAZONLINK'.There are 4 rows in 1 pages for object 'STAZONLINK'.DBCC results for 'EVENTS_LASTSERIALNUM'.There are 44 rows in 1 pages for object 'EVENTS_LASTSERIALNUM'.DBCC results for 'ALARMSACK_RESTORED'.There are 0 rows in 0 pages for object 'ALARMSACK_RESTORED'.DBCC results for 'USER_ACCOUNT'.There are 23 rows in 4 pages for object 'USER_ACCOUNT'.DBCC results for 'TWO_MAN_TYPE'.There are 3 rows in 1 pages for object 'TWO_MAN_TYPE'.DBCC results for 'PURGE_HISTORYLOGS_ACTION'.There are 0 rows in 0 pages for object 'PURGE_HISTORYLOGS_ACTION'.DBCC results for 'CAMERA_PRESET_COMMAND'.There are 0 rows in 0 pages for object 'CAMERA_PRESET_COMMAND'.DBCC results for 'LOCKSET_MEMORY'.There are 1 rows in 1 pages for object 'LOCKSET_MEMORY'.DBCC results for 'SYSTEMCARDS'.There are 1 rows in 1 pages for object 'SYSTEMCARDS'.DBCC results for 'EVENTS_RESTORED'.There are 0 rows in 0 pages for object 'EVENTS_RESTORED'.DBCC results for 'ARCHIVE_CONFIG'.There are 6 rows in 1 pages for object 'ARCHIVE_CONFIG'.DBCC results for 'SINGLE_DEVICE_ACTION'.There are 0 rows in 0 pages for object 'SINGLE_DEVICE_ACTION'.DBCC results for 'SWEVENT_GUARANTEE_DONE'.There are 0 rows in 0 pages for object 'SWEVENT_GUARANTEE_DONE'.DBCC results for 'PROCESSORTYPE'.There are 3 rows in 1 pages for object 'PROCESSORTYPE'.DBCC results for 'HWTRANS_REPL'.There are 0 rows in 0 pages for object 'HWTRANS_REPL'.DBCC results for 'IVPROCESSORS_IN_USE'.There are 1 rows in 1 pages for object 'IVPROCESSORS_IN_USE'.DBCC results for 'ARCHIVE_DETAIL'.There are 29 rows in 1 pages for object 'ARCHIVE_DETAIL'.DBCC results for 'DEVICE_GROUP_ACTION'.There are 0 rows in 0 pages for object 'DEVICE_GROUP_ACTION'.DBCC results for 'EVENTCRITERIA'.There are 0 rows in 0 pages for object 'EVENTCRITERIA'.DBCC results for 'WORLDTZ_BAK'.There are 62 rows in 2 pages for object 'WORLDTZ_BAK'.DBCC results for 'AREAAPB'.There are 1 rows in 1 pages for object 'AREAAPB'.DBCC results for 'MUSTER_INITIATION_ACTION'.There are 0 rows in 0 pages for object 'MUSTER_INITIATION_ACTION'.DBCC results for 'TEXT_BASED_EVENTS'.There are 0 rows in 0 pages for object 'TEXT_BASED_EVENTS'.DBCC results for 'EVENTS_REPL'.There are 0 rows in 0 pages for object 'EVENTS_REPL'.DBCC results for 'SUPPORTED_BIOMETRIC_TYPES'.There are 0 rows in 0 pages for object 'SUPPORTED_BIOMETRIC_TYPES'.DBCC results for 'TEXTOBJ'.There are 1249 rows in 13 pages for object 'TEXTOBJ'.DBCC results for 'EVENTYPE'.There are 27 rows in 1 pages for object 'EVENTYPE'.DBCC results for 'ASSET_TYPE'.There are 1 rows in 1 pages for object 'ASSET_TYPE'.DBCC results for 'AREATZCTLIST'.There are 0 rows in 0 pages for object 'AREATZCTLIST'.DBCC results for 'SWEVENT'.There are 0 rows in 0 pages for object 'SWEVENT'.DBCC results for 'TIMEZONE'.There are 5 rows in 1 pages for object 'TIMEZONE'.DBCC results for 'EVTALMLINK'.There are 1249 rows in 6 pages for object 'EVTALMLINK'.DBCC results for 'ASSET_SUBTYPE'.There are 1 rows in 1 pages for object 'ASSET_SUBTYPE'.DBCC results for 'POS_REGISTER'.There are 0 rows in 0 pages for object 'POS_REGISTER'.DBCC results for 'MU_ALARM_MASK_GROUP_ACTION'.There are 0 rows in 0 pages for object 'MU_ALARM_MASK_GROUP_ACTION'.DBCC results for 'TITLE'.There are 1 rows in 1 pages for object 'TITLE'.DBCC results for 'ASSET_LASTLOCATION'.There are 0 rows in 0 pages for object 'ASSET_LASTLOCATION'.DBCC results for 'REPL_SCHEDULE'.There are 0 rows in 0 pages for object 'REPL_SCHEDULE'.DBCC results for 'TRANSLOG'.There are 0 rows in 0 pages for object 'TRANSLOG'.DBCC results for 'VISITOR_SIGNOUT_ACTION'.There are 0 rows in 0 pages for object 'VISITOR_SIGNOUT_ACTION'.DBCC results for 'ARCHIVE_PURGE_DATABASE_ACTION'.There are 1 rows in 1 pages for object 'ARCHIVE_PURGE_DATABASE_ACTION'.DBCC results for 'TZINTERVAL'.There are 6 rows in 1 pages for object 'TZINTERVAL'.DBCC results for 'FAILEDRPC'.There are 0 rows in 1 pages for object 'FAILEDRPC'.DBCC results for 'ASSET_GROUP'.There are 1 rows in 1 pages for object 'ASSET_GROUP'.DBCC results for 'CONTINUOUS_VIDEO'.There are 0 rows in 0 pages for object 'CONTINUOUS_VIDEO'.DBCC results for 'DEACTIVATE_BADGE_ACTION'.There are 0 rows in 0 pages for object 'DEACTIVATE_BADGE_ACTION'.DBCC results for 'INTERCOM_CALL_ACTION'.There are 0 rows in 0 pages for object 'INTERCOM_CALL_ACTION'.DBCC results for 'UDFEMP'.There are 1 rows in 1 pages for object 'UDFEMP'.DBCC results for 'EMP'.There are 1 rows in 1 pages for object 'EMP'.DBCC results for 'FLOORLINK'.There are 128 rows in 1 pages for object 'FLOORLINK'.DBCC results for 'CHANGE_PASSWORD_ACTION'.There are 0 rows in 0 pages for object 'CHANGE_PASSWORD_ACTION'.DBCC results for 'ISC_DATABASE_DOWNLOAD_ACTION'.There are 0 rows in 0 pages for object 'ISC_DATABASE_DOWNLOAD_ACTION'.DBCC results for 'LNL_RELATION'.There are 11 rows in 1 pages for object 'LNL_RELATION'.DBCC results for 'UDFOBJS'.There are 202 rows in 7 pages for object 'UDFOBJS'.DBCC results for 'NET_DOMAIN'.There are 0 rows in 0 pages for object 'NET_DOMAIN'.DBCC results for 'FLOORLIST'.There are 3 rows in 1 pages for object 'FLOORLIST'.DBCC results for 'CHANGE_PASSWORD_DEVICE'.There are 0 rows in 0 pages for object 'CHANGE_PASSWORD_DEVICE'.DBCC results for 'CARD_PRINTER_TYPE'.There are 8 rows in 1 pages for object 'CARD_PRINTER_TYPE'.DBCC results for 'ISC_DATABASE_DOWNLOAD_PANEL'.There are 0 rows in 0 pages for object 'ISC_DATABASE_DOWNLOAD_PANEL'.DBCC results for 'IVAPPLICATION'.There are 0 rows in 0 pages for object 'IVAPPLICATION'.DBCC results for 'NET_EMP_SID'.There are 0 rows in 0 pages for object 'NET_EMP_SID'.DBCC results for 'GIOFUNCLIST'.There are 0 rows in 0 pages for object 'GIOFUNCLIST'.DBCC results for 'TEXT_LIBRARY'.There are 0 rows in 0 pages for object 'TEXT_LIBRARY'.DBCC results for 'SEGMENT'.There are 1 rows in 1 pages for object 'SEGMENT'.DBCC results for 'ISC_FIRMWARE_DOWNLOAD_ACTION'.There are 0 rows in 0 pages for object 'ISC_FIRMWARE_DOWNLOAD_ACTION'.DBCC results for 'ENCODER'.There are 0 rows in 0 pages for object 'ENCODER'.DBCC results for 'GIOFUNCLISTLINK'.There are 0 rows in 0 pages for object 'GIOFUNCLISTLINK'.DBCC results for 'IVAPPLICATIONTYPE'.There are 0 rows in 0 pages for object 'IVAPPLICATIONTYPE'.DBCC results for 'CCTVDEVICE_FAILOVER'.There are 0 rows in 0 pages for object 'CCTVDEVICE_FAILOVER'.DBCC results for 'HOLIDAYS'.There are 1 rows in 1 pages for object 'HOLIDAYS'.DBCC results for 'ISC_FIRMWARE_DOWNLOAD_PANEL'.There are 0 rows in 0 pages for object 'ISC_FIRMWARE_DOWNLOAD_PANEL'.DBCC results for 'IVAPP_CRITERIA_LOCK'.There are 0 rows in 0 pages for object 'IVAPP_CRITERIA_LOCK'.DBCC results for 'UDFPAGES'.There are 2 rows in 1 pages for object 'UDFPAGES'.DBCC results for 'USER_PERM_DEVICE_GROUP_LINK'.There are 0 rows in 0 pages for object 'USER_PERM_DEVICE_GROUP_LINK'.DBCC results for 'PTZ_SERVER_TYPE'.There are 5 rows in 1 pages for object 'PTZ_SERVER_TYPE'.DBCC results for 'HOLIDAY_TYPE'.There are 8 rows in 1 pages for object 'HOLIDAY_TYPE'.DBCC results for 'RESET_GLOBAL_APB_ACTION'.There are 0 rows in 0 pages for object 'RESET_GLOBAL_APB_ACTION'.DBCC results for 'PANEL_SELECTIVE_DOWNLOAD'.There are 0 rows in 0 pages for object 'PANEL_SELECTIVE_DOWNLOAD'.DBCC results for 'USER_PERM'.There are 12 rows in 1 pages for object 'USER_PERM'.DBCC results for 'ACCTRANS_OPERATION'.There are 60 rows in 1 pages for object 'ACCTRANS_OPERATION'.DBCC results for 'BADGETYPE_CARDFORMAT_LINK'.There are 0 rows in 0 pages for object 'BADGETYPE_CARDFORMAT_LINK'.DBCC results for 'AIMS'.There are 0 rows in 0 pages for object 'AIMS'.DBCC results for 'HOLIDAY_LNK'.There are 1 rows in 1 pages for object 'HOLIDAY_LNK'.DBCC results for 'RESET_GLOBAL_APB_SEGMENT'.There are 0 rows in 0 pages for object 'RESET_GLOBAL_APB_SEGMENT'.DBCC results for 'ACCTRANS_OBJECT'.There are 128 rows in 1 pages for object 'ACCTRANS_OBJECT'.DBCC results for 'USER_PERM_UDF'.There are 2 rows in 1 pages for object 'USER_PERM_UDF'.DBCC results for 'IDS_ALLOCATED'.There are 0 rows in 0 pages for object 'IDS_ALLOCATED'.DBCC results for 'REPORT_PRINT_ACTION'.There are 0 rows in 0 pages for object 'REPORT_PRINT_ACTION'.DBCC results for 'BADGE_ENCODING'.There are 0 rows in 0 pages for object 'BADGE_ENCODING'.DBCC results for 'LASTLOCATION_REPL'.There are 0 rows in 0 pages for object 'LASTLOCATION_REPL'.DBCC results for 'USER_PERM_UDF_FIELDS'.There are 161 rows in 2 pages for object 'USER_PERM_UDF_FIELDS'.DBCC results for 'IE_ACISFLDS'.There are 0 rows in 0 pages for object 'IE_ACISFLDS'.DBCC results for 'CONTINUOUS_VIDEO_RESTORED'.There are 0 rows in 0 pages for object 'CONTINUOUS_VIDEO_RESTORED'.DBCC results for 'DESERVERHOST'.There are 0 rows in 0 pages for object 'DESERVERHOST'.DBCC results for 'USER_PERM_UDF_PAGES'.There are 2 rows in 1 pages for object 'USER_PERM_UDF_PAGES'.DBCC results for 'IE_ACISINI'.There are 0 rows in 0 pages for object 'IE_ACISINI'.DBCC results for 'LASTLOCATION_REPL_STAGE'.There are 0 rows in 0 pages for object 'LASTLOCATION_REPL_STAGE'.DBCC results for 'CCTVDEVICE_IO'.There are 0 rows in 0 pages for object 'CCTVDEVICE_IO'.DBCC results for 'IE_RELATION'.There are 0 rows in 0 pages for object 'IE_RELATION'.DBCC results for 'ASSET'.There are 0 rows in 0 pages for object 'ASSET'.DBCC results for 'DE_ACTION'.There are 0 rows in 0 pages for object 'DE_ACTION'.DBCC results for 'ACCOUNT'.There are 0 rows in 0 pages for object 'ACCOUNT'.DBCC results for 'USER_PERM_REPORT_GROUP'.There are 0 rows in 0 pages for object 'USER_PERM_REPORT_GROUP'.DBCC results for 'INTERCOM_STATION'.There are 0 rows in 0 pages for object 'INTERCOM_STATION'.DBCC results for 'LNL_DEFAULT'.There are 0 rows in 0 pages for object 'LNL_DEFAULT'.DBCC results for 'DE_CONDITION'.There are 0 rows in 0 pages for object 'DE_CONDITION'.DBCC results for 'USERS'.There are 24 rows in 1 pages for object 'USERS'.DBCC results for 'DE_CONFIGURATION'.There are 0 rows in 0 pages for object 'DE_CONFIGURATION'.DBCC results for 'ACCOUNT_ZONE'.There are 0 rows in 0 pages for object 'ACCOUNT_ZONE'.DBCC results for 'LASTLOCATION'.There are 0 rows in 0 pages for object 'LASTLOCATION'.DBCC results for 'ASSET_ASSIGNMENT'.There are 0 rows in 0 pages for object 'ASSET_ASSIGNMENT'.DBCC results for 'ACCOUNT_AREA'.There are 0 rows in 0 pages for object 'ACCOUNT_AREA'.DBCC results for 'LOGON_AUTH'.There are 1 rows in 1 pages for object 'LOGON_AUTH'.DBCC results for 'USER_SEGMENT_LINK'.There are 0 rows in 0 pages for object 'USER_SEGMENT_LINK'.DBCC results for 'MONITOR_CCTV_DEVICE_LINK'.There are 0 rows in 0 pages for object 'MONITOR_CCTV_DEVICE_LINK'.DBCC results for 'LAYGRAPH'.There are 6 rows in 1 pages for object 'LAYGRAPH'.DBCC results for 'AUDIO'.There are 0 rows in 0 pages for object 'AUDIO'.DBCC results for 'DE_EXCHANGE_MAP'.There are 0 rows in 0 pages for object 'DE_EXCHANGE_MAP'.DBCC results for 'EVENT_CODE_TEMPLATE'.There are 18 rows in 1 pages for object 'EVENT_CODE_TEMPLATE'.DBCC results for 'VISITOR_UDF'.There are 0 rows in 0 pages for object 'VISITOR_UDF'.DBCC results for 'DE_EXPRESSION'.There are 0 rows in 0 pages for object 'DE_EXPRESSION'.DBCC results for 'LAYOUTS'.There are 1 rows in 1 pages for object 'LAYOUTS'.DBCC results for 'BADGE'.There are 1 rows in 1 pages for object 'BADGE'.DBCC results for 'DE_IO_DEFINITION'.There are 0 rows in 0 pages for object 'DE_IO_DEFINITION'.DBCC results for 'BADGE_USES_LEFT_PER_PANEL'.There are 0 rows in 0 pages for object 'BADGE_USES_LEFT_PER_PANEL'.DBCC results for 'EVENT_CODE_MAP'.There are 1284 rows in 6 pages for object 'EVENT_CODE_MAP'.DBCC results for 'VISIT'.There are 0 rows in 0 pages for object 'VISIT'.DBCC results for 'DE_IO_SET_DEFINITION'.There are 0 rows in 0 pages for object 'DE_IO_SET_DEFINITION'.DBCC results for 'LINEPRINTER_COLUMN'.There are 0 rows in 0 pages for object 'LINEPRINTER_COLUMN'.DBCC results for 'DE_IO_SET_LINK'.There are 0 rows in 0 pages for object 'DE_IO_SET_LINK'.DBCC results for 'TOUR'.There are 0 rows in 0 pages for object 'TOUR'.DBCC results for 'WORLDTZ'.There are 85 rows in 2 pages for object 'WORLDTZ'.DBCC results for 'DE_IO_SET_UNIT'.There are 0 rows in 0 pages for object 'DE_IO_SET_UNIT'.DBCC results for 'LINEPRINTER_LAYOUT'.There are 0 rows in 0 pages for object 'LINEPRINTER_LAYOUT'.DBCC results for 'TOUR_CHECKPOINT'.There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT'.DBCC results for 'WRKLAYLNK'.There are 0 rows in 0 pages for object 'WRKLAYLNK'.DBCC results for 'DE_LOOKUP_PARAM'.There are 0 rows in 0 pages for object 'DE_LOOKUP_PARAM'.DBCC results for 'LINKAGESERVERHOST'.There are 1 rows in 1 pages for object 'LINKAGESERVERHOST'.DBCC results for 'LINXPROCCMDS'.There are 0 rows in 0 pages for object 'LINXPROCCMDS'.DBCC results for 'TOUR_CHECKPOINT_ACTION'.There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT_ACTION'.DBCC results for 'DE_OPERATION'.There are 0 rows in 0 pages for object 'DE_OPERATION'.DBCC results for 'LNR_SOURCE_CAPS'.There are 0 rows in 0 pages for object 'LNR_SOURCE_CAPS'.DBCC results for 'GOS_DEVICE'.There are 1 rows in 1 pages for object 'GOS_DEVICE'.DBCC results for 'LNLCONFIG'.There are 18 rows in 2 pages for object 'LNLCONFIG'.DBCC results for 'BADGELINK'.There are 0 rows in 0 pages for object 'BADGELINK'.DBCC results for 'TOUR_CHECKPOINT_MESSAGE'.There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT_MESSAGE'.DBCC results for 'FIRE_DEVICES'.There are 0 rows in 0 pages for object 'FIRE_DEVICES'.DBCC results for 'LNL_DB'.There are 0 rows in 0 pages for object 'LNL_DB'.DBCC results for 'BADGETYP'.There are 4 rows in 1 pages for object 'BADGETYP'.DBCC results for 'TOUR_MONSTATION'.There are 0 rows in 0 pages for object 'TOUR_MONSTATION'.DBCC results for 'FIRE_DEVICE_INPUTS_OUTPUTS'.There are 0 rows in 0 pages for object 'FIRE_DEVICE_INPUTS_OUTPUTS'.DBCC results for 'GOS_ALARMMESSAGELINK'.There are 1 rows in 1 pages for object 'GOS_ALARMMESSAGELINK'.DBCC results for 'BADGEID_RANGE'.There are 0 rows in 0 pages for object 'BADGEID_RANGE'.DBCC results for 'TOUR_LIST'.There are 0 rows in 0 pages for object 'TOUR_LIST'.DBCC results for 'RESET_USE_LIMIT_ACTION'.There are 0 rows in 0 pages for object 'RESET_USE_LIMIT_ACTION'.DBCC results for 'GOS_RECIPIENT'.There are 0 rows in 1 pages for object 'GOS_RECIPIENT'.DBCC results for 'TOUR_LIST_LINK'.There are 0 rows in 0 pages for object 'TOUR_LIST_LINK'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'LOCATION'.There are 1 rows in 1 pages for object 'LOCATION'.DBCC results for 'RESET_USE_LIMIT_PANEL'.There are 0 rows in 0 pages for object 'RESET_USE_LIMIT_PANEL'.DBCC results for 'GOS_RECIPIENTADDRESS'.There are 0 rows in 1 pages for object 'GOS_RECIPIENTADDRESS'.DBCC results for 'LPRIORITY'.There are 4 rows in 1 pages for object 'LPRIORITY'.DBCC results for 'TOUR_EMP_TOUR_LIST_LINK'.There are 0 rows in 0 pages for object 'TOUR_EMP_TOUR_LIST_LINK'.DBCC results for 'EOL_TABLE'.There are 4 rows in 1 pages for object 'EOL_TABLE'.DBCC results for 'GOS_MESSAGERECIPIENT'.There are 0 rows in 1 pages for object 'GOS_MESSAGERECIPIENT'.DBCC results for 'MAP'.There are 1 rows in 1 pages for object 'MAP'.DBCC results for 'TOUR_LOG'.There are 0 rows in 0 pages for object 'TOUR_LOG'.DBCC results for 'EOL_TABLE_LINK'.There are 0 rows in 0 pages for object 'EOL_TABLE_LINK'.DBCC results for 'ALARMVIDEOCONFIG'.There are 4 rows in 1 pages for object 'ALARMVIDEOCONFIG'.DBCC results for 'MAPICON'.There are 134 rows in 2 pages for object 'MAPICON'.DBCC results for 'BADGETYPE_SEGMENT_LINK'.There are 0 rows in 0 pages for object 'BADGETYPE_SEGMENT_LINK'.DBCC results for 'INTRUSION_DEVICE'.There are 0 rows in 0 pages for object 'INTRUSION_DEVICE'.DBCC results for 'MAPICONGRP'.There are 43 rows in 1 pages for object 'MAPICONGRP'.DBCC results for 'ACTION_TYPE'.There are 38 rows in 1 pages for object 'ACTION_TYPE'.DBCC results for 'CCTV_DEVICE_LINK'.There are 94 rows in 3 pages for object 'CCTV_DEVICE_LINK'.DBCC results for 'BADGSTAT'.There are 4 rows in 1 pages for object 'BADGSTAT'.DBCC results for 'CAMERATYPE'.There are 37 rows in 1 pages for object 'CAMERATYPE'.DBCC results for 'MAPICONGRP_MEMBER'.There are 143 rows in 1 pages for object 'MAPICONGRP_MEMBER'.DBCC results for 'ACTION'.There are 1 rows in 1 pages for object 'ACTION'.DBCC results for 'CCTVDEVICE'.There are 202 rows in 10 pages for object 'CCTVDEVICE'.DBCC results for 'SERVERCAMERATYPE'.There are 37 rows in 1 pages for object 'SERVERCAMERATYPE'.DBCC results for 'MAPITEM'.There are 48 rows in 1 pages for object 'MAPITEM'.DBCC results for 'ACTION_LOG'.There are 29 rows in 1 pages for object 'ACTION_LOG'.DBCC results for 'BDGPRECLINK'.There are 0 rows in 0 pages for object 'BDGPRECLINK'.DBCC results for 'VISIT_EMAIL_LINK'.There are 0 rows in 0 pages for object 'VISIT_EMAIL_LINK'.DBCC results for 'DEFAULTMAPICON'.There are 56 rows in 1 pages for object 'DEFAULTMAPICON'.DBCC results for 'BDGREQFLDLINK'.There are 0 rows in 0 pages for object 'BDGREQFLDLINK'.DBCC results for 'ACTION_GROUP'.There are 0 rows in 1 pages for object 'ACTION_GROUP'.DBCC results for 'MARKEDVIDEO'.There are 0 rows in 1 pages for object 'MARKEDVIDEO'.DBCC results for 'BUILDING'.There are 1 rows in 1 pages for object 'BUILDING'.DBCC results for 'MMOBJS'.There are 3 rows in 1 pages for object 'MMOBJS'.DBCC results for 'CARDFORMAT'.There are 13 rows in 1 pages for object 'CARDFORMAT'.DBCC results for 'SEGMENT_EMAIL_LINK'.There are 0 rows in 0 pages for object 'SEGMENT_EMAIL_LINK'.DBCC results for 'EXECFUNCLISTACTION'.There are 0 rows in 0 pages for object 'EXECFUNCLISTACTION'.DBCC results for 'ACTION_SCHEDULE'.There are 1 rows in 1 pages for object 'ACTION_SCHEDULE'.DBCC results for 'MMOBJTYPS'.There are 2 rows in 1 pages for object 'MMOBJTYPS'.DBCC results for 'WRKSTATION'.There are 2 rows in 1 pages for object 'WRKSTATION'.DBCC results for 'VISIT_SEARCH'.There are 2 rows in 1 pages for object 'VISIT_SEARCH'.DBCC results for 'EXPECTED_TRANSACTION_TIME'.There are 0 rows in 0 pages for object 'EXPECTED_TRANSACTION_TIME'.DBCC results for 'MOBILE_ID_CONTROL'.There are 10 rows in 1 pages for object 'MOBILE_ID_CONTROL'.DBCC results for 'VISIT_SEARCH_ELEMENT'.There are 58 rows in 1 pages for object 'VISIT_SEARCH_ELEMENT'.DBCC results for 'ARCHIVELOCATION'.There are 2 rows in 1 pages for object 'ARCHIVELOCATION'.DBCC results for 'ACCOUNT_GROUP'.There are 0 rows in 0 pages for object 'ACCOUNT_GROUP'.DBCC results for 'MONDEVLINK'.There are 22 rows in 2 pages for object 'MONDEVLINK'.DBCC results for 'CARDFORMAT_SEGMENT_LINK'.There are 0 rows in 0 pages for object 'CARDFORMAT_SEGMENT_LINK'.DBCC results for 'EVENTS_VIDEO'.There are 39 rows in 1 pages for object 'EVENTS_VIDEO'.DBCC results for 'IPCAMERA_FW_DOWNLOAD_ACTION'.There are 0 rows in 0 pages for object 'IPCAMERA_FW_DOWNLOAD_ACTION'.DBCC results for 'ACCESSGRP'.There are 0 rows in 0 pages for object 'ACCESSGRP'.DBCC results for 'BADGE_AREA_LOCATION'.There are 0 rows in 0 pages for object 'BADGE_AREA_LOCATION'.DBCC results for 'MONSTATION'.There are 14 rows in 1 pages for object 'MONSTATION'.DBCC results for 'CCTVCONTROL'.There are 0 rows in 0 pages for object 'CCTVCONTROL'.DBCC results for 'IPCAMERA_FW_DOWNLOAD_CAMERA'.There are 0 rows in 0 pages for object 'IPCAMERA_FW_DOWNLOAD_CAMERA'.DBCC results for 'ACCESSLVL'.There are 0 rows in 0 pages for object 'ACCESSLVL'.DBCC results for 'MUSTER_ZONE_SAFE_LOCATIONS'.There are 0 rows in 0 pages for object 'MUSTER_ZONE_SAFE_LOCATIONS'.DBCC results for 'MONZONE'.There are 1 rows in 1 pages for object 'MONZONE'.DBCC results for 'DDCONNECT'.There are 1 rows in 1 pages for object 'DDCONNECT'.DBCC results for 'LNL_QUEUE'.There are 0 rows in 0 pages for object 'LNL_QUEUE'.DBCC results for 'ACCESSPANE'.There are 23 rows in 2 pages for object 'ACCESSPANE'.DBCC results for 'INPUT_EVENT'.There are 0 rows in 0 pages for object 'INPUT_EVENT'.DBCC results for 'PANELTYPE'.There are 60 rows in 1 pages for object 'PANELTYPE'.DBCC results for 'DDFLD'.There are 128 rows in 3 pages for object 'DDFLD'.CHECKDB found 0 allocation errors and 2 consistency errors in database 'AccessControl'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (AccessControl ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.Thanks,Steven Stuart |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-03-14 : 14:30:46
|
| Is the index on BIT columns?Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
 |
|
|
sstuart
Starting Member
5 Posts |
Posted - 2007-03-14 : 14:34:06
|
Hi Paul, The index is set to int, and length is 4, Allow Nulls is not checked.[quote]Originally posted by paulrandal
Is the index on BIT columns?Thanks,Steven Stuart |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-03-14 : 14:54:24
|
| ok - are you doing updates? If so, you may be running into a bug - checkout this KB article for details and a supported hotfix.Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
sstuart
Starting Member
5 Posts |
Posted - 2007-03-14 : 15:11:18
|
Hi paul, You forgot to put the link. Actually we had been deleting over a million records in that table. We may have solved the problem, by deleting all of the records from another table, which I did not see any relations, but maybe they were. However, when I last ran the DBCC CHECKDB after the deletion of all records in the other table, I see no consistency errors in Events or the other table. However, I think we got lucky by hitting that table for a different reason. [quote]Originally posted by paulrandal
ok - are you doing updates? If so, you may be running into a bug - checkout this KB article for details and a supported hotfix.Thanks,Steven Stuart |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-03-14 : 15:43:53
|
| Oops - sorry, trying to do too many things at once. Here's the link:http://support.microsoft.com/kb/929440/en-usPaul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
sstuart
Starting Member
5 Posts |
Posted - 2007-03-14 : 15:49:32
|
Hi Paul, Actually, no that was not what was happening. Those errors were showing while running the DBCC CHECKDB, so unless that is doing updates (which you would know. :), but I do not at least yet). Anyways, do you know if what I said in the previous note, could have fixed it, and how, and if there is a next time, is there a way for me to track the culprit down with the information that I had. [quote]Originally posted by paulrandal
Oops - sorry, trying to do too many things at once. Here's the link:http://support.microsoft.com/kb/929440/en-usThanks,Steven Stuart |
|
|
|
sstuart
Starting Member
5 Posts |
Posted - 2007-03-14 : 17:26:32
|
| Hi Paul, It looks like the error did not really go away. The same ObjectID is still showing up.Thanks,Steven Stuart |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-03-15 : 20:19:07
|
| Are there any other columns in the index, e.g. varchar?Can you do the following:DBCC TRACEON (3604)GODBCC PAGE (AccessControl, X, YYYYY, 3)GOWhere X and YYYYY come from one of the 2511 errors. E.g. forServer: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67702), slots 174 and 175.X would be 1 and YYYYY would be 67702Post the new set of DBCC errors and either post the results from DBCC PAGE, or if you don't feel comfortable with that and they're not customer confidential, email them to me - prandal@microsoft.comI'd like to see if the rows really are out of order.Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
|
|
|
|
|
DBCC CHECKDB consistency errors