Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- VOX
- :
- Communities
- :
- Protection
- :
- Backup Exec
- :
- On the SQL

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

V-79-57344-65085 - There was a problem running the DBCC

08-26-2015 04:40 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Hello

I have created a new backup job for a server containing an SQL database(s). However I get various instances of the "V-79-57344-65085 - There was a problem running the DBCC." error ,which I believe relates to inconsistency checks; which has caused the job to fail the last 2 nights. I have tried running dbcc manually through SQL on the affected databases and it comes back with 0 errors.

I am unsure how to proceed in fixing this job?

```
Job Log for NIMROD.BAL.local Backup 00043-Incremental
--------------------------------------------------------------------------------
Completed status: Failed See error(s)
Expand AllCollapse All
Job Information
Job server: BACKUP01
Job name: NIMROD.BAL.local Backup 00043-Incremental
Job started: Tuesday, August 25, 2015 at 7:00:03 PM
Job type: Backup
Job Log: BEX_BACKUP01_06371.xml
Drive and media mount requested: 8/25/2015 7:00:04 PM
Device and Media Information
Drive and media information from media mount: 8/25/2015 7:00:06 PM
Drive Name: Disk storage 0001
Media Label: B2D004747
Media GUID: {6e080236-bae8-4d59-aa5d-dc3fd557a981}
All Media Used
B2D004747
B2D004748
B2D004749
Job Operation - Backup
Backup Options
Media operation - Append to media, overwrite if no appendable media is available.
Compression Type: None
Encryption Type: None
Backup Set Retention Period: 1 Week.
Server - NIMROD.BAL.local
Note: Resource: "NIMROD.BAL.local\MSSQLSERVER" is not snappable. Attempting to back up directly from the source volume.
Network control connection is established between 10.8.2.8:55707 <--> 10.8.2.4:10000
Network data connection is established between 10.8.2.8:55708 <--> 10.8.2.4:50372
Database Consistency Checks
Consistency checking AB
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking BoltonStockTake
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking DataTakeOn
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking FIFO_Backup
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking helpdesk
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking NewTraining
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Consistency checking ReportServer
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking ReportServerTempDB
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
Consistency checking SiteServices
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking SO_PO_Restore
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking StockTakeTest
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking Test
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking Training
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking whd
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking WinMan
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Consistency checking WinManMaster
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
Set Information - NIMROD.BAL.local\MSSQLSERVER
Backup Set Information
Family Name: "Media created 8/25/2015 7:00:04 PM"
Backup of "NIMROD.BAL.local\MSSQLSERVER"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Backup Method: Log - Back up transaction log
Microsoft SQL Server Agent: Started
Backup started on 8/25/2015 at 9:14:32 PM.
Backup completed on 8/25/2015 at 9:14:33 PM.
Backup Set Summary
Processed 0 bytes in 1 second.
Throughput rate: 0.000 MB/min
This backup set may not contain any data.
Snapshot Technology: Started for resource: "\\NIMROD.BAL.local\D:". Snapshot technology used: Microsoft Volume Shadow Copy Service (VSS).
The snapshot technology used by VSS for volume D: - Microsoft Software Shadow Copy provider 1.0 (Version 1.0.0.7).
Drive and media mount requested: 8/25/2015 9:14:36 PM
No appendable media could be mounted.
Switching to overwrite operation on scratch media.
Drive and media information from media mount: 8/25/2015 9:14:38 PM
Drive Name: Disk storage 0001
Media Label: B2D004748
Media GUID: {edef265e-3c95-4772-9559-dd7fbe238c70}
Network control connection is established between 10.8.2.8:55707 <--> 10.8.2.4:10000
Network data connection is established between 10.8.2.8:52905 <--> 10.8.2.4:51004
Set Information - \\NIMROD.BAL.local\D:
Backup Set Information
Family Name: "Media created 8/25/2015 7:00:04 PM"
Backup of "\\NIMROD.BAL.local\D:"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Backup Method: Incremental - Using modified time
Backup started on 8/25/2015 at 9:15:04 PM.
Backup completed on 8/25/2015 at 9:15:11 PM.
Backup Set Summary
Backed up 402 files in 409 directories.
Processed 52,075,082 bytes in 7 seconds.
Throughput rate: 426 MB/min
Snapshot Technology: Started for resource: "\\NIMROD.BAL.local\C:". Snapshot technology used: Microsoft Volume Shadow Copy Service (VSS).
The snapshot technology used by VSS for volume C: - Microsoft Software Shadow Copy provider 1.0 (Version 1.0.0.7).
Drive and media mount requested: 8/25/2015 9:15:13 PM
No appendable media could be mounted.
Switching to overwrite operation on scratch media.
Drive and media information from media mount: 8/25/2015 9:15:16 PM
Drive Name: Disk storage 0001
Media Label: B2D004749
Media GUID: {e224467f-228a-46f7-90eb-2400dca0d5cf}
Network control connection is established between 10.8.2.8:55707 <--> 10.8.2.4:10000
Network data connection is established between 10.8.2.8:52988 <--> 10.8.2.4:51050
Set Information - \\NIMROD.BAL.local\C:
Backup Set Information
Family Name: "Media created 8/25/2015 7:00:04 PM"
Backup of "\\NIMROD.BAL.local\C:"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Backup Method: Incremental - Using modified time
Backup started on 8/25/2015 at 9:15:42 PM.
Backup completed on 8/25/2015 at 9:18:09 PM.
Backup Set Summary
Backed up 1053 files in 205 directories.
Processed 3,857,423,574 bytes in 2 minutes and 27 seconds.
Throughput rate: 1502 MB/min
Job Operation - Verify
Server - NIMROD.BAL.local
Drive and media mount requested: 8/25/2015 9:18:11 PM
Drive and media information from media mount: 8/25/2015 9:18:11 PM
Drive Name: Disk storage 0001
Media Label: B2D004747
Media GUID: {6e080236-bae8-4d59-aa5d-dc3fd557a981}
All Media Used
B2D004747
B2D004748
B2D004749
Set Information - NIMROD.BAL.local\MSSQLSERVER
Verify Set Information
Verify of "NIMROD.BAL.local\MSSQLSERVER "
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Verify started on 8/25/2015 at 9:18:11 PM.
Verify completed on 8/25/2015 at 9:18:11 PM.
Verify Set Summary
Processed 0 bytes in 1 second.
Throughput rate: 0.000 MB/min
Server - NIMROD.BAL.local
Drive and media mount requested: 8/25/2015 9:18:12 PM
Drive and media information from media mount: 8/25/2015 9:18:12 PM
Drive Name: Disk storage 0001
Media Label: B2D004748
Media GUID: {edef265e-3c95-4772-9559-dd7fbe238c70}
Set Information - \\NIMROD.BAL.local\D: Data
Verify Set Information
Verify of "\\NIMROD.BAL.local\D: Data"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Verify started on 8/25/2015 at 9:18:12 PM.
Verify completed on 8/25/2015 at 9:18:14 PM.
Verify Set Summary
Verified 402 files in 409 directories.
Processed 52,075,082 bytes in 2 seconds.
Throughput rate: 1490 MB/min
Server - NIMROD.BAL.local
Drive and media mount requested: 8/25/2015 9:18:15 PM
Drive and media information from media mount: 8/25/2015 9:18:15 PM
Drive Name: Disk storage 0001
Media Label: B2D004749
Media GUID: {e224467f-228a-46f7-90eb-2400dca0d5cf}
Set Information - \\NIMROD.BAL.local\C:
Verify Set Information
Verify of "\\NIMROD.BAL.local\C: "
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Verify started on 8/25/2015 at 9:18:15 PM.
Verify completed on 8/25/2015 at 9:18:45 PM.
Verify Set Summary
Verified 1053 files in 205 directories.
Processed 3,857,423,574 bytes in 30 seconds.
Throughput rate: 7357 MB/min
Job Completion Status
Job ended: Tuesday, August 25, 2015 at 9:18:46 PM
Completed status: Failed
Final error: 0xe0008443 - One or more SQL Database consistency checks have failed.
Final error category: Resource Errors
For additional information regarding this error refer to link V-79-57344-33859
Errors
Click an error below to locate it in the job log
Backup- NIMROD.BAL.localV-79-57344-65085 - There was a problem running the DBCC.
Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
V-79-57344-65085 - There was a problem running the DBCC.
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure
```

10 Replies

Highlighted
##

Disable Advanced Open File

CraigV

Partner
VIP
Accredited

08-26-2015 04:58 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Disable Advanced Open File Option if you're using it and run the backup again!

Thanks!

Highlighted
##

On the SQL server, enable

VJware

Employee
Accredited
Certified

08-26-2015 11:20 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

On the SQL server, enable TCP/IP and Named Pipes protocols. Restart the SQL instances and recheck.

Highlighted
##

Thanks for the replies and

08-30-2015 01:30 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Thanks for the replies and apologies in the slow response from me but I had to wait for some down time at work in order to try your suggestions.

I can confirm that both TCP/IP and Named Pipes protocols are already enabled on the SQL server.

I have now tried disabling the Advanced Open File options on the backup job but it still failed due to consistency checks. Something I don't understand about that is the fact that I have the box ticked for "continue job even if consistency checks fail".

Highlighted
##

Are there any events logged

VJware

Employee
Accredited
Certified

08-30-2015 09:14 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Are there any events logged in the event viewer corresponding to this error ?

```
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
```

Does the backup itself complete successfully without the consistency checks ?

Highlighted
##

Yes it does complete

08-31-2015 04:40 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Yes it does complete successfully if I turn consistency check off.

As for event logs should I be looking on the backup server or the SQL server?

On the SQL

VJware

Employee
Accredited
Certified

08-31-2015 08:43 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

On the SQL server.

Additionally, does the DBCC checks within SQL itself complete successfully ?

Highlighted
##

Running manual dbcc checks

09-02-2015 06:02 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Running manual dbcc checks within SQL return 0 errors.

As for logs, I found several errors relating to the incident, many of them relating to memory, but I'm not sure if this is a red herring.

How do I share event logs with you?

Highlighted
##

Click on my user name and you

VJware

Employee
Accredited
Certified

09-02-2015 07:02 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Click on my user name and you can either send me a private message or an email.

A quick query. Was the manual DBCC run using the same account as that of BE ?

Highlighted
##

I just checked and no; the BE

09-02-2015 09:43 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

I just checked and no; the BE is using the Windows logon/admin account whereas in SQL I was logging in with the database user instead. So I logged in with the admin account and ran the DBCC on a db again and got this

```
DBCC results for 'NewTraining'.
Msg 8921, Level 16, State 1, Line 2
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
DBCC results for 'sys.sysrscols'.
There are 9479 rows in 102 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 1204 rows in 24 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 1387 rows in 40 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 3 rows in 1 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 16 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 177 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 10534 rows in 246 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 31172 rows in 818 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 270 rows in 122 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 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 3895 rows in 89 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 4812 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.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 12781 rows in 4588 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 20 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 2344 rows in 19 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 73072 rows in 746 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 2 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 9 rows in 1 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 99 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 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 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 18503 rows in 280 pages for object "sys.syssoftobjrefs".
DBCC results for 'ProgramTree'.
There are 207 rows in 6 pages for object "ProgramTree".
DBCC results for 'FixedAssetTypes'.
There are 4 rows in 1 pages for object "FixedAssetTypes".
DBCC results for 'SupportCaseReasons'.
There are 4 rows in 1 pages for object "SupportCaseReasons".
DBCC results for 'UserIllnesses'.
There are 0 rows in 0 pages for object "UserIllnesses".
DBCC results for 'KanBanPurchaseItems'.
There are 0 rows in 0 pages for object "KanBanPurchaseItems".
DBCC results for 'PurchaseOrderItemsHistory'.
There are 1733 rows in 138 pages for object "PurchaseOrderItemsHistory".
DBCC results for 'TickleCategories'.
There are 5 rows in 1 pages for object "TickleCategories".
DBCC results for 'CommissionGroups'.
There are 0 rows in 0 pages for object "CommissionGroups".
DBCC results for 'bdt_FiFoAudit'.
There are 17324 rows in 327 pages for object "bdt_FiFoAudit".
DBCC results for 'JobStatuses'.
There are 0 rows in 0 pages for object "JobStatuses".
DBCC results for 'CustomFields'.
There are 92 rows in 5 pages for object "CustomFields".
DBCC results for 'ProductProductCategories'.
There are 0 rows in 0 pages for object "ProductProductCategories".
DBCC results for 'Regions'.
There are 128 rows in 2 pages for object "Regions".
DBCC results for 'CRMConversationItems'.
There are 0 rows in 0 pages for object "CRMConversationItems".
DBCC results for 'ExpressionRules'.
There are 0 rows in 0 pages for object "ExpressionRules".
DBCC results for 'WorkInProgress'.
There are 141614 rows in 14060 pages for object "WorkInProgress".
DBCC results for 'GLCategories'.
There are 8 rows in 1 pages for object "GLCategories".
DBCC results for 'Reports'.
There are 14 rows in 1 pages for object "Reports".
DBCC results for 'Manufacturers'.
There are 6 rows in 1 pages for object "Manufacturers".
DBCC results for 'StructureVersions'.
There are 13671 rows in 264 pages for object "StructureVersions".
DBCC results for 'Bdt_RawMaterialFIFO'.
There are 529 rows in 19 pages for object "Bdt_RawMaterialFIFO".
DBCC results for 'UsersSpeedDials'.
There are 0 rows in 0 pages for object "UsersSpeedDials".
DBCC results for 'SalesOrderSources'.
There are 0 rows in 0 pages for object "SalesOrderSources".
DBCC results for 'sys.ifts_comp_fragment_1111167204_129'.
There are 6 rows in 1 pages for object "sys.ifts_comp_fragment_1111167204_129".
DBCC results for 'ShippingTerms'.
There are 8 rows in 1 pages for object "ShippingTerms".
DBCC results for 'SecurityAreaDescriptions'.
There are 1 rows in 1 pages for object "SecurityAreaDescriptions".
DBCC results for 'ReturnedItems'.
There are 0 rows in 0 pages for object "ReturnedItems".
DBCC results for 'WorkInProgressRequirements'.
There are 1341 rows in 25 pages for object "WorkInProgressRequirements".
DBCC results for 'ConfiguredItemStructures'.
There are 0 rows in 0 pages for object "ConfiguredItemStructures".
DBCC results for 'JobPrefixDepartments'.
There are 0 rows in 0 pages for object "JobPrefixDepartments".
DBCC results for 'sys.ifts_comp_fragment_1111167204_131'.
There are 6 rows in 1 pages for object "sys.ifts_comp_fragment_1111167204_131".
DBCC results for 'ConfiguredComponentRules'.
There are 0 rows in 0 pages for object "ConfiguredComponentRules".
DBCC results for 'ProductOverheadTypes'.
There are 0 rows in 0 pages for object "ProductOverheadTypes".
DBCC results for 'sys.ifts_comp_fragment_1111167204_132'.
There are 6 rows in 1 pages for object "sys.ifts_comp_fragment_1111167204_132".
DBCC results for 'SalesOrderItemCommissions'.
There are 0 rows in 0 pages for object "SalesOrderItemCommissions".
DBCC results for 'ActivityTracking'.
There are 0 rows in 0 pages for object "ActivityTracking".
DBCC results for 'ConfiguredDimensionValues'.
There are 77770 rows in 2548 pages for object "ConfiguredDimensionValues".
DBCC results for 'CRMTaskStatuses'.
There are 2 rows in 1 pages for object "CRMTaskStatuses".
DBCC results for 'bdt_ChemicalTestResults'.
There are 37 rows in 2 pages for object "bdt_ChemicalTestResults".
DBCC results for 'CustomerCommissionAgents'.
There are 0 rows in 0 pages for object "CustomerCommissionAgents".
DBCC results for 'SProcProgress'.
There are 56 rows in 4 pages for object "SProcProgress".
DBCC results for 'CRMProjectStatuses'.
There are 1 rows in 1 pages for object "CRMProjectStatuses".
DBCC results for 'CRMContacts'.
There are 50 rows in 4 pages for object "CRMContacts".
DBCC results for 'CellManufacturingOrders'.
There are 0 rows in 0 pages for object "CellManufacturingOrders".
DBCC results for 'StockTake'.
There are 0 rows in 0 pages for object "StockTake".
DBCC results for 'CRMCompanies'.
There are 801 rows in 79 pages for object "CRMCompanies".
DBCC results for 'CRMConversationItemResponses'.
There are 0 rows in 0 pages for object "CRMConversationItemResponses".
DBCC results for 'Intrastats'.
There are 0 rows in 0 pages for object "Intrastats".
DBCC results for 'Structures'.
There are 54304 rows in 2605 pages for object "Structures".
DBCC results for 'bdt_BoltonTargets'.
There are 1160 rows in 33 pages for object "bdt_BoltonTargets".
DBCC results for 'sys.ifts_comp_fragment_1563152614_3807'.
There are 4250 rows in 40 pages for object "sys.ifts_comp_fragment_1563152614_3807".
DBCC results for 'ConfiguredItemRules'.
There are 0 rows in 0 pages for object "ConfiguredItemRules".
DBCC results for 'AccountingCalendar'.
There are 2192 rows in 29 pages for object "AccountingCalendar".
DBCC results for 'Styles'.
There are 2 rows in 1 pages for object "Styles".
DBCC results for 'bdt_ChemicalTestResultItems'.
There are 601 rows in 4 pages for object "bdt_ChemicalTestResultItems".
DBCC results for 'Classifications'.
There are 135 rows in 4 pages for object "Classifications".
DBCC results for 'CRMCampaigns'.
There are 0 rows in 0 pages for object "CRMCampaigns".
DBCC results for 'CommodityCodes'.
There are 4 rows in 1 pages for object "CommodityCodes".
DBCC results for 'ConfiguredItemValues'.
There are 329301 rows in 10858 pages for object "ConfiguredItemValues".
DBCC results for 'TaxCodes'.
There are 2 rows in 1 pages for object "TaxCodes".
DBCC results for 'ConfiguredSundries'.
There are 0 rows in 0 pages for object "ConfiguredSundries".
DBCC results for 'UserPreferences'.
There are 620 rows in 10 pages for object "UserPreferences".
DBCC results for 'DeliveryAddresses'.
There are 1017 rows in 51 pages for object "DeliveryAddresses".
DBCC results for 'ProductOverheads'.
There are 0 rows in 0 pages for object "ProductOverheads".
DBCC results for 'sys.fulltext_index_docidstatus_1563152614'.
There are 4 rows in 1 pages for object "sys.fulltext_index_docidstatus_1563152614".
DBCC results for 'CreditTerms'.
There are 14 rows in 1 pages for object "CreditTerms".
DBCC results for 'Users'.
There are 106 rows in 6 pages for object "Users".
DBCC results for 'TransportRoutes'.
There are 0 rows in 0 pages for object "TransportRoutes".
DBCC results for 'CommissionClasses'.
There are 0 rows in 0 pages for object "CommissionClasses".
DBCC results for 'sys.fulltext_docidfilter_1563152614'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1563152614".
DBCC results for 'Currencies'.
There are 3 rows in 1 pages for object "Currencies".
DBCC results for 'TimeSheets'.
There are 0 rows in 0 pages for object "TimeSheets".
DBCC results for 'SupplierProductContracts'.
There are 0 rows in 0 pages for object "SupplierProductContracts".
DBCC results for 'ProcessTestTypes'.
There are 0 rows in 0 pages for object "ProcessTestTypes".
DBCC results for 'WebComSites'.
There are 0 rows in 0 pages for object "WebComSites".
DBCC results for 'SiteProducts'.
There are 0 rows in 0 pages for object "SiteProducts".
DBCC results for 'sys.fulltext_indexeddocid_1563152614'.
There are 31957 rows in 72 pages for object "sys.fulltext_indexeddocid_1563152614".
DBCC results for 'Departments'.
There are 11 rows in 1 pages for object "Departments".
DBCC results for 'PerpetualInventory'.
There are 1 rows in 1 pages for object "PerpetualInventory".
DBCC results for 'WriteOffCodes'.
There are 9 rows in 1 pages for object "WriteOffCodes".
DBCC results for 'TransportAllocations'.
There are 0 rows in 0 pages for object "TransportAllocations".
DBCC results for 'sys.fulltext_avdl_1563152614'.
There are 6 rows in 1 pages for object "sys.fulltext_avdl_1563152614".
DBCC results for 'Discounts'.
There are 7 rows in 1 pages for object "Discounts".
DBCC results for 'GLAccountLogs'.
There are 11725 rows in 177 pages for object "GLAccountLogs".
DBCC results for 'WorkSchedules'.
There are 3 rows in 1 pages for object "WorkSchedules".
DBCC results for 'ReturnedItemsStatuses'.
There are 0 rows in 0 pages for object "ReturnedItemsStatuses".
DBCC results for 'GLAccountDepartments'.
There are 1 rows in 1 pages for object "GLAccountDepartments".
DBCC results for 'SupplierCrossReferences'.
There are 669 rows in 28 pages for object "SupplierCrossReferences".
DBCC results for 'FreeFormRelations'.
There are 6 rows in 1 pages for object "FreeFormRelations".
DBCC results for 'GLAccountDivisions'.
There are 1 rows in 1 pages for object "GLAccountDivisions".
DBCC results for 'ZipCodes'.
There are 42995 rows in 528 pages for object "ZipCodes".
DBCC results for 'bdt_ManufacturingOrderTestResults'.
There are 0 rows in 0 pages for object "bdt_ManufacturingOrderTestResults".
DBCC results for 'MatrixStyles'.
There are 2 rows in 1 pages for object "MatrixStyles".
DBCC results for 'CustomMatrixTables'.
There are 0 rows in 0 pages for object "CustomMatrixTables".
DBCC results for 'CashItems'.
There are 11445 rows in 673 pages for object "CashItems".
DBCC results for 'bdt_Specifications'.
There are 1286 rows in 37 pages for object "bdt_Specifications".
DBCC results for 'Industries'.
There are 1 rows in 1 pages for object "Industries".
DBCC results for 'TransportAllocationPrintHistory'.
There are 0 rows in 0 pages for object "TransportAllocationPrintHistory".
DBCC results for 'Solutions'.
There are 0 rows in 0 pages for object "Solutions".
DBCC results for 'ConfiguredConfigurations'.
There are 6599 rows in 342 pages for object "ConfiguredConfigurations".
DBCC results for 'CustomTable01'.
There are 0 rows in 0 pages for object "CustomTable01".
DBCC results for 'Locations'.
There are 322 rows in 10 pages for object "Locations".
DBCC results for 'DiscountBreaks'.
There are 0 rows in 0 pages for object "DiscountBreaks".
DBCC results for 'bdt_SpecificationRelations'.
There are 1212 rows in 24 pages for object "bdt_SpecificationRelations".
DBCC results for 'JobPrefixes'.
There are 1 rows in 1 pages for object "JobPrefixes".
DBCC results for 'Letters'.
There are 0 rows in 0 pages for object "Letters".
DBCC results for 'ProgramProfiles'.
There are 925 rows in 51 pages for object "ProgramProfiles".
DBCC results for 'FreeFormLinks'.
There are 99 rows in 2 pages for object "FreeFormLinks".
DBCC results for 'CommissionSetup'.
There are 0 rows in 0 pages for object "CommissionSetup".
DBCC results for 'Countries'.
There are 246 rows in 6 pages for object "Countries".
DBCC results for 'PurchaseOrderPrefixes'.
There are 1 rows in 1 pages for object "PurchaseOrderPrefixes".
DBCC results for 'Warranties'.
There are 0 rows in 0 pages for object "Warranties".
DBCC results for 'WorkScheduleBreaks'.
There are 0 rows in 0 pages for object "WorkScheduleBreaks".
DBCC results for 'SecurityProfiles'.
There are 15 rows in 1 pages for object "SecurityProfiles".
DBCC results for 'bdt_ChemicalSpecifications'.
There are 12997 rows in 346 pages for object "bdt_ChemicalSpecifications".
DBCC results for 'MatrixSizes'.
There are 9 rows in 1 pages for object "MatrixSizes".
DBCC results for 'SecurityProfileUsers'.
There are 108 rows in 3 pages for object "SecurityProfileUsers".
DBCC results for 'Transports'.
There are 1 rows in 1 pages for object "Transports".
DBCC results for 'SettlementTerms'.
There are 17 rows in 1 pages for object "SettlementTerms".
DBCC results for 'bdt_PhysicalSpecifications'.
There are 8698 rows in 213 pages for object "bdt_PhysicalSpecifications".
DBCC results for 'CustomForms'.
There are 0 rows in 0 pages for object "CustomForms".
DBCC results for 'FinancialTargets'.
There are 0 rows in 0 pages for object "FinancialTargets".
DBCC results for 'ShipmentsIntegration'.
There are 0 rows in 0 pages for object "ShipmentsIntegration".
DBCC results for 'ConfiguredProcesses'.
There are 0 rows in 0 pages for object "ConfiguredProcesses".
DBCC results for 'CustomMatrixRows'.
There are 0 rows in 0 pages for object "CustomMatrixRows".
DBCC results for 'UnitsOfMeasure'.
There are 9 rows in 1 pages for object "UnitsOfMeasure".
DBCC results for 'GeographicalTaxRates'.
There are 0 rows in 0 pages for object "GeographicalTaxRates".
DBCC results for 'ShipmentBatches'.
There are 0 rows in 0 pages for object "ShipmentBatches".
DBCC results for 'Customers'.
There are 209 rows in 22 pages for object "Customers".
DBCC results for 'GLAccountTypes'.
There are 215 rows in 6 pages for object "GLAccountTypes".
DBCC results for 'JournalItems'.
There are 2540 rows in 78 pages for object "JournalItems".
DBCC results for 'SupportCaseStatuses'.
There are 4 rows in 1 pages for object "SupportCaseStatuses".
DBCC results for 'FreeForms'.
There are 3 rows in 1 pages for object "FreeForms".
DBCC results for 'sys.ifts_comp_fragment_1563152614_3876'.
There are 49 rows in 1 pages for object "sys.ifts_comp_fragment_1563152614_3876".
DBCC results for 'MatrixColours'.
There are 11 rows in 1 pages for object "MatrixColours".
DBCC results for 'WorkScheduleCalendar'.
There are 12 rows in 1 pages for object "WorkScheduleCalendar".
DBCC results for 'CustomValues'.
There are 544118 rows in 15284 pages for object "CustomValues".
DBCC results for 'SalesOrderPrefixes'.
There are 3 rows in 1 pages for object "SalesOrderPrefixes".
DBCC results for 'Routes'.
There are 0 rows in 0 pages for object "Routes".
DBCC results for 'Budgets'.
There are 12 rows in 1 pages for object "Budgets".
DBCC results for 'UsersAccessLogs'.
There are 19041 rows in 153 pages for object "UsersAccessLogs".
DBCC results for 'CRMContactTypes'.
There are 0 rows in 0 pages for object "CRMContactTypes".
DBCC results for 'ConstantValues'.
There are 0 rows in 0 pages for object "ConstantValues".
DBCC results for 'UnitsOfMeasureFactors'.
There are 17 rows in 1 pages for object "UnitsOfMeasureFactors".
DBCC results for 'CRMCampaignStatuses'.
There are 1 rows in 1 pages for object "CRMCampaignStatuses".
DBCC results for 'SiteUsers'.
There are 106 rows in 2 pages for object "SiteUsers".
DBCC results for 'GLChartOfAccounts'.
There are 189 rows in 7 pages for object "GLChartOfAccounts".
DBCC results for 'sys.ifts_comp_fragment_1563152614_3880'.
There are 28 rows in 1 pages for object "sys.ifts_comp_fragment_1563152614_3880".
DBCC results for 'DistributionLists'.
There are 0 rows in 0 pages for object "DistributionLists".
DBCC results for 'ProcessSchedules'.
There are 0 rows in 0 pages for object "ProcessSchedules".
DBCC results for 'SalesOrders'.
There are 5109 rows in 502 pages for object "SalesOrders".
DBCC results for 'RemoteTransactions'.
There are 0 rows in 0 pages for object "RemoteTransactions".
DBCC results for 'IntrastatCNCodes'.
There are 9443 rows in 413 pages for object "IntrastatCNCodes".
DBCC results for 'CRMRegions'.
There are 1 rows in 1 pages for object "CRMRegions".
DBCC results for 'sys.fulltext_index_docidstatus_1111167204'.
There are 0 rows in 1 pages for object "sys.fulltext_index_docidstatus_1111167204".
DBCC results for 'Banks'.
There are 12 rows in 1 pages for object "Banks".
DBCC results for 'SalesInvoiceItems'.
There are 9183 rows in 679 pages for object "SalesInvoiceItems".
DBCC results for 'Promotions'.
There are 0 rows in 0 pages for object "Promotions".
DBCC results for 'bdt_DummyData'.
There are 6 rows in 2 pages for object "bdt_DummyData".
DBCC results for 'AuditTables'.
There are 0 rows in 0 pages for object "AuditTables".
DBCC results for 'SalesOrderItemAllocations'.
There are 0 rows in 0 pages for object "SalesOrderItemAllocations".
DBCC results for 'WarrantyItems'.
There are 0 rows in 0 pages for object "WarrantyItems".
DBCC results for 'DistributionListContacts'.
There are 0 rows in 0 pages for object "DistributionListContacts".
DBCC results for 'CreditControlLetterItems'.
There are 0 rows in 0 pages for object "CreditControlLetterItems".
DBCC results for 'SyncTombStones'.
There are 1409 rows in 29 pages for object "SyncTombStones".
DBCC results for 'sys.fulltext_docidfilter_1111167204'.
There are 123 rows in 1 pages for object "sys.fulltext_docidfilter_1111167204".
DBCC results for 'bdt_PhysicalTestResults'.
There are 32 rows in 3 pages for object "bdt_PhysicalTestResults".
DBCC results for 'Bookmarks'.
There are 36 rows in 1 pages for object "Bookmarks".
DBCC results for 'sys.fulltext_indexeddocid_1111167204'.
There are 51 rows in 1 pages for object "sys.fulltext_indexeddocid_1111167204".
DBCC results for 'sys.ifts_comp_fragment_1563152614_21'.
There are 57437 rows in 480 pages for object "sys.ifts_comp_fragment_1563152614_21".
DBCC results for 'Sundries'.
There are 56 rows in 3 pages for object "Sundries".
DBCC results for 'guid'.
There are 0 rows in 0 pages for object "guid".
DBCC results for 'Containers'.
There are 0 rows in 0 pages for object "Containers".
DBCC results for 'sys.fulltext_avdl_1111167204'.
There are 3 rows in 1 pages for object "sys.fulltext_avdl_1111167204".
DBCC results for 'Suppliers'.
There are 590 rows in 55 pages for object "Suppliers".
DBCC results for 'ConfiguredItemQuantities'.
There are 0 rows in 0 pages for object "ConfiguredItemQuantities".
DBCC results for 'ProgramSecurityTree'.
There are 230 rows in 4 pages for object "ProgramSecurityTree".
DBCC results for 'CreditControlLetterStatuses'.
There are 0 rows in 0 pages for object "CreditControlLetterStatuses".
DBCC results for 'sys.fulltext_index_docidstatus_1886226070'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_1886226070".
DBCC results for 'PurchaseOrders'.
There are 3208 rows in 157 pages for object "PurchaseOrders".
DBCC results for 'fft_releaseno'.
There are 75 rows in 3 pages for object "fft_releaseno".
DBCC results for 'anchor'.
There are 0 rows in 0 pages for object "anchor".
DBCC results for 'sys.fulltext_docidfilter_1886226070'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1886226070".
DBCC results for 'CustomMatrixTableValues'.
There are 0 rows in 0 pages for object "CustomMatrixTableValues".
DBCC results for 'ProcessControlTemplates'.
There are 35 rows in 1 pages for object "ProcessControlTemplates".
DBCC results for 'sys.fulltext_indexeddocid_1886226070'.
There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_1886226070".
DBCC results for 'CustomTable10'.
There are 0 rows in 0 pages for object "CustomTable10".
DBCC results for 'CommissionAgents'.
There are 0 rows in 0 pages for object "CommissionAgents".
DBCC results for 'ProcessAlternatives'.
There are 0 rows in 0 pages for object "ProcessAlternatives".
DBCC results for 'Sites'.
There are 1 rows in 1 pages for object "Sites".
DBCC results for 'sys.fulltext_avdl_1886226070'.
There are 1 rows in 1 pages for object "sys.fulltext_avdl_1886226070".
DBCC results for 'ConfiguredComponents'.
There are 0 rows in 0 pages for object "ConfiguredComponents".
DBCC results for 'PurchaseInvoiceItems'.
There are 15672 rows in 869 pages for object "PurchaseInvoiceItems".
DBCC results for 'ConfiguredProcessRules'.
There are 0 rows in 0 pages for object "ConfiguredProcessRules".
DBCC results for 'PromotionItems'.
There are 0 rows in 0 pages for object "PromotionItems".
DBCC results for 'ProductExtendedCosts'.
There are 9809 rows in 580 pages for object "ProductExtendedCosts".
DBCC results for 'SalesOrderItemQuantityPrices'.
There are 0 rows in 0 pages for object "SalesOrderItemQuantityPrices".
DBCC results for 'CreditControlLetters'.
There are 2 rows in 1 pages for object "CreditControlLetters".
DBCC results for 'CRMGroups'.
There are 1 rows in 1 pages for object "CRMGroups".
DBCC results for 'InventoryRequirement'.
There are 32297 rows in 782 pages for object "InventoryRequirement".
DBCC results for 'Widgets'.
There are 146 rows in 22 pages for object "Widgets".
DBCC results for 'SupportCaseCategories'.
There are 3 rows in 1 pages for object "SupportCaseCategories".
DBCC results for 'CustomTable04'.
There are 0 rows in 0 pages for object "CustomTable04".
DBCC results for 'ConfiguredRelations'.
There are 0 rows in 0 pages for object "ConfiguredRelations".
DBCC results for 'CashTemplates'.
There are 0 rows in 0 pages for object "CashTemplates".
DBCC results for 'sys.queue_messages_889314478'.
There are 0 rows in 0 pages for object "sys.queue_messages_889314478".
DBCC results for 'CRMProjectLeadTypes'.
There are 4 rows in 1 pages for object "CRMProjectLeadTypes".
DBCC results for 'Tools'.
There are 0 rows in 0 pages for object "Tools".
DBCC results for 'Transfers'.
There are 0 rows in 0 pages for object "Transfers".
DBCC results for 'CustomMatrixColumns'.
There are 0 rows in 0 pages for object "CustomMatrixColumns".
DBCC results for 'sys.queue_messages_921314592'.
There are 0 rows in 0 pages for object "sys.queue_messages_921314592".
DBCC results for 'ActivityCentresProducts'.
There are 0 rows in 0 pages for object "ActivityCentresProducts".
DBCC results for 'NumberWords'.
There are 29 rows in 1 pages for object "NumberWords".
DBCC results for 'GLClassifications'.
There are 16 rows in 1 pages for object "GLClassifications".
DBCC results for 'CustomerCrossReferencePriceBreaks'.
There are 0 rows in 0 pages for object "CustomerCrossReferencePriceBreaks".
DBCC results for 'CRMProjectPrefixes'.
There are 4 rows in 1 pages for object "CRMProjectPrefixes".
DBCC results for 'CRMConversations'.
There are 0 rows in 0 pages for object "CRMConversations".
DBCC results for 'sys.queue_messages_953314706'.
There are 0 rows in 0 pages for object "sys.queue_messages_953314706".
DBCC results for 'DBColumnTypes'.
There are 9 rows in 1 pages for object "DBColumnTypes".
DBCC results for 'PaymentRuns'.
There are 70 rows in 2 pages for object "PaymentRuns".
DBCC results for 'SupplierCrossReferenceManufacturers'.
There are 0 rows in 0 pages for object "SupplierCrossReferenceManufacturers".
DBCC results for 'CRMSources'.
There are 1 rows in 1 pages for object "CRMSources".
DBCC results for 'SupportCaseSolutions'.
There are 0 rows in 0 pages for object "SupportCaseSolutions".
DBCC results for 'ProductTestTypes'.
There are 0 rows in 0 pages for object "ProductTestTypes".
DBCC results for 'sys.ifts_comp_fragment_1563152614_3853'.
There are 128 rows in 1 pages for object "sys.ifts_comp_fragment_1563152614_3853".
DBCC results for 'CustomFormItems'.
There are 0 rows in 0 pages for object "CustomFormItems".
DBCC results for 'zzz_ResourceLabels'.
There are 0 rows in 0 pages for object "zzz_ResourceLabels".
DBCC results for 'ExtendedTaxations'.
There are 0 rows in 0 pages for object "ExtendedTaxations".
DBCC results for 'CRMProjectQuestions'.
There are 0 rows in 0 pages for object "CRMProjectQuestions".
DBCC results for 'SQLQueries'.
There are 73 rows in 12 pages for object "SQLQueries".
DBCC results for 'ShipmentBoxes'.
There are 1 rows in 1 pages for object "ShipmentBoxes".
DBCC results for 'bdt_ChemicalTestResults_OLD'.
There are 16 rows in 1 pages for object "bdt_ChemicalTestResults_OLD".
DBCC results for 'PurchaseOrdersHistory'.
There are 53 rows in 6 pages for object "PurchaseOrdersHistory".
DBCC results for 'LocationPutAwayLocations'.
There are 0 rows in 0 pages for object "LocationPutAwayLocations".
DBCC results for 'Countries_Tombstone'.
There are 1 rows in 1 pages for object "Countries_Tombstone".
DBCC results for 'CRMCalendar'.
There are 0 rows in 0 pages for object "CRMCalendar".
DBCC results for 'FreeFormFields'.
There are 7 rows in 1 pages for object "FreeFormFields".
DBCC results for 'CRMActions'.
There are 51 rows in 2 pages for object "CRMActions".
DBCC results for 'WidgetLayouts'.
There are 146 rows in 53 pages for object "WidgetLayouts".
DBCC results for 'IndirectJobs'.
There are 0 rows in 0 pages for object "IndirectJobs".
DBCC results for 'ProgramControls'.
There are 39 rows in 2 pages for object "ProgramControls".
DBCC results for 'CustomTable03'.
There are 0 rows in 0 pages for object "CustomTable03".
DBCC results for 'ProductsHistory'.
There are 79619 rows in 8535 pages for object "ProductsHistory".
DBCC results for 'LocationPutAwayMovementSuggestions'.
There are 0 rows in 0 pages for object "LocationPutAwayMovementSuggestions".
DBCC results for 'Comments'.
There are 0 rows in 0 pages for object "Comments".
DBCC results for 'bdt_ManufacturingOrdersScrap'.
There are 433 rows in 9 pages for object "bdt_ManufacturingOrdersScrap".
DBCC results for 'ActionNotifications'.
There are 0 rows in 0 pages for object "ActionNotifications".
DBCC results for 'UsersMRUs'.
There are 2175 rows in 72 pages for object "UsersMRUs".
DBCC results for 'ShipmentBoxesToInventory'.
There are 11761 rows in 246 pages for object "ShipmentBoxesToInventory".
DBCC results for 'Feeds'.
There are 0 rows in 0 pages for object "Feeds".
DBCC results for 'ProductStatuses'.
There are 0 rows in 0 pages for object "ProductStatuses".
DBCC results for 'SupplierCrossReferencePriceBreaks'.
There are 0 rows in 0 pages for object "SupplierCrossReferencePriceBreaks".
DBCC results for 'FixedAssets'.
There are 835 rows in 31 pages for object "FixedAssets".
DBCC results for 'SalesInvoices'.
There are 6325 rows in 421 pages for object "SalesInvoices".
DBCC results for 'DocumentTypes'.
There are 1 rows in 1 pages for object "DocumentTypes".
DBCC results for 'ManufacturingOrderPrefixes'.
There are 2 rows in 1 pages for object "ManufacturingOrderPrefixes".
DBCC results for 'Jobs'.
There are 0 rows in 0 pages for object "Jobs".
DBCC results for 'CustomTable07'.
There are 0 rows in 0 pages for object "CustomTable07".
DBCC results for 'CRMActivities'.
There are 0 rows in 0 pages for object "CRMActivities".
DBCC results for 'ActivityCentres'.
There are 59 rows in 3 pages for object "ActivityCentres".
DBCC results for 'LabourTransactions'.
There are 25195 rows in 1571 pages for object "LabourTransactions".
DBCC results for 'HireOrders'.
There are 0 rows in 0 pages for object "HireOrders".
DBCC results for 'AlternativeParts'.
There are 0 rows in 0 pages for object "AlternativeParts".
DBCC results for 'bdt_Tests'.
There are 44 rows in 1 pages for object "bdt_Tests".
DBCC results for 'SupportCasesInbox'.
There are 0 rows in 0 pages for object "SupportCasesInbox".
DBCC results for 'CreditCards'.
There are 0 rows in 0 pages for object "CreditCards".
DBCC results for 'AbsenceTypesDetails'.
There are 0 rows in 0 pages for object "AbsenceTypesDetails".
DBCC results for 'LocationZones'.
There are 0 rows in 0 pages for object "LocationZones".
DBCC results for 'Areas'.
There are 4 rows in 1 pages for object "Areas".
DBCC results for 'TransferPendingItems'.
There are 0 rows in 0 pages for object "TransferPendingItems".
DBCC results for 'ProductWarranties'.
There are 0 rows in 0 pages for object "ProductWarranties".
DBCC results for 'CRMProjectCategories'.
There are 0 rows in 0 pages for object "CRMProjectCategories".
DBCC results for 'ToolInstances'.
There are 0 rows in 0 pages for object "ToolInstances".
DBCC results for 'AttachedMessages'.
There are 1 rows in 1 pages for object "AttachedMessages".
DBCC results for 'bdt_Treatments'.
There are 35 rows in 1 pages for object "bdt_Treatments".
DBCC results for 'sys.filestream_tombstone_1312476200'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_1312476200".
DBCC results for 'zzz_MissingColumnCaptions'.
There are 0 rows in 0 pages for object "zzz_MissingColumnCaptions".
DBCC results for 'Audit'.
There are 928379 rows in 19317 pages for object "Audit".
DBCC results for 'PurchaseInvoices'.
There are 7835 rows in 448 pages for object "PurchaseInvoices".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'CustomerShippingMethods'.
There are 0 rows in 0 pages for object "CustomerShippingMethods".
DBCC results for 'TransferItems'.
There are 0 rows in 0 pages for object "TransferItems".
DBCC results for 'BespokeLabels'.
There are 5 rows in 1 pages for object "BespokeLabels".
DBCC results for 'MultiLanguages'.
There are 0 rows in 0 pages for object "MultiLanguages".
DBCC results for 'GLReportTotals'.
There are 10 rows in 1 pages for object "GLReportTotals".
DBCC results for 'Libraries'.
There are 2 rows in 1 pages for object "Libraries".
DBCC results for 'Cash'.
There are 4082 rows in 205 pages for object "Cash".
DBCC results for 'PostCodePrimers'.
There are 0 rows in 0 pages for object "PostCodePrimers".
DBCC results for 'CustomTable02'.
There are 0 rows in 0 pages for object "CustomTable02".
DBCC results for 'ContainerTypes'.
There are 1 rows in 1 pages for object "ContainerTypes".
DBCC results for 'TaxReturns'.
There are 3 rows in 1 pages for object "TaxReturns".
DBCC results for 'CustomTable09'.
There are 0 rows in 0 pages for object "CustomTable09".
DBCC results for 'fft_shiplabel'.
There are 0 rows in 0 pages for object "fft_shiplabel".
DBCC results for 'CalendarSources'.
There are 0 rows in 0 pages for object "CalendarSources".
DBCC results for 'Counters'.
There are 23 rows in 1 pages for object "Counters".
DBCC results for 'LocationStorageTypes'.
There are 0 rows in 0 pages for object "LocationStorageTypes".
DBCC results for 'fft_reject'.
There are 24 rows in 1 pages for object "fft_reject".
DBCC results for 'CreditReasonCodes'.
There are 10 rows in 1 pages for object "CreditReasonCodes".
DBCC results for 'MobileLayouts'.
There are 0 rows in 0 pages for object "MobileLayouts".
DBCC results for 'Markups'.
There are 0 rows in 0 pages for object "Markups".
DBCC results for 'IndirectJobsDetails'.
There are 0 rows in 0 pages for object "IndirectJobsDetails".
DBCC results for 'ToolInstanceItems'.
There are 0 rows in 0 pages for object "ToolInstanceItems".
DBCC results for 'HireOrderItems'.
There are 0 rows in 0 pages for object "HireOrderItems".
DBCC results for 'ReturnNotes'.
There are 0 rows in 0 pages for object "ReturnNotes".
DBCC results for 'ShipmentSchedules'.
There are 0 rows in 0 pages for object "ShipmentSchedules".
DBCC results for 'Labels'.
There are 0 rows in 0 pages for object "Labels".
DBCC results for 'CustomerCrossReferences'.
There are 0 rows in 0 pages for object "CustomerCrossReferences".
DBCC results for 'FixedAssetItems'.
There are 2835 rows in 57 pages for object "FixedAssetItems".
DBCC results for 'GLItems'.
There are 171344 rows in 5392 pages for object "GLItems".
DBCC results for 'DemandForecasts'.
There are 1 rows in 1 pages for object "DemandForecasts".
DBCC results for 'bdt_FinalDimensions'.
There are 1136 rows in 26 pages for object "bdt_FinalDimensions".
DBCC results for 'ActivityCentresRelations'.
There are 0 rows in 0 pages for object "ActivityCentresRelations".
DBCC results for 'Inventory'.
There are 135522 rows in 17680 pages for object "Inventory".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'NewTraining'.
Msg 802, Level 17, State 20, Line 2
Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
```

Highlighted
##

The error lines are

VJware

Employee
Accredited
Certified

09-02-2015 10:58 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

The error lines are these:-

`Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent.`

`Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.`

`These links may help - `

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6548a457-7c46-4012-9892-432be9d391d8/error-message-when-i-do-dbcc-checkdb?forum=sqldatabaseengine

https://msdn.microsoft.com/en-us/library/aa337354.aspx