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.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 "Inconsistent" Consistency errors

Author  Topic 

r_darling
Starting Member

14 Posts

Posted - 2006-02-13 : 16:24:45
Hello to all,
I'm new to this forum, and appreciate any input regaridng my problem. We use a Gross-to-Net Payroll Package (CORT), and updated from SQL 7 on NT 4 to SQL 2000 (current version 8.00.760) running on Windows 2003 (Build 3790, SP 1). System is on APC UPS. The application is used very lightly by 4 users to create net payrolls weekly. CORT setup nightly routines to check the databases.

Here is the problem. Every few weeks I receive consistency errors, and was told by CORT that the only acceptable course of action was to recover from backups, which I do. The weird thing is I can run DBCC CHECKDB and receive errors, and then immediately run it again and have no errors, etc. No consistency to the errors...weird.

This is the strangest problem I've ever dealt with in DB management. CORT tells me that our install is the only install that has ever had errors running DBCC with their product. Checked disks, power, etc...can't find anything.

Any ideas appreciated.


Richard Darling
MCSE/MCSA W2K W2K
CSA HPUX
sec+, net+

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-13 : 16:26:09
Post the DBCC CHECKDB results that contains errors. There are a few Microsoft Engineers who check this forum that can help you out.

Tara Kizer
aka tduggan
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-13 : 16:27:21
Thanks Tara,
will do.


Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-13 : 16:43:33
Didn't save the detail records, because they were all over the place, but will start now. Are the logs in a location I'm unaware of, or not saved? The logs that I've found only show the summary, indicating the number of errors found.

Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-14 : 12:39:46
Are the CHECKDB jobs scheduled (assuming yes from your description)? As part of a larger job that may change the database after the first check? Do you have the 'repair minor errors' box checked?

When you say 'immediately', do you really mean that as soon as the first CHECKDB finished you run it again? How long does it take?

There are some cases where the log analysis used can produce spurious errors but without seeing the output I can't say what you've got.

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-14 : 14:13:16
The CHECKDB jobs are scheduled; once a week as part of a larger job. The 'repair minor errors' box isn't checked, per orders from CORT.

When I say 'immediately', I mean that as soon as the first CHECKDB finished I run it again without closing the program, Query Analyzer (isqlw.exe). It usually takes around 20 seconds for each run.

I just enter DBCC CHECKDB and select the db from the drop down menu and run it.

I'll post the output next time I have an issue. However, the error messages never seem to be the same.

Thanks.



Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-14 : 14:19:45
Its not TEMPDB is it?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-14 : 15:01:23
Hi Paul,
It is one of our db called CortSouthwick. Thanks.

Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-14 : 15:39:46
The other thing that is in the back of my mind is that we are looking at upgrading our current business system (Porini (PROIV ISAM)). They are offering the product in Oracle and SQL2000, and based on my experience so far I would tend to run away from SQL2000, but the price is attractive compared to Oracle. Quite frankly, this consistency problem I'm having is scaring me away from SQL2000. Any input appreciated.

Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-14 : 16:04:36
I can't comment on the consistency issues until we work out what they are.

Are you having any other issues with SQL Server 2000?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-14 : 16:24:21
Hi Paul,
No, just that, but that is plenty. My other apps run on an L1000 (HP UX). The Porini (our main business system) is an ISAM database, written in PROIV. The other is Magnal (Manufacturing) and uses COBOL. I very seldom have any issues with these UNIX based systems, and I'm used to addressing an individual file when I have a problem, and not having to recover an entire db. I've also gotten used to writing scripts on the UNIX system.

The big reason I'd think of going with SQL for upgrades to these systems would be cost (UNIX based is expensive), but the idea of having to recover an entire db every time there is a problem scares me...sorry for rambling on.





Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-14 : 16:33:47
We've been running SQL Server 2000 for over 5 years and have never had a database become corrupt. When it does, it typically is due to a hardware problem and not with SQL Server.

Database corruption was more common in previous versions of SQL Server. You hardly hear of it anymore.

Tara Kizer
aka tduggan
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-14 : 16:48:21
Thanks for the info. I never had a problem with SQL7 before the upgrade, but it was to a newer machine running W2K3 Standard.

Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-15 : 08:32:45
I received errors on two of our dbs last night (the CortGrieco is a old db that we don't use, but required to keep):

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SERVER2' as 'sa' (non-trusted)
Starting maintenance plan 'Cort DB Maintenance Plan -- Except Mondays' on 2/15/2006 2:00:01 AM
[1] Database CortGrieco: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8928: [Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 549576996, index ID 5: Page (1:19776) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 549576996, index ID 5, page (1:19776), row 106. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 266 and 19.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 2 consistency errors in table 'PYAppRole.CURDED' (object ID 549576996).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 2 consistency errors in database 'CortGrieco'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (CortGrieco ).

The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 549576996, index ID 5: Page (1:19776) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 549576996, index ID 5, page (1:19776), row 106. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 266 and 19.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 2 consistency errors in table 'PYAppRole.CURDED' (object ID 549576996).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 2 consistency errors in database 'CortGrieco'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (CortGrieco ).
** Execution Time: 0 hrs, 0 mins, 12 secs **

[2] Database CortMRCCC: Check Data and Index Linkage...

** Execution Time: 0 hrs, 0 mins, 4 secs **

[3] Database CortSouthwick: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8952: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Database 'CortSouthwick', index 'PYAppRole.d_EmployeeDeductions.IX_Period_EmployeeDeductions' (ID 416056568) (index ID 5). Extra or invalid key for the keys:
[Microsoft][ODBC SQL Server Driver][SQL Server]Index row (1:34175:38) with values (Period = 'Y' and EmpID = '0000007000' and DedYear = '2005' and Period = 'Y' and Ded_Type = '102' and DetailCode = 'Year_To_Date' and KeyDate = Dec 25 2004 7:46AM and DedID = 33188) points to the data row identified by ().
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'PYAppRole.d_EmployeeDeductions' (object ID 416056568).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'CortSouthwick'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (CortSouthwick ).

The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Database 'CortSouthwick', index 'PYAppRole.d_EmployeeDeductions.IX_Period_EmployeeDeductions' (ID 416056568) (index ID 5). Extra or invalid key for the keys:
[Microsoft][ODBC SQL Server Driver][SQL Server]Index row (1:34175:38) with values (Period = 'Y' and EmpID = '0000007000' and DedYear = '2005' and Period = 'Y' and Ded_Type = '102' and DetailCode = 'Year_To_Date' and KeyDate = Dec 25 2004 7:46AM and DedID = 33188) points to the data row identified by ().
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'PYAppRole.d_EmployeeDeductions' (object ID 416056568).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'CortSouthwick'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (CortSouthwick ).
** Execution Time: 0 hrs, 0 mins, 23 secs **

[4] Database CortGrieco: Database Backup...

The backup was not performed since data verification errors were found.

[5] Database CortMRCCC: Database Backup...
Destination: [C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\CortMRCCC\CortMRCCC_db_200602150200.BAK]

** Execution Time: 0 hrs, 0 mins, 6 secs **

[6] Database CortMRCCC: Verifying Backup...

** Execution Time: 0 hrs, 0 mins, 2 secs **

[7] Database CortSouthwick: Database Backup...

The backup was not performed since data verification errors were found.

Deleting old text reports... 1 file(s) deleted.

End of maintenance plan 'Cort DB Maintenance Plan -- Except Mondays' on 2/15/2006 2:00:48 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

Emailing report to operator 'SQLAdmins'


Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-15 : 08:41:50
I just ran DBCC CHECKDB for both dbs and they came out clean:
DBCC results for 'CortSouthwick'.
DBCC results for 'sysobjects'.
There are 2402 rows in 43 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1554 rows in 76 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 16122 rows in 271 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 75 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 1791 rows in 439 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 831 rows in 6 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 31 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 9523 rows in 52 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 143 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 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 'PYAppRole.LOOKUP'.
There are 0 rows in 0 pages for object 'PYAppRole.LOOKUP'.
DBCC results for 'PYAppRole.WFPageSections'.
There are 4 rows in 1 pages for object 'PYAppRole.WFPageSections'.
DBCC results for 'EquipmentNeeded'.
There are 0 rows in 1 pages for object 'EquipmentNeeded'.
DBCC results for 'PYAppRole.WFSections'.
There are 4 rows in 1 pages for object 'PYAppRole.WFSections'.
DBCC results for 'Instructor'.
There are 0 rows in 1 pages for object 'Instructor'.
DBCC results for 'PYAppRole.BenefitDetails'.
There are 0 rows in 1 pages for object 'PYAppRole.BenefitDetails'.
DBCC results for 'PYAppRole.SECFL'.
There are 66 rows in 5 pages for object 'PYAppRole.SECFL'.
DBCC results for 'PYAppRole.SSEntryDetail'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryDetail'.
DBCC results for 'PYAppRole.UDParent'.
There are 12 rows in 1 pages for object 'PYAppRole.UDParent'.
DBCC results for 'InvestmentFund'.
There are 0 rows in 0 pages for object 'InvestmentFund'.
DBCC results for 'PYAppRole.WFSectionWidgets'.
There are 28 rows in 1 pages for object 'PYAppRole.WFSectionWidgets'.
DBCC results for 'OccupationalIllnessTable'.
There are 0 rows in 0 pages for object 'OccupationalIllnessTable'.
DBCC results for 'PYAppRole.d_EmployeeI9'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeI9'.
DBCC results for 'PYAppRole.SESSION'.
There are 7285 rows in 60 pages for object 'PYAppRole.SESSION'.
DBCC results for 'PYAppRole.SSTemplate'.
There are 1 rows in 1 pages for object 'PYAppRole.SSTemplate'.
DBCC results for 'OrganizationalUnit'.
There are 0 rows in 0 pages for object 'OrganizationalUnit'.
DBCC results for 'PayrollExport'.
There are 0 rows in 1 pages for object 'PayrollExport'.
DBCC results for 'PYAppRole.SSScripts'.
There are 1 rows in 1 pages for object 'PYAppRole.SSScripts'.
DBCC results for 'PYAppRole.UDTIME'.
There are 0 rows in 0 pages for object 'PYAppRole.UDTIME'.
DBCC results for 'PYAppRole.SSEntryCodeList'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryCodeList'.
DBCC results for 'PYAppRole.UDChild'.
There are 8 rows in 1 pages for object 'PYAppRole.UDChild'.
DBCC results for 'PositionTraining'.
There are 0 rows in 1 pages for object 'PositionTraining'.
DBCC results for 'InfiniumPY.RolePassword'.
There are 1 rows in 1 pages for object 'InfiniumPY.RolePassword'.
DBCC results for 'Prerequisite'.
There are 0 rows in 1 pages for object 'Prerequisite'.
DBCC results for 'PYAppRole.COBRA'.
There are 10 rows in 1 pages for object 'PYAppRole.COBRA'.
DBCC results for 'PYAppRole.SSTimeSheetDetails'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTimeSheetDetails'.
DBCC results for 'PYAppRole.EMPS'.
There are 1711 rows in 156 pages for object 'PYAppRole.EMPS'.
DBCC results for 'Reference'.
There are 0 rows in 1 pages for object 'Reference'.
DBCC results for 'SkillFulfillment'.
There are 0 rows in 1 pages for object 'SkillFulfillment'.
DBCC results for 'PYAppRole.CDEPSBEN'.
There are 0 rows in 0 pages for object 'PYAppRole.CDEPSBEN'.
DBCC results for 'PYAppRole.SSAdditionalEntries'.
There are 0 rows in 0 pages for object 'PYAppRole.SSAdditionalEntries'.
DBCC results for 'PYAppRole.OLDNEW'.
There are 0 rows in 0 pages for object 'PYAppRole.OLDNEW'.
DBCC results for 'SurveyLocationLocation'.
There are 0 rows in 1 pages for object 'SurveyLocationLocation'.
DBCC results for 'Team'.
There are 0 rows in 1 pages for object 'Team'.
DBCC results for 'PYAppRole.COBAR'.
There are 168 rows in 2 pages for object 'PYAppRole.COBAR'.
DBCC results for 'PYAppRole.SSEntryDef'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryDef'.
DBCC results for 'PYAppRole.HREMP'.
There are 575 rows in 31 pages for object 'PYAppRole.HREMP'.
DBCC results for 'TrainingSteps'.
There are 0 rows in 1 pages for object 'TrainingSteps'.
DBCC results for 'WorkflowAlias'.
There are 0 rows in 1 pages for object 'WorkflowAlias'.
DBCC results for 'PYAppRole.d_EmpTaxingInfo'.
There are 1374 rows in 19 pages for object 'PYAppRole.d_EmpTaxingInfo'.
DBCC results for 'PYAppRole.PRCTLDL_Old'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLDL_Old'.
DBCC results for 'PYAppRole.FLSA'.
There are 0 rows in 0 pages for object 'PYAppRole.FLSA'.
DBCC results for 'PYAppRole.BENS'.
There are 9 rows in 1 pages for object 'PYAppRole.BENS'.
DBCC results for 'AliasesAssociation'.
There are 0 rows in 1 pages for object 'AliasesAssociation'.
DBCC results for 'PYAppRole.PRCTLDL'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLDL'.
DBCC results for 'PYAppRole.SSEntryDetailDef'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryDetailDef'.
DBCC results for 'PYAppRole.WFAdministrators'.
There are 0 rows in 0 pages for object 'PYAppRole.WFAdministrators'.
DBCC results for 'BeneficiaryDependentEnrollment'.
There are 0 rows in 0 pages for object 'BeneficiaryDependentEnrollment'.
DBCC results for 'PYAppRole.PRCTLX0'.
There are 2 rows in 1 pages for object 'PYAppRole.PRCTLX0'.
DBCC results for 'PYAppRole.HIST'.
There are 56208 rows in 1131 pages for object 'PYAppRole.HIST'.
DBCC results for 'PYAppRole.WFAdministratorProcesses'.
There are 0 rows in 0 pages for object 'PYAppRole.WFAdministratorProcesses'.
DBCC results for 'PYAppRole.SSTempEntryDetail'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTempEntryDetail'.
DBCC results for 'FundDesignation'.
There are 0 rows in 0 pages for object 'FundDesignation'.
DBCC results for 'PYAppRole.ERRREC'.
There are 2 rows in 1 pages for object 'PYAppRole.ERRREC'.
DBCC results for 'PYAppRole.SPCRAT'.
There are 0 rows in 0 pages for object 'PYAppRole.SPCRAT'.
DBCC results for 'PYAppRole.WFEngineParms'.
There are 1 rows in 1 pages for object 'PYAppRole.WFEngineParms'.
DBCC results for 'ManagementGroupTraining'.
There are 0 rows in 1 pages for object 'ManagementGroupTraining'.
DBCC results for 'ProcessActors'.
There are 0 rows in 1 pages for object 'ProcessActors'.
DBCC results for 'PYAppRole.PRCTLPC'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLPC'.
DBCC results for 'PYAppRole.DEPEND'.
There are 60 rows in 2 pages for object 'PYAppRole.DEPEND'.
DBCC results for 'QualifiedInstructor'.
There are 0 rows in 1 pages for object 'QualifiedInstructor'.
DBCC results for 'PYAppRole.TimesheetAvailableCodes'.
There are 0 rows in 0 pages for object 'PYAppRole.TimesheetAvailableCodes'.
DBCC results for 'RequestForEmployee'.
There are 0 rows in 1 pages for object 'RequestForEmployee'.
DBCC results for 'PYAppRole.ZIP'.
There are 42791 rows in 203 pages for object 'PYAppRole.ZIP'.
DBCC results for 'PYAppRole.STDED'.
There are 15514 rows in 650 pages for object 'PYAppRole.STDED'.
DBCC results for 'ScheduledTraining'.
There are 0 rows in 1 pages for object 'ScheduledTraining'.
DBCC results for 'PYAppRole.EmployeeAccessOptions'.
There are 0 rows in 0 pages for object 'PYAppRole.EmployeeAccessOptions'.
DBCC results for 'PYAppRole.WFActiveEmails'.
There are 0 rows in 0 pages for object 'PYAppRole.WFActiveEmails'.
DBCC results for 'PYAppRole.SORTREC'.
There are 1667 rows in 22 pages for object 'PYAppRole.SORTREC'.
DBCC results for 'TeamMember'.
There are 0 rows in 1 pages for object 'TeamMember'.
DBCC results for 'PYAppRole.ZIPC'.
There are 0 rows in 0 pages for object 'PYAppRole.ZIPC'.
DBCC results for 'PYAppRole.EMPBEN'.
There are 107 rows in 6 pages for object 'PYAppRole.EMPBEN'.
DBCC results for 'Application'.
There are 0 rows in 1 pages for object 'Application'.
DBCC results for 'PYAppRole.Comments'.
There are 0 rows in 0 pages for object 'PYAppRole.Comments'.
DBCC results for 'PYAppRole.GLWF'.
There are 0 rows in 0 pages for object 'PYAppRole.GLWF'.
DBCC results for 'Interviewer'.
There are 0 rows in 1 pages for object 'Interviewer'.
DBCC results for 'PYAppRole.d_EmployeeDeductions'.
There are 156729 rows in 1772 pages for object 'PYAppRole.d_EmployeeDeductions'.
DBCC results for 'PYAppRole.PRCTLP1'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLP1'.
DBCC results for 'PYAppRole.DEPSBEN'.
There are 79 rows in 1 pages for object 'PYAppRole.DEPSBEN'.
DBCC results for 'Questionnaire'.
There are 0 rows in 1 pages for object 'Questionnaire'.
DBCC results for 'RecruitmentSourceForRequest'.
There are 0 rows in 1 pages for object 'RecruitmentSourceForRequest'.
DBCC results for 'PYAppRole.PRCTLZ0'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLZ0'.
DBCC results for 'PYAppRole.PROLLS'.
There are 722 rows in 36 pages for object 'PYAppRole.PROLLS'.
DBCC results for 'PYAppRole.WFActionTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.WFActionTemplates'.
DBCC results for 'PYAppRole.NetPayStates'.
There are 53 rows in 1 pages for object 'PYAppRole.NetPayStates'.
DBCC results for 'RequestApprover'.
There are 0 rows in 1 pages for object 'RequestApprover'.
DBCC results for 'PYAppRole.NetPayTEList'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayTEList'.
DBCC results for 'RequiredSkillForRequest'.
There are 0 rows in 1 pages for object 'RequiredSkillForRequest'.
DBCC results for 'PYAppRole.oldudevents'.
There are 12 rows in 1 pages for object 'PYAppRole.oldudevents'.
DBCC results for 'PYAppRole.ENTRY'.
There are 135914 rows in 12357 pages for object 'PYAppRole.ENTRY'.
DBCC results for 'PYAppRole.NetPayReadFile'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayReadFile'.
DBCC results for 'HireApproval'.
There are 0 rows in 1 pages for object 'HireApproval'.
DBCC results for 'PYAppRole.W2_WORKREC'.
There are 0 rows in 0 pages for object 'PYAppRole.W2_WORKREC'.
DBCC results for 'PYAppRole.SelfServiceOptions'.
There are 2 rows in 1 pages for object 'PYAppRole.SelfServiceOptions'.
DBCC results for 'PYAppRole.SSField'.
There are 71 rows in 1 pages for object 'PYAppRole.SSField'.
DBCC results for 'System'.
There are 0 rows in 0 pages for object 'System'.
DBCC results for 'PYAppRole.UDSecurity'.
There are 0 rows in 0 pages for object 'PYAppRole.UDSecurity'.
DBCC results for 'PYAppRole.WFAliasTemplates'.
There are 12 rows in 1 pages for object 'PYAppRole.WFAliasTemplates'.
DBCC results for 'PYAppRole.NetPayAccrualSchedule'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayAccrualSchedule'.
DBCC results for 'Question'.
There are 0 rows in 1 pages for object 'Question'.
DBCC results for 'PYAppRole.ATTMAST'.
There are 7 rows in 1 pages for object 'PYAppRole.ATTMAST'.
DBCC results for 'PYAppRole.RECUR'.
There are 46 rows in 4 pages for object 'PYAppRole.RECUR'.
DBCC results for 'ApplicationRating'.
There are 0 rows in 1 pages for object 'ApplicationRating'.
DBCC results for 'PYAppRole.SSFieldUpdate'.
There are 76 rows in 1 pages for object 'PYAppRole.SSFieldUpdate'.
DBCC results for 'PYAppRole.NetPayAccrualStatus'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayAccrualStatus'.
DBCC results for 'PYAppRole.STATS'.
There are 0 rows in 0 pages for object 'PYAppRole.STATS'.
DBCC results for 'PYAppRole.CURDED'.
There are 302733 rows in 5129 pages for object 'PYAppRole.CURDED'.
DBCC results for 'PYAppRole.NetPayConfig'.
There are 1 rows in 1 pages for object 'PYAppRole.NetPayConfig'.
DBCC results for 'PYAppRole.SSPageSecurity'.
There are 13 rows in 1 pages for object 'PYAppRole.SSPageSecurity'.
DBCC results for 'PYAppRole.NetPayDeds'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayDeds'.
DBCC results for 'PYAppRole.APPLICNT'.
There are 1 rows in 1 pages for object 'PYAppRole.APPLICNT'.
DBCC results for 'PYAppRole.CHECKS'.
There are 76566 rows in 9739 pages for object 'PYAppRole.CHECKS'.
DBCC results for 'PYAppRole.NetPayEmpDeds'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayEmpDeds'.
DBCC results for 'PYAppRole.QTRSORTREC'.
There are 0 rows in 0 pages for object 'PYAppRole.QTRSORTREC'.
DBCC results for 'PYAppRole.SSSectionSecurity'.
There are 16 rows in 1 pages for object 'PYAppRole.SSSectionSecurity'.
DBCC results for 'PYAppRole.NetPayEmps'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayEmps'.
DBCC results for 'PYAppRole.POSTXT'.
There are 0 rows in 0 pages for object 'PYAppRole.POSTXT'.
DBCC results for 'PYAppRole.ELR'.
There are 0 rows in 0 pages for object 'PYAppRole.ELR'.
DBCC results for 'PYAppRole.OSHA101'.
There are 0 rows in 0 pages for object 'PYAppRole.OSHA101'.
DBCC results for 'PYAppRole.d_DeductionAccumulators'.
There are 131686 rows in 1338 pages for object 'PYAppRole.d_DeductionAccumulators'.
DBCC results for 'PYAppRole.SSRoleDetails'.
There are 0 rows in 0 pages for object 'PYAppRole.SSRoleDetails'.
DBCC results for 'PYAppRole.WFDataPacketTemplates'.
There are 1 rows in 1 pages for object 'PYAppRole.WFDataPacketTemplates'.
DBCC results for 'PYAppRole.NetPayGL'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayGL'.
DBCC results for 'PYAppRole.PRCTLEE'.
There are 16 rows in 1 pages for object 'PYAppRole.PRCTLEE'.
DBCC results for 'PYAppRole.EAR'.
There are 0 rows in 0 pages for object 'PYAppRole.EAR'.
DBCC results for 'PYAppRole.WFDelegateList'.
There are 0 rows in 0 pages for object 'PYAppRole.WFDelegateList'.
DBCC results for 'PYAppRole.NetPayHistoryOfChanges'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayHistoryOfChanges'.
DBCC results for 'PYAppRole.OSHA200'.
There are 0 rows in 0 pages for object 'PYAppRole.OSHA200'.
DBCC results for 'PYAppRole.SECALIAS'.
There are 13 rows in 1 pages for object 'PYAppRole.SECALIAS'.
DBCC results for 'PYAppRole.SSRole'.
There are 1 rows in 1 pages for object 'PYAppRole.SSRole'.
DBCC results for 'PYAppRole.WFEmailTemplates'.
There are 8 rows in 1 pages for object 'PYAppRole.WFEmailTemplates'.
DBCC results for 'PYAppRole.NetPayItems'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayItems'.
DBCC results for 'PYAppRole.USERDATA'.
There are 1326 rows in 13 pages for object 'PYAppRole.USERDATA'.
DBCC results for 'PYAppRole.NetPayPayHistory'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayPayHistory'.
DBCC results for 'PYAppRole.PRCTLVV_OLD'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLVV_OLD'.
DBCC results for 'EnrollmentTable_BACKUP'.
There are 0 rows in 1 pages for object 'EnrollmentTable_BACKUP'.
DBCC results for 'PYAppRole.NetPayPayrolls'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayPayrolls'.
DBCC results for 'PYAppRole.UDCONSM'.
There are 1 rows in 1 pages for object 'PYAppRole.UDCONSM'.
DBCC results for 'PYAppRole.CREQD'.
There are 91 rows in 1 pages for object 'PYAppRole.CREQD'.
DBCC results for 'PYAppRole.SSApproval'.
There are 0 rows in 0 pages for object 'PYAppRole.SSApproval'.
DBCC results for 'EnrollmentTable'.
There are 0 rows in 0 pages for object 'EnrollmentTable'.
DBCC results for 'PYAppRole.PRCTLRP'.
There are 7 rows in 1 pages for object 'PYAppRole.PRCTLRP'.
DBCC results for 'PYAppRole.d_People'.
There are 513 rows in 7 pages for object 'PYAppRole.d_People'.
DBCC results for 'PYAppRole.FLAGS'.
There are 669 rows in 5 pages for object 'PYAppRole.FLAGS'.
DBCC results for 'PYAppRole.NetPaySpTaxes'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPaySpTaxes'.
DBCC results for 'PYAppRole.PRCTLVV'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLVV'.
DBCC results for 'PYAppRole.SSSchedule'.
There are 0 rows in 1 pages for object 'PYAppRole.SSSchedule'.
DBCC results for 'PYAppRole.NetPayStateFields'.
There are 86 rows in 2 pages for object 'PYAppRole.NetPayStateFields'.
DBCC results for 'PYAppRole.WORKRECORD'.
There are 28036 rows in 300 pages for object 'PYAppRole.WORKRECORD'.
DBCC results for 'PYAppRole.ELIST'.
There are 1 rows in 1 pages for object 'PYAppRole.ELIST'.
DBCC results for 'PYAppRole.BusinessObjects'.
There are 407 rows in 5 pages for object 'PYAppRole.BusinessObjects'.
DBCC results for 'PYAppRole.NetPayStateSelections'.
There are 114 rows in 1 pages for object 'PYAppRole.NetPayStateSelections'.
DBCC results for 'PYAppRole.SECFL_old'.
There are 50 rows in 5 pages for object 'PYAppRole.SECFL_old'.
DBCC results for 'PYAppRole.NetPayTimeEntries'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayTimeEntries'.
DBCC results for 'PYAppRole.d_Dependents'.
There are 230 rows in 3 pages for object 'PYAppRole.d_Dependents'.
DBCC results for 'PYAppRole.PRCTLBG'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLBG'.
DBCC results for 'PYAppRole.ATT'.
There are 52 rows in 1 pages for object 'PYAppRole.ATT'.
DBCC results for 'PYAppRole.WFProcesses'.
There are 0 rows in 0 pages for object 'PYAppRole.WFProcesses'.
DBCC results for 'PYAppRole.NetPayUDData'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayUDData'.
DBCC results for 'PYAppRole.WFEvents'.
There are 0 rows in 0 pages for object 'PYAppRole.WFEvents'.
DBCC results for 'PYAppRole.NetPayScheduleRate'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayScheduleRate'.
DBCC results for 'PYAppRole.PTLOCAL'.
There are 1 rows in 1 pages for object 'PYAppRole.PTLOCAL'.
DBCC results for 'PYAppRole.PRCTLBO'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLBO'.
DBCC results for 'PYAppRole.BENPLN'.
There are 0 rows in 0 pages for object 'PYAppRole.BENPLN'.
DBCC results for 'PYAppRole.Attachments'.
There are 0 rows in 0 pages for object 'PYAppRole.Attachments'.
DBCC results for 'PYAppRole.EMPGLP'.
There are 17 rows in 1 pages for object 'PYAppRole.EMPGLP'.
DBCC results for 'AbsenceProposal'.
There are 0 rows in 1 pages for object 'AbsenceProposal'.
DBCC results for 'PYAppRole.PRCTLDC'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLDC'.
DBCC results for 'PYAppRole.GRADES'.
There are 0 rows in 0 pages for object 'PYAppRole.GRADES'.
DBCC results for 'PYAppRole.d_DependentBenefits'.
There are 0 rows in 0 pages for object 'PYAppRole.d_DependentBenefits'.
DBCC results for 'AbsenceType'.
There are 0 rows in 0 pages for object 'AbsenceType'.
DBCC results for 'PYAppRole.d_Employees'.
There are 851 rows in 12 pages for object 'PYAppRole.d_Employees'.
DBCC results for 'BenefitPackage'.
There are 0 rows in 0 pages for object 'BenefitPackage'.
DBCC results for 'PYAppRole.PRCTLDEE'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLDEE'.
DBCC results for 'PYAppRole.POS'.
There are 0 rows in 0 pages for object 'PYAppRole.POS'.
DBCC results for 'PYAppRole.GenericAttachments'.
There are 0 rows in 0 pages for object 'PYAppRole.GenericAttachments'.
DBCC results for 'BenefitProvider'.
There are 0 rows in 0 pages for object 'BenefitProvider'.
DBCC results for 'PYAppRole.NetPaySession'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPaySession'.
DBCC results for 'PYAppRole.WFAttachments'.
There are 0 rows in 0 pages for object 'PYAppRole.WFAttachments'.
DBCC results for 'CodeTypes'.
There are 0 rows in 0 pages for object 'CodeTypes'.
DBCC results for 'PYAppRole.PRCTLDER'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLDER'.
DBCC results for 'PYAppRole.HRTABLES'.
There are 55 rows in 1 pages for object 'PYAppRole.HRTABLES'.
DBCC results for 'PYAppRole.BusinessObjectDetails'.
There are 111 rows in 1 pages for object 'PYAppRole.BusinessObjectDetails'.
DBCC results for 'PYAppRole.WFComments'.
There are 0 rows in 0 pages for object 'PYAppRole.WFComments'.
DBCC results for 'ColorScheme'.
There are 0 rows in 1 pages for object 'ColorScheme'.
DBCC results for 'PYAppRole.WFExecutionPacket'.
There are 0 rows in 0 pages for object 'PYAppRole.WFExecutionPacket'.
DBCC results for 'CompSurveyCompensation'.
There are 0 rows in 1 pages for object 'CompSurveyCompensation'.
DBCC results for 'PYAppRole.PRCTLGM'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLGM'.
DBCC results for 'PYAppRole.TAXR1'.
There are 7 rows in 1 pages for object 'PYAppRole.TAXR1'.
DBCC results for 'CompSurveyCompensationHist'.
There are 0 rows in 1 pages for object 'CompSurveyCompensationHist'.
DBCC results for 'PYAppRole.WFExecutionPacketTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.WFExecutionPacketTemplates'.
DBCC results for 'CompSurveyJobsHist'.
There are 0 rows in 1 pages for object 'CompSurveyJobsHist'.
DBCC results for 'PYAppRole.PRCTLGD'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLGD'.
DBCC results for 'PYAppRole.DEPS'.
There are 99 rows in 1 pages for object 'PYAppRole.DEPS'.
DBCC results for 'PYAppRole.SystemUsers'.
There are 122 rows in 3 pages for object 'PYAppRole.SystemUsers'.
DBCC results for 'PYAppRole.WFInitiationPolicies'.
There are 0 rows in 0 pages for object 'PYAppRole.WFInitiationPolicies'.
DBCC results for 'PYAppRole.AttachmentMasters'.
There are 18 rows in 1 pages for object 'PYAppRole.AttachmentMasters'.
DBCC results for 'CompSurveyLocationHist'.
There are 0 rows in 1 pages for object 'CompSurveyLocationHist'.
DBCC results for 'Interview'.
There are 0 rows in 1 pages for object 'Interview'.
DBCC results for 'PYAppRole.Setup_Screens'.
There are 0 rows in 0 pages for object 'PYAppRole.Setup_Screens'.
DBCC results for 'PYAppRole.WFNotificationPolicies'.
There are 0 rows in 0 pages for object 'PYAppRole.WFNotificationPolicies'.
DBCC results for 'CompSurveyVendor'.
There are 0 rows in 1 pages for object 'CompSurveyVendor'.
DBCC results for 'PYAppRole.PRCTLGS'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLGS'.
DBCC results for 'PYAppRole.CMPDEF'.
There are 355 rows in 3 pages for object 'PYAppRole.CMPDEF'.
DBCC results for 'PYAppRole.WFOriginators'.
There are 20 rows in 1 pages for object 'PYAppRole.WFOriginators'.
DBCC results for 'CompanyCalendar'.
There are 0 rows in 1 pages for object 'CompanyCalendar'.
DBCC results for 'PYAppRole.d_EmpMiscValues'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmpMiscValues'.
DBCC results for 'PYAppRole.WFEventTemplates'.
There are 23 rows in 1 pages for object 'PYAppRole.WFEventTemplates'.
DBCC results for 'CompanyDefaults'.
There are 0 rows in 1 pages for object 'CompanyDefaults'.
DBCC results for 'PYAppRole.d_EmployeeBenefits'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeBenefits'.
DBCC results for 'Currency'.
There are 0 rows in 1 pages for object 'Currency'.
DBCC results for 'Document'.
There are 0 rows in 1 pages for object 'Document'.
DBCC results for 'PYAppRole.PRCTLFO'.
There are 12 rows in 1 pages for object 'PYAppRole.PRCTLFO'.
DBCC results for 'PYAppRole.UDCON'.
There are 15 rows in 1 pages for object 'PYAppRole.UDCON'.
DBCC results for 'PYAppRole.Setup_Fields'.
There are 0 rows in 0 pages for object 'PYAppRole.Setup_Fields'.
DBCC results for 'EeoHistory'.
There are 0 rows in 0 pages for object 'EeoHistory'.
DBCC results for 'EmployeeAddressTable'.
There are 0 rows in 0 pages for object 'EmployeeAddressTable'.
DBCC results for 'PYAppRole.PRCTLFE'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLFE'.
DBCC results for 'PYAppRole.ACCRULES'.
There are 1 rows in 1 pages for object 'PYAppRole.ACCRULES'.
DBCC results for 'PYAppRole.PCDefaultBOTemplates'.
There are 20 rows in 1 pages for object 'PYAppRole.PCDefaultBOTemplates'.
DBCC results for 'Equipment'.
There are 0 rows in 1 pages for object 'Equipment'.
DBCC results for 'Export'.
There are 0 rows in 1 pages for object 'Export'.
DBCC results for 'PYAppRole.PRCTLEM'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLEM'.
DBCC results for 'PYAppRole.ACRSCHED'.
There are 1 rows in 1 pages for object 'PYAppRole.ACRSCHED'.
DBCC results for 'PYAppRole.WebPayGrid'.
There are 0 rows in 1 pages for object 'PYAppRole.WebPayGrid'.
DBCC results for 'PYAppRole.PCSkillTemplates'.
There are 2 rows in 1 pages for object 'PYAppRole.PCSkillTemplates'.
DBCC results for 'ExternalIDModule'.
There are 0 rows in 1 pages for object 'ExternalIDModule'.
DBCC results for 'FlatOrg'.
There are 0 rows in 1 pages for object 'FlatOrg'.
DBCC results for 'PYAppRole.PRCTLCT'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLCT'.
DBCC results for 'PYAppRole.d_EmpCodingLevels'.
There are 333 rows in 4 pages for object 'PYAppRole.d_EmpCodingLevels'.
DBCC results for 'PYAppRole.JOBTRK'.
There are 15665 rows in 1971 pages for object 'PYAppRole.JOBTRK'.
DBCC results for 'PYAppRole.NetPayServerRequests'.
There are 0 rows in 0 pages for object 'PYAppRole.NetPayServerRequests'.
DBCC results for 'Frequency'.
There are 0 rows in 1 pages for object 'Frequency'.
DBCC results for 'PYAppRole.SystemRoles'.
There are 2 rows in 1 pages for object 'PYAppRole.SystemRoles'.
DBCC results for 'PYAppRole.PCCategorySkill'.
There are 8 rows in 1 pages for object 'PYAppRole.PCCategorySkill'.
DBCC results for 'JobGrade'.
There are 0 rows in 1 pages for object 'JobGrade'.
DBCC results for 'PYAppRole.PRCTLCS'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLCS'.
DBCC results for 'PYAppRole.EAH'.
There are 3191 rows in 26 pages for object 'PYAppRole.EAH'.
DBCC results for 'PYAppRole.SSConfig'.
There are 1 rows in 1 pages for object 'PYAppRole.SSConfig'.
DBCC results for 'LevelDefault'.
There are 0 rows in 0 pages for object 'LevelDefault'.
DBCC results for 'PYAppRole.SSPage'.
There are 12 rows in 1 pages for object 'PYAppRole.SSPage'.
DBCC results for 'PYAppRole.d_BenefitItems'.
There are 0 rows in 0 pages for object 'PYAppRole.d_BenefitItems'.
DBCC results for 'Location'.
There are 0 rows in 1 pages for object 'Location'.
DBCC results for 'PYAppRole.PRCTLCE'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLCE'.
DBCC results for 'PYAppRole.EMPTAX'.
There are 24404 rows in 2035 pages for object 'PYAppRole.EMPTAX'.
DBCC results for 'PYAppRole.PCPositionTemplates'.
There are 6 rows in 1 pages for object 'PYAppRole.PCPositionTemplates'.
DBCC results for 'NextObjectIDToAssign'.
There are 0 rows in 1 pages for object 'NextObjectIDToAssign'.
DBCC results for 'Page'.
There are 0 rows in 0 pages for object 'Page'.
DBCC results for 'PYAppRole.NetPayDSNList'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayDSNList'.
DBCC results for 'PYAppRole.PRCTLACH'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLACH'.
DBCC results for 'PYAppRole.d_ContactInfo'.
There are 596 rows in 7 pages for object 'PYAppRole.d_ContactInfo'.
DBCC results for 'PYAppRole.STEREC'.
There are 20216 rows in 812 pages for object 'PYAppRole.STEREC'.
DBCC results for 'PageAuthorization'.
There are 0 rows in 1 pages for object 'PageAuthorization'.
DBCC results for 'PYAppRole.SSRolePage'.
There are 11 rows in 1 pages for object 'PYAppRole.SSRolePage'.
DBCC results for 'PageSaved'.
There are 0 rows in 1 pages for object 'PageSaved'.
DBCC results for 'PYAppRole.PRCTLST'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLST'.
DBCC results for 'Process'.
There are 0 rows in 0 pages for object 'Process'.
DBCC results for 'PYAppRole.SSUser'.
There are 165 rows in 4 pages for object 'PYAppRole.SSUser'.
DBCC results for 'RecruitmentSource'.
There are 0 rows in 1 pages for object 'RecruitmentSource'.
DBCC results for 'PYAppRole.STS_RECORD'.
There are 0 rows in 0 pages for object 'PYAppRole.STS_RECORD'.
DBCC results for 'Room'.
There are 0 rows in 1 pages for object 'Room'.
DBCC results for 'PYAppRole.BusinessObjectSecurity'.
There are 0 rows in 0 pages for object 'PYAppRole.BusinessObjectSecurity'.
DBCC results for 'Schedule'.
There are 0 rows in 1 pages for object 'Schedule'.
DBCC results for 'PYAppRole.SDI'.
There are 14 rows in 1 pages for object 'PYAppRole.SDI'.
DBCC results for 'PYAppRole.SSUserRole'.
There are 165 rows in 1 pages for object 'PYAppRole.SSUserRole'.
DBCC results for 'SectionAuthorization'.
There are 0 rows in 1 pages for object 'SectionAuthorization'.
DBCC results for 'PYAppRole.d_Beneficiaries'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Beneficiaries'.
DBCC results for 'SectionColumn'.
There are 0 rows in 1 pages for object 'SectionColumn'.
DBCC results for 'PYAppRole.QTRLINES'.
There are 0 rows in 0 pages for object 'PYAppRole.QTRLINES'.
DBCC results for 'PYAppRole.LTR'.
There are 4 rows in 1 pages for object 'PYAppRole.LTR'.
DBCC results for 'PYAppRole.SSDelimiter'.
There are 6 rows in 1 pages for object 'PYAppRole.SSDelimiter'.
DBCC results for 'SectionColumnAuthorization'.
There are 0 rows in 1 pages for object 'SectionColumnAuthorization'.
DBCC results for 'PYAppRole.WFProcessClassTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.WFProcessClassTemplates'.
DBCC results for 'SectionColumnSaved'.
There are 0 rows in 1 pages for object 'SectionColumnSaved'.
DBCC results for 'PYAppRole.ESTTABLES'.
There are 0 rows in 0 pages for object 'PYAppRole.ESTTABLES'.
DBCC results for 'PYAppRole.REPS'.
There are 75 rows in 4 pages for object 'PYAppRole.REPS'.
DBCC results for 'PYAppRole.Taxr2'.
There are 1690 rows in 83 pages for object 'PYAppRole.Taxr2'.
DBCC results for 'PYAppRole.WFProcessTemplates'.
There are 9 rows in 1 pages for object 'PYAppRole.WFProcessTemplates'.
DBCC results for 'PYAppRole.SSAttribute'.
There are 7 rows in 1 pages for object 'PYAppRole.SSAttribute'.
DBCC results for 'SectionSaved'.
There are 0 rows in 1 pages for object 'SectionSaved'.
DBCC results for 'PYAppRole.Icons'.
There are 1036 rows in 11 pages for object 'PYAppRole.Icons'.
DBCC results for 'SurveyJobPosition'.
There are 0 rows in 1 pages for object 'SurveyJobPosition'.
DBCC results for 'PYAppRole.EINADD'.
There are 0 rows in 0 pages for object 'PYAppRole.EINADD'.
DBCC results for 'PYAppRole.LINES'.
There are 1493 rows in 24 pages for object 'PYAppRole.LINES'.
DBCC results for 'PYAppRole.Fica'.
There are 26 rows in 1 pages for object 'PYAppRole.Fica'.
DBCC results for 'PYAppRole.SSUserCriteria'.
There are 1 rows in 1 pages for object 'PYAppRole.SSUserCriteria'.
DBCC results for 'TrainingProgram'.
There are 0 rows in 1 pages for object 'TrainingProgram'.
DBCC results for 'PYAppRole.SystemPages'.
There are 232 rows in 3 pages for object 'PYAppRole.SystemPages'.
DBCC results for 'TransactionLog'.
There are 0 rows in 1 pages for object 'TransactionLog'.
DBCC results for 'PYAppRole.PRCTLRSR'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLRSR'.
DBCC results for 'PYAppRole.d_EmployeeNotes'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeNotes'.
DBCC results for 'PYAppRole.PRCTLCI'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLCI'.
DBCC results for 'PYAppRole.SSTopic'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTopic'.
DBCC results for 'UserAuthorization'.
There are 0 rows in 1 pages for object 'UserAuthorization'.
DBCC results for 'PYAppRole.PCSkills'.
There are 5 rows in 1 pages for object 'PYAppRole.PCSkills'.
DBCC results for 'Users'.
There are 1 rows in 1 pages for object 'Users'.
DBCC results for 'PYAppRole.PRCTLKSR'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLKSR'.
DBCC results for 'PYAppRole.PRCTLCJ'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLCJ'.
DBCC results for 'IntegrationMappingTable'.
There are 0 rows in 0 pages for object 'IntegrationMappingTable'.
DBCC results for 'PYAppRole.SSPageSection'.
There are 15 rows in 1 pages for object 'PYAppRole.SSPageSection'.
DBCC results for 'Vendor'.
There are 0 rows in 1 pages for object 'Vendor'.
DBCC results for 'WorkActionProposal'.
There are 0 rows in 1 pages for object 'WorkActionProposal'.
DBCC results for 'PYAppRole.W2REPS'.
There are 1 rows in 1 pages for object 'PYAppRole.W2REPS'.
DBCC results for 'PYAppRole.PRCTLHI'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLHI'.
DBCC results for 'PYAppRole.SSAudit'.
There are 0 rows in 0 pages for object 'PYAppRole.SSAudit'.
DBCC results for 'PYAppRole.PCDefaultBOs'.
There are 8 rows in 1 pages for object 'PYAppRole.PCDefaultBOs'.
DBCC results for 'Applicant'.
There are 0 rows in 1 pages for object 'Applicant'.
DBCC results for 'PYAppRole.W2_PR'.
There are 0 rows in 0 pages for object 'PYAppRole.W2_PR'.
DBCC results for 'PYAppRole.WFValues'.
There are 0 rows in 0 pages for object 'PYAppRole.WFValues'.
DBCC results for 'PYAppRole.d_PeopleEmployees'.
There are 262 rows in 3 pages for object 'PYAppRole.d_PeopleEmployees'.
DBCC results for 'BenefitPlan'.
There are 0 rows in 0 pages for object 'BenefitPlan'.
DBCC results for 'PYAppRole.PRCTLEC'.
There are 32 rows in 2 pages for object 'PYAppRole.PRCTLEC'.
DBCC results for 'CodeValues'.
There are 0 rows in 0 pages for object 'CodeValues'.
DBCC results for 'PYAppRole.SystemPageAccess'.
There are 0 rows in 0 pages for object 'PYAppRole.SystemPageAccess'.
DBCC results for 'CompSurveyJobs'.
There are 0 rows in 1 pages for object 'CompSurveyJobs'.
DBCC results for 'PYAppRole.W2_LINES'.
There are 28 rows in 1 pages for object 'PYAppRole.W2_LINES'.
DBCC results for 'PYAppRole.d_Accruals'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Accruals'.
DBCC results for 'PYAppRole.PRCTLEP'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLEP'.
DBCC results for 'eResHistory'.
There are 0 rows in 0 pages for object 'eResHistory'.
DBCC results for 'PYAppRole.PCEmpPositions'.
There are 0 rows in 0 pages for object 'PYAppRole.PCEmpPositions'.
DBCC results for 'CompSurveyLocation'.
There are 0 rows in 1 pages for object 'CompSurveyLocation'.
DBCC results for 'TransactionLog_MetoliusBACKUP'.
There are 0 rows in 1 pages for object 'TransactionLog_MetoliusBACKUP'.
DBCC results for 'CompanyProfile'.
There are 0 rows in 0 pages for object 'CompanyProfile'.
DBCC results for 'PYAppRole.PRCTLES'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLES'.
DBCC results for 'PYAppRole.PRCTLDT'.
There are 31 rows in 2 pages for object 'PYAppRole.PRCTLDT'.
DBCC results for 'Employee'.
There are 0 rows in 0 pages for object 'Employee'.
DBCC results for 'eResHistory_MetoliusConversion'.
There are 0 rows in 1 pages for object 'eResHistory_MetoliusConversion'.
DBCC results for 'Establishment'.
There are 0 rows in 1 pages for object 'Establishment'.
DBCC results for 'PYAppRole.PRCTLLC'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLLC'.
DBCC results for 'PYAppRole.PRCTLPP'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLPP'.
DBCC results for 'JobGradeCompensation'.
There are 0 rows in 1 pages for object 'JobGradeCompensation'.
DBCC results for 'PYAppRole.W2Format'.
There are 5 rows in 1 pages for object 'PYAppRole.W2Format'.
DBCC results for 'PYAppRole.SystemPageOverrides'.
There are 0 rows in 0 pages for object 'PYAppRole.SystemPageOverrides'.
DBCC results for 'LevelDefaultRule'.
There are 0 rows in 0 pages for object 'LevelDefaultRule'.
DBCC results for 'PYAppRole.PRCTLFC'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLFC'.
DBCC results for 'PYAppRole.W2MagMedia'.
There are 5 rows in 1 pages for object 'PYAppRole.W2MagMedia'.
DBCC results for 'PayrollGroup'.
There are 0 rows in 1 pages for object 'PayrollGroup'.
DBCC results for 'PYAppRole.d_EmployeeStatus'.
There are 55 rows in 1 pages for object 'PYAppRole.d_EmployeeStatus'.
DBCC results for 'PYAppRole.W2FormSetup'.
There are 5 rows in 1 pages for object 'PYAppRole.W2FormSetup'.
DBCC results for 'PermanentEquipment'.
There are 0 rows in 1 pages for object 'PermanentEquipment'.
DBCC results for 'PYAppRole.PRCTLAI'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLAI'.
DBCC results for 'PYAppRole.W2BoxSetup'.
There are 100 rows in 1 pages for object 'PYAppRole.W2BoxSetup'.
DBCC results for 'PYAppRole.PRCTLUE'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLUE'.
DBCC results for 'PYAppRole.WFOriginatorRoles'.
There are 0 rows in 0 pages for object 'PYAppRole.WFOriginatorRoles'.
DBCC results for 'Position'.
There are 0 rows in 0 pages for object 'Position'.
DBCC results for 'PYAppRole.W2BoxValues'.
There are 33 rows in 1 pages for object 'PYAppRole.W2BoxValues'.
DBCC results for 'ProcessStatus'.
There are 0 rows in 1 pages for object 'ProcessStatus'.
DBCC results for 'PYAppRole.PRCTLNC'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLNC'.
DBCC results for 'PYAppRole.W2BoxOperations'.
There are 42 rows in 1 pages for object 'PYAppRole.W2BoxOperations'.
DBCC results for 'PYAppRole.PRCTLPF'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLPF'.
DBCC results for 'ProcessSubject'.
There are 0 rows in 1 pages for object 'ProcessSubject'.
DBCC results for 'EmploymentTable_MetoliusBACKUP'.
There are 0 rows in 1 pages for object 'EmploymentTable_MetoliusBACKUP'.
DBCC results for 'ScheduleEquipmentNeed'.
There are 0 rows in 1 pages for object 'ScheduleEquipmentNeed'.
DBCC results for 'PYAppRole.APPLIST'.
There are 1 rows in 1 pages for object 'PYAppRole.APPLIST'.
DBCC results for 'PYAppRole.PRCTLB'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLB'.
DBCC results for 'EmploymentTable'.
There are 0 rows in 0 pages for object 'EmploymentTable'.
DBCC results for 'Section'.
There are 0 rows in 0 pages for object 'Section'.
DBCC results for 'EmploymentTable_PreCursorBACKUP1'.
There are 0 rows in 1 pages for object 'EmploymentTable_PreCursorBACKUP1'.
DBCC results for 'SystemPages'.
There are 0 rows in 1 pages for object 'SystemPages'.
DBCC results for 'PYAppRole.NetPayGenericList'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayGenericList'.
DBCC results for 'PYAppRole.APPDATAED'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAED'.
DBCC results for 'PYAppRole.PRCTL3P'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTL3P'.
DBCC results for 'EmploymentTable_PreCursorBACKUP2'.
There are 0 rows in 1 pages for object 'EmploymentTable_PreCursorBACKUP2'.
DBCC results for 'TrainingMedium'.
There are 0 rows in 1 pages for object 'TrainingMedium'.
DBCC results for 'EmploymentTable_PreCursorBACKUP3'.
There are 0 rows in 1 pages for object 'EmploymentTable_PreCursorBACKUP3'.
DBCC results for 'PYAppRole.InvalidDateChangeLog'.
There are 113 rows in 2 pages for object 'PYAppRole.InvalidDateChangeLog'.
DBCC results for 'UnfinishedProcess'.
There are 0 rows in 0 pages for object 'UnfinishedProcess'.
DBCC results for 'PYAppRole.APPDATADS'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATADS'.
DBCC results for 'PYAppRole.PRCTLCL'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLCL'.
DBCC results for 'PYAppRole.TimesheetTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.TimesheetTemplates'.
DBCC results for 'VendorContact'.
There are 0 rows in 1 pages for object 'VendorContact'.
DBCC results for 'PYAppRole.ProcessScreenPreferences'.
There are 4 rows in 1 pages for object 'PYAppRole.ProcessScreenPreferences'.
DBCC results for 'PYAppRole.d_Compensation'.
There are 14221 rows in 149 pages for object 'PYAppRole.d_Compensation'.
DBCC results for 'ApplicantSkill'.
There are 0 rows in 1 pages for object 'ApplicantSkill'.
DBCC results for 'PYAppRole.APPDATARF'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATARF'.
DBCC results for 'PYAppRole.PRCTLRR'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLRR'.
DBCC results for 'BeneficiaryDependentTable'.
There are 0 rows in 1 pages for object 'BeneficiaryDependentTable'.
DBCC results for 'PYAppRole.OrgUnits'.
There are 0 rows in 0 pages for object 'PYAppRole.OrgUnits'.
DBCC results for 'BenefitPackageCoverage'.
There are 0 rows in 0 pages for object 'BenefitPackageCoverage'.
DBCC results for 'PYAppRole.APPDATAEM'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAEM'.
DBCC results for 'PYAppRole.PRCTLRG'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLRG'.
DBCC results for 'CourseEnrollment'.
There are 0 rows in 1 pages for object 'CourseEnrollment'.
DBCC results for 'EmployeeAbsencesTable'.
There are 0 rows in 0 pages for object 'EmployeeAbsencesTable'.
DBCC results for 'PYAppRole.APPDATACO'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATACO'.
DBCC results for 'EmployeeEquipment'.
There are 0 rows in 1 pages for object 'EmployeeEquipment'.
DBCC results for 'EmployeePayRatesTable'.
There are 0 rows in 1 pages for object 'EmployeePayRatesTable'.
DBCC results for 'PYAppRole.APPDATAAN'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAAN'.
DBCC results for 'PYAppRole.PRCTLBT'.
There are 7 rows in 1 pages for object 'PYAppRole.PRCTLBT'.
DBCC results for 'EmployeePerfReviewTable'.
There are 0 rows in 1 pages for object 'EmployeePerfReviewTable'.
DBCC results for 'EmployeeSkillTable'.
There are 0 rows in 0 pages for object 'EmployeeSkillTable'.
DBCC results for 'PYAppRole.APPDATAOD'.
There are 1 rows in 1 pages for object 'PYAppRole.APPDATAOD'.
DBCC results for 'PYAppRole.SCRSEC'.
There are 54 rows in 5 pages for object 'PYAppRole.SCRSEC'.
DBCC results for 'EmployeeTrainingNeed'.
There are 0 rows in 1 pages for object 'EmployeeTrainingNeed'.
DBCC results for 'PYAppRole.EmpAltW4'.
There are 0 rows in 0 pages for object 'PYAppRole.EmpAltW4'.
DBCC results for 'PYAppRole.d_EmployeeEEO'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeEEO'.
DBCC results for 'EmployeeWorkActionTable'.
There are 0 rows in 1 pages for object 'EmployeeWorkActionTable'.
DBCC results for 'PYAppRole.SYSOPTION'.
There are 120 rows in 2 pages for object 'PYAppRole.SYSOPTION'.
DBCC results for 'PYAppRole.USERNOTE'.
There are 0 rows in 0 pages for object 'PYAppRole.USERNOTE'.
DBCC results for 'PYAppRole.TimesheetSettingsByRole'.
There are 0 rows in 0 pages for object 'PYAppRole.TimesheetSettingsByRole'.
DBCC results for 'PYAppRole.WFPageSets'.
There are 4 rows in 1 pages for object 'PYAppRole.WFPageSets'.
DBCC results for 'EmploymentActionProposal'.
There are 0 rows in 1 pages for object 'EmploymentActionProposal'.
DBCC results for 'PYAppRole.SSEntry'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntry'.
DBCC results for 'PYAppRole.WFPages'.
There are 4 rows in 1 pages for object 'PYAppRole.WFPages'.
DBCC results for 'PYAppRole.SSTemplateAvailableCodes'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTemplateAvailableCodes'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'CortSouthwick'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.





DBCC results for 'CortGrieco'.
DBCC results for 'sysobjects'.
There are 2402 rows in 42 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1236 rows in 64 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 16122 rows in 267 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 75 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 1791 rows in 432 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 831 rows in 6 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 31 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 9523 rows in 53 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 143 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 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 'PYAppRole.LOOKUP'.
There are 0 rows in 0 pages for object 'PYAppRole.LOOKUP'.
DBCC results for 'PYAppRole.SSEntryDetail'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryDetail'.
DBCC results for 'PYAppRole.UDParent'.
There are 0 rows in 0 pages for object 'PYAppRole.UDParent'.
DBCC results for 'InvestmentFund'.
There are 0 rows in 0 pages for object 'InvestmentFund'.
DBCC results for 'PYAppRole.WFSectionWidgets'.
There are 28 rows in 1 pages for object 'PYAppRole.WFSectionWidgets'.
DBCC results for 'OccupationalIllnessTable'.
There are 0 rows in 0 pages for object 'OccupationalIllnessTable'.
DBCC results for 'PYAppRole.d_EmployeeI9'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeI9'.
DBCC results for 'PYAppRole.SECFL'.
There are 39 rows in 3 pages for object 'PYAppRole.SECFL'.
DBCC results for 'PYAppRole.SSTemplate'.
There are 1 rows in 1 pages for object 'PYAppRole.SSTemplate'.
DBCC results for 'OrganizationalUnit'.
There are 0 rows in 0 pages for object 'OrganizationalUnit'.
DBCC results for 'PayrollExport'.
There are 0 rows in 1 pages for object 'PayrollExport'.
DBCC results for 'PYAppRole.SSScripts'.
There are 1 rows in 1 pages for object 'PYAppRole.SSScripts'.
DBCC results for 'PYAppRole.SESSION'.
There are 114 rows in 1 pages for object 'PYAppRole.SESSION'.
DBCC results for 'PYAppRole.SSEntryCodeList'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryCodeList'.
DBCC results for 'PYAppRole.UDChild'.
There are 0 rows in 0 pages for object 'PYAppRole.UDChild'.
DBCC results for 'PositionTraining'.
There are 0 rows in 1 pages for object 'PositionTraining'.
DBCC results for 'Prerequisite'.
There are 0 rows in 1 pages for object 'Prerequisite'.
DBCC results for 'PYAppRole.UDTIME'.
There are 0 rows in 0 pages for object 'PYAppRole.UDTIME'.
DBCC results for 'PYAppRole.SSTimeSheetDetails'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTimeSheetDetails'.
DBCC results for 'Reference'.
There are 0 rows in 1 pages for object 'Reference'.
DBCC results for 'InfiniumPY.RolePassword'.
There are 1 rows in 1 pages for object 'InfiniumPY.RolePassword'.
DBCC results for 'SkillFulfillment'.
There are 0 rows in 1 pages for object 'SkillFulfillment'.
DBCC results for 'PYAppRole.COBRA'.
There are 0 rows in 0 pages for object 'PYAppRole.COBRA'.
DBCC results for 'PYAppRole.SSAdditionalEntries'.
There are 0 rows in 0 pages for object 'PYAppRole.SSAdditionalEntries'.
DBCC results for 'PYAppRole.EMPS'.
There are 1306 rows in 119 pages for object 'PYAppRole.EMPS'.
DBCC results for 'SurveyLocationLocation'.
There are 0 rows in 1 pages for object 'SurveyLocationLocation'.
DBCC results for 'Team'.
There are 0 rows in 1 pages for object 'Team'.
DBCC results for 'PYAppRole.CDEPSBEN'.
There are 0 rows in 0 pages for object 'PYAppRole.CDEPSBEN'.
DBCC results for 'PYAppRole.SSEntryDef'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryDef'.
DBCC results for 'PYAppRole.OLDNEW'.
There are 0 rows in 0 pages for object 'PYAppRole.OLDNEW'.
DBCC results for 'TrainingSteps'.
There are 0 rows in 1 pages for object 'TrainingSteps'.
DBCC results for 'WorkflowAlias'.
There are 0 rows in 1 pages for object 'WorkflowAlias'.
DBCC results for 'PYAppRole.d_EmpTaxingInfo'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmpTaxingInfo'.
DBCC results for 'PYAppRole.PRCTLDL_Old'.
There are 7 rows in 1 pages for object 'PYAppRole.PRCTLDL_Old'.
DBCC results for 'PYAppRole.COBAR'.
There are 0 rows in 0 pages for object 'PYAppRole.COBAR'.
DBCC results for 'PYAppRole.HREMP'.
There are 147 rows in 8 pages for object 'PYAppRole.HREMP'.
DBCC results for 'AliasesAssociation'.
There are 0 rows in 1 pages for object 'AliasesAssociation'.
DBCC results for 'PYAppRole.PRCTLDL'.
There are 7 rows in 1 pages for object 'PYAppRole.PRCTLDL'.
DBCC results for 'PYAppRole.SSEntryDetailDef'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntryDetailDef'.
DBCC results for 'PYAppRole.WFAdministrators'.
There are 0 rows in 0 pages for object 'PYAppRole.WFAdministrators'.
DBCC results for 'BeneficiaryDependentEnrollment'.
There are 0 rows in 0 pages for object 'BeneficiaryDependentEnrollment'.
DBCC results for 'PYAppRole.FLSA'.
There are 0 rows in 0 pages for object 'PYAppRole.FLSA'.
DBCC results for 'PYAppRole.BENS'.
There are 0 rows in 0 pages for object 'PYAppRole.BENS'.
DBCC results for 'PYAppRole.WFAdministratorProcesses'.
There are 0 rows in 0 pages for object 'PYAppRole.WFAdministratorProcesses'.
DBCC results for 'PYAppRole.SSTempEntryDetail'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTempEntryDetail'.
DBCC results for 'FundDesignation'.
There are 0 rows in 0 pages for object 'FundDesignation'.
DBCC results for 'PYAppRole.PRCTLX0'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLX0'.
DBCC results for 'PYAppRole.HIST'.
There are 44997 rows in 822 pages for object 'PYAppRole.HIST'.
DBCC results for 'PYAppRole.WFEngineParms'.
There are 1 rows in 1 pages for object 'PYAppRole.WFEngineParms'.
DBCC results for 'ManagementGroupTraining'.
There are 0 rows in 1 pages for object 'ManagementGroupTraining'.
DBCC results for 'ProcessActors'.
There are 0 rows in 1 pages for object 'ProcessActors'.
DBCC results for 'PYAppRole.ERRREC'.
There are 0 rows in 0 pages for object 'PYAppRole.ERRREC'.
DBCC results for 'PYAppRole.SPCRAT'.
There are 0 rows in 0 pages for object 'PYAppRole.SPCRAT'.
DBCC results for 'QualifiedInstructor'.
There are 0 rows in 1 pages for object 'QualifiedInstructor'.
DBCC results for 'PYAppRole.TimesheetAvailableCodes'.
There are 0 rows in 0 pages for object 'PYAppRole.TimesheetAvailableCodes'.
DBCC results for 'RequestForEmployee'.
There are 0 rows in 1 pages for object 'RequestForEmployee'.
DBCC results for 'PYAppRole.PRCTLPC'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLPC'.
DBCC results for 'PYAppRole.DEPEND'.
There are 0 rows in 0 pages for object 'PYAppRole.DEPEND'.
DBCC results for 'ScheduledTraining'.
There are 0 rows in 1 pages for object 'ScheduledTraining'.
DBCC results for 'PYAppRole.EmployeeAccessOptions'.
There are 0 rows in 0 pages for object 'PYAppRole.EmployeeAccessOptions'.
DBCC results for 'PYAppRole.WFActiveEmails'.
There are 0 rows in 0 pages for object 'PYAppRole.WFActiveEmails'.
DBCC results for 'PYAppRole.SORTREC'.
There are 0 rows in 0 pages for object 'PYAppRole.SORTREC'.
DBCC results for 'TeamMember'.
There are 0 rows in 1 pages for object 'TeamMember'.
DBCC results for 'PYAppRole.ZIP'.
There are 42791 rows in 203 pages for object 'PYAppRole.ZIP'.
DBCC results for 'PYAppRole.STDED'.
There are 13526 rows in 565 pages for object 'PYAppRole.STDED'.
DBCC results for 'Application'.
There are 0 rows in 1 pages for object 'Application'.
DBCC results for 'PYAppRole.Comments'.
There are 0 rows in 0 pages for object 'PYAppRole.Comments'.
DBCC results for 'PYAppRole.GLWF'.
There are 0 rows in 0 pages for object 'PYAppRole.GLWF'.
DBCC results for 'Interviewer'.
There are 0 rows in 1 pages for object 'Interviewer'.
DBCC results for 'PYAppRole.d_EmployeeDeductions'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeDeductions'.
DBCC results for 'PYAppRole.ZIPC'.
There are 0 rows in 0 pages for object 'PYAppRole.ZIPC'.
DBCC results for 'PYAppRole.EMPBEN'.
There are 0 rows in 0 pages for object 'PYAppRole.EMPBEN'.
DBCC results for 'Questionnaire'.
There are 0 rows in 1 pages for object 'Questionnaire'.
DBCC results for 'RecruitmentSourceForRequest'.
There are 0 rows in 1 pages for object 'RecruitmentSourceForRequest'.
DBCC results for 'PYAppRole.PRCTLP1'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLP1'.
DBCC results for 'PYAppRole.DEPSBEN'.
There are 0 rows in 0 pages for object 'PYAppRole.DEPSBEN'.
DBCC results for 'PYAppRole.WFActionTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.WFActionTemplates'.
DBCC results for 'PYAppRole.NetPayStates'.
There are 53 rows in 1 pages for object 'PYAppRole.NetPayStates'.
DBCC results for 'RequestApprover'.
There are 0 rows in 1 pages for object 'RequestApprover'.
DBCC results for 'PYAppRole.NetPayTEList'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayTEList'.
DBCC results for 'RequiredSkillForRequest'.
There are 0 rows in 1 pages for object 'RequiredSkillForRequest'.
DBCC results for 'PYAppRole.PRCTLZ0'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLZ0'.
DBCC results for 'PYAppRole.PROLLS'.
There are 789 rows in 40 pages for object 'PYAppRole.PROLLS'.
DBCC results for 'PYAppRole.NetPayReadFile'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayReadFile'.
DBCC results for 'HireApproval'.
There are 0 rows in 1 pages for object 'HireApproval'.
DBCC results for 'PYAppRole.SelfServiceOptions'.
There are 2 rows in 1 pages for object 'PYAppRole.SelfServiceOptions'.
DBCC results for 'PYAppRole.SSField'.
There are 71 rows in 1 pages for object 'PYAppRole.SSField'.
DBCC results for 'System'.
There are 0 rows in 0 pages for object 'System'.
DBCC results for 'PYAppRole.UDSecurity'.
There are 0 rows in 0 pages for object 'PYAppRole.UDSecurity'.
DBCC results for 'PYAppRole.WFAliasTemplates'.
There are 12 rows in 1 pages for object 'PYAppRole.WFAliasTemplates'.
DBCC results for 'PYAppRole.NetPayAccrualSchedule'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayAccrualSchedule'.
DBCC results for 'Question'.
There are 0 rows in 1 pages for object 'Question'.
DBCC results for 'PYAppRole.oldudevents'.
There are 0 rows in 0 pages for object 'PYAppRole.oldudevents'.
DBCC results for 'PYAppRole.ENTRY'.
There are 65203 rows in 5928 pages for object 'PYAppRole.ENTRY'.
DBCC results for 'ApplicationRating'.
There are 0 rows in 1 pages for object 'ApplicationRating'.
DBCC results for 'PYAppRole.W2_WORKREC'.
There are 0 rows in 0 pages for object 'PYAppRole.W2_WORKREC'.
DBCC results for 'PYAppRole.SSFieldUpdate'.
There are 76 rows in 1 pages for object 'PYAppRole.SSFieldUpdate'.
DBCC results for 'PYAppRole.NetPayAccrualStatus'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayAccrualStatus'.
DBCC results for 'PYAppRole.ATTMAST'.
There are 0 rows in 0 pages for object 'PYAppRole.ATTMAST'.
DBCC results for 'PYAppRole.RECUR'.
There are 119 rows in 10 pages for object 'PYAppRole.RECUR'.
DBCC results for 'PYAppRole.NetPayConfig'.
There are 1 rows in 1 pages for object 'PYAppRole.NetPayConfig'.
DBCC results for 'PYAppRole.SSPageSecurity'.
There are 13 rows in 1 pages for object 'PYAppRole.SSPageSecurity'.
DBCC results for 'PYAppRole.NetPayDeds'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayDeds'.
DBCC results for 'PYAppRole.STATS'.
There are 0 rows in 0 pages for object 'PYAppRole.STATS'.
DBCC results for 'PYAppRole.CURDED'.
There are 119267 rows in 2021 pages for object 'PYAppRole.CURDED'.
DBCC results for 'PYAppRole.NetPayEmpDeds'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayEmpDeds'.
DBCC results for 'PYAppRole.SSSectionSecurity'.
There are 16 rows in 1 pages for object 'PYAppRole.SSSectionSecurity'.
DBCC results for 'PYAppRole.NetPayEmps'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayEmps'.
DBCC results for 'PYAppRole.APPLICNT'.
There are 0 rows in 0 pages for object 'PYAppRole.APPLICNT'.
DBCC results for 'PYAppRole.CHECKS'.
There are 40868 rows in 5109 pages for object 'PYAppRole.CHECKS'.
DBCC results for 'PYAppRole.QTRSORTREC'.
There are 0 rows in 0 pages for object 'PYAppRole.QTRSORTREC'.
DBCC results for 'PYAppRole.d_DeductionAccumulators'.
There are 0 rows in 0 pages for object 'PYAppRole.d_DeductionAccumulators'.
DBCC results for 'PYAppRole.SSRoleDetails'.
There are 0 rows in 0 pages for object 'PYAppRole.SSRoleDetails'.
DBCC results for 'PYAppRole.WFDataPacketTemplates'.
There are 1 rows in 1 pages for object 'PYAppRole.WFDataPacketTemplates'.
DBCC results for 'PYAppRole.NetPayGL'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayGL'.
DBCC results for 'PYAppRole.POSTXT'.
There are 0 rows in 0 pages for object 'PYAppRole.POSTXT'.
DBCC results for 'PYAppRole.ELR'.
There are 0 rows in 0 pages for object 'PYAppRole.ELR'.
DBCC results for 'PYAppRole.WFDelegateList'.
There are 0 rows in 0 pages for object 'PYAppRole.WFDelegateList'.
DBCC results for 'PYAppRole.NetPayHistoryOfChanges'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayHistoryOfChanges'.
DBCC results for 'PYAppRole.OSHA101'.
There are 0 rows in 0 pages for object 'PYAppRole.OSHA101'.
DBCC results for 'PYAppRole.SECALIAS'.
There are 10 rows in 1 pages for object 'PYAppRole.SECALIAS'.
DBCC results for 'PYAppRole.SSRole'.
There are 1 rows in 1 pages for object 'PYAppRole.SSRole'.
DBCC results for 'PYAppRole.WFEmailTemplates'.
There are 8 rows in 1 pages for object 'PYAppRole.WFEmailTemplates'.
DBCC results for 'PYAppRole.NetPayItems'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayItems'.
DBCC results for 'PYAppRole.PRCTLEE'.
There are 10 rows in 1 pages for object 'PYAppRole.PRCTLEE'.
DBCC results for 'PYAppRole.EAR'.
There are 0 rows in 0 pages for object 'PYAppRole.EAR'.
DBCC results for 'PYAppRole.NetPayPayHistory'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayPayHistory'.
DBCC results for 'PYAppRole.OSHA200'.
There are 0 rows in 0 pages for object 'PYAppRole.OSHA200'.
DBCC results for 'EnrollmentTable_BACKUP'.
There are 0 rows in 1 pages for object 'EnrollmentTable_BACKUP'.
DBCC results for 'PYAppRole.NetPayPayrolls'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayPayrolls'.
DBCC results for 'PYAppRole.USERDATA'.
There are 1260 rows in 11 pages for object 'PYAppRole.USERDATA'.
DBCC results for 'PYAppRole.SSApproval'.
There are 0 rows in 0 pages for object 'PYAppRole.SSApproval'.
DBCC results for 'EnrollmentTable'.
There are 0 rows in 0 pages for object 'EnrollmentTable'.
DBCC results for 'PYAppRole.PRCTLVV_OLD'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLVV_OLD'.
DBCC results for 'PYAppRole.UDCONSM'.
There are 1 rows in 1 pages for object 'PYAppRole.UDCONSM'.
DBCC results for 'PYAppRole.d_People'.
There are 0 rows in 0 pages for object 'PYAppRole.d_People'.
DBCC results for 'PYAppRole.CREQD'.
There are 0 rows in 0 pages for object 'PYAppRole.CREQD'.
DBCC results for 'PYAppRole.NetPaySpTaxes'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPaySpTaxes'.
DBCC results for 'PYAppRole.SSSchedule'.
There are 0 rows in 1 pages for object 'PYAppRole.SSSchedule'.
DBCC results for 'PYAppRole.NetPayStateFields'.
There are 86 rows in 2 pages for object 'PYAppRole.NetPayStateFields'.
DBCC results for 'PYAppRole.PRCTLRP'.
There are 5 rows in 1 pages for object 'PYAppRole.PRCTLRP'.
DBCC results for 'PYAppRole.FLAGS'.
There are 357 rows in 3 pages for object 'PYAppRole.FLAGS'.
DBCC results for 'PYAppRole.BusinessObjects'.
There are 407 rows in 5 pages for object 'PYAppRole.BusinessObjects'.
DBCC results for 'PYAppRole.NetPayStateSelections'.
There are 114 rows in 1 pages for object 'PYAppRole.NetPayStateSelections'.
DBCC results for 'PYAppRole.PRCTLVV'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLVV'.
DBCC results for 'PYAppRole.NetPayTimeEntries'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayTimeEntries'.
DBCC results for 'PYAppRole.d_Dependents'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Dependents'.
DBCC results for 'PYAppRole.WORKRECORD'.
There are 0 rows in 0 pages for object 'PYAppRole.WORKRECORD'.
DBCC results for 'PYAppRole.ELIST'.
There are 0 rows in 0 pages for object 'PYAppRole.ELIST'.
DBCC results for 'PYAppRole.WFProcesses'.
There are 0 rows in 0 pages for object 'PYAppRole.WFProcesses'.
DBCC results for 'PYAppRole.NetPayUDData'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayUDData'.
DBCC results for 'PYAppRole.SECFL_old'.
There are 47 rows in 5 pages for object 'PYAppRole.SECFL_old'.
DBCC results for 'PYAppRole.WFEvents'.
There are 0 rows in 0 pages for object 'PYAppRole.WFEvents'.
DBCC results for 'PYAppRole.NetPayScheduleRate'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayScheduleRate'.
DBCC results for 'PYAppRole.PRCTLBG'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLBG'.
DBCC results for 'PYAppRole.ATT'.
There are 0 rows in 0 pages for object 'PYAppRole.ATT'.
DBCC results for 'PYAppRole.PTLOCAL'.
There are 1 rows in 1 pages for object 'PYAppRole.PTLOCAL'.
DBCC results for 'PYAppRole.Attachments'.
There are 0 rows in 0 pages for object 'PYAppRole.Attachments'.
DBCC results for 'AbsenceProposal'.
There are 0 rows in 1 pages for object 'AbsenceProposal'.
DBCC results for 'PYAppRole.PRCTLBO'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLBO'.
DBCC results for 'PYAppRole.BENPLN'.
There are 0 rows in 0 pages for object 'PYAppRole.BENPLN'.
DBCC results for 'PYAppRole.EMPGLP'.
There are 8 rows in 1 pages for object 'PYAppRole.EMPGLP'.
DBCC results for 'PYAppRole.d_DependentBenefits'.
There are 0 rows in 0 pages for object 'PYAppRole.d_DependentBenefits'.
DBCC results for 'AbsenceType'.
There are 0 rows in 0 pages for object 'AbsenceType'.
DBCC results for 'PYAppRole.d_Employees'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Employees'.
DBCC results for 'BenefitPackage'.
There are 0 rows in 0 pages for object 'BenefitPackage'.
DBCC results for 'PYAppRole.PRCTLDC'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLDC'.
DBCC results for 'PYAppRole.GRADES'.
There are 0 rows in 0 pages for object 'PYAppRole.GRADES'.
DBCC results for 'PYAppRole.GenericAttachments'.
There are 0 rows in 0 pages for object 'PYAppRole.GenericAttachments'.
DBCC results for 'BenefitProvider'.
There are 0 rows in 0 pages for object 'BenefitProvider'.
DBCC results for 'PYAppRole.NetPaySession'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPaySession'.
DBCC results for 'PYAppRole.WFAttachments'.
There are 0 rows in 0 pages for object 'PYAppRole.WFAttachments'.
DBCC results for 'CodeTypes'.
There are 0 rows in 0 pages for object 'CodeTypes'.
DBCC results for 'PYAppRole.PRCTLDEE'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLDEE'.
DBCC results for 'PYAppRole.POS'.
There are 0 rows in 0 pages for object 'PYAppRole.POS'.
DBCC results for 'PYAppRole.BusinessObjectDetails'.
There are 111 rows in 1 pages for object 'PYAppRole.BusinessObjectDetails'.
DBCC results for 'PYAppRole.WFComments'.
There are 0 rows in 0 pages for object 'PYAppRole.WFComments'.
DBCC results for 'ColorScheme'.
There are 0 rows in 1 pages for object 'ColorScheme'.
DBCC results for 'PYAppRole.WFExecutionPacket'.
There are 0 rows in 0 pages for object 'PYAppRole.WFExecutionPacket'.
DBCC results for 'CompSurveyCompensation'.
There are 0 rows in 1 pages for object 'CompSurveyCompensation'.
DBCC results for 'PYAppRole.PRCTLDER'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLDER'.
DBCC results for 'PYAppRole.HRTABLES'.
There are 3 rows in 1 pages for object 'PYAppRole.HRTABLES'.
DBCC results for 'CompSurveyCompensationHist'.
There are 0 rows in 1 pages for object 'CompSurveyCompensationHist'.
DBCC results for 'PYAppRole.WFExecutionPacketTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.WFExecutionPacketTemplates'.
DBCC results for 'CompSurveyJobsHist'.
There are 0 rows in 1 pages for object 'CompSurveyJobsHist'.
DBCC results for 'PYAppRole.PRCTLGM'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLGM'.
DBCC results for 'PYAppRole.TAXR1'.
There are 7 rows in 1 pages for object 'PYAppRole.TAXR1'.
DBCC results for 'PYAppRole.SystemUsers'.
There are 0 rows in 0 pages for object 'PYAppRole.SystemUsers'.
DBCC results for 'PYAppRole.WFInitiationPolicies'.
There are 0 rows in 0 pages for object 'PYAppRole.WFInitiationPolicies'.
DBCC results for 'PYAppRole.AttachmentMasters'.
There are 18 rows in 1 pages for object 'PYAppRole.AttachmentMasters'.
DBCC results for 'CompSurveyLocationHist'.
There are 0 rows in 1 pages for object 'CompSurveyLocationHist'.
DBCC results for 'Interview'.
There are 0 rows in 1 pages for object 'Interview'.
DBCC results for 'PYAppRole.Setup_Screens'.
There are 0 rows in 0 pages for object 'PYAppRole.Setup_Screens'.
DBCC results for 'PYAppRole.WFNotificationPolicies'.
There are 0 rows in 0 pages for object 'PYAppRole.WFNotificationPolicies'.
DBCC results for 'CompSurveyVendor'.
There are 0 rows in 1 pages for object 'CompSurveyVendor'.
DBCC results for 'PYAppRole.PRCTLGD'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLGD'.
DBCC results for 'PYAppRole.DEPS'.
There are 158 rows in 2 pages for object 'PYAppRole.DEPS'.
DBCC results for 'PYAppRole.WFOriginators'.
There are 20 rows in 1 pages for object 'PYAppRole.WFOriginators'.
DBCC results for 'CompanyCalendar'.
There are 0 rows in 1 pages for object 'CompanyCalendar'.
DBCC results for 'PYAppRole.d_EmpMiscValues'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmpMiscValues'.
DBCC results for 'PYAppRole.WFEventTemplates'.
There are 23 rows in 1 pages for object 'PYAppRole.WFEventTemplates'.
DBCC results for 'CompanyDefaults'.
There are 0 rows in 1 pages for object 'CompanyDefaults'.
DBCC results for 'PYAppRole.PRCTLGS'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLGS'.
DBCC results for 'PYAppRole.CMPDEF'.
There are 355 rows in 3 pages for object 'PYAppRole.CMPDEF'.
DBCC results for 'PYAppRole.d_EmployeeBenefits'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeBenefits'.
DBCC results for 'Currency'.
There are 0 rows in 1 pages for object 'Currency'.
DBCC results for 'Document'.
There are 0 rows in 1 pages for object 'Document'.
DBCC results for 'PYAppRole.Setup_Fields'.
There are 0 rows in 0 pages for object 'PYAppRole.Setup_Fields'.
DBCC results for 'EeoHistory'.
There are 0 rows in 0 pages for object 'EeoHistory'.
DBCC results for 'EmployeeAddressTable'.
There are 0 rows in 0 pages for object 'EmployeeAddressTable'.
DBCC results for 'PYAppRole.PRCTLFO'.
There are 13 rows in 1 pages for object 'PYAppRole.PRCTLFO'.
DBCC results for 'PYAppRole.UDCON'.
There are 13 rows in 1 pages for object 'PYAppRole.UDCON'.
DBCC results for 'PYAppRole.PCDefaultBOTemplates'.
There are 20 rows in 1 pages for object 'PYAppRole.PCDefaultBOTemplates'.
DBCC results for 'Equipment'.
There are 0 rows in 1 pages for object 'Equipment'.
DBCC results for 'Export'.
There are 0 rows in 1 pages for object 'Export'.
DBCC results for 'PYAppRole.PRCTLFE'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLFE'.
DBCC results for 'PYAppRole.ACCRULES'.
There are 0 rows in 0 pages for object 'PYAppRole.ACCRULES'.
DBCC results for 'PYAppRole.WebPayGrid'.
There are 0 rows in 1 pages for object 'PYAppRole.WebPayGrid'.
DBCC results for 'PYAppRole.PCSkillTemplates'.
There are 2 rows in 1 pages for object 'PYAppRole.PCSkillTemplates'.
DBCC results for 'ExternalIDModule'.
There are 0 rows in 1 pages for object 'ExternalIDModule'.
DBCC results for 'FlatOrg'.
There are 0 rows in 1 pages for object 'FlatOrg'.
DBCC results for 'PYAppRole.PRCTLEM'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLEM'.
DBCC results for 'PYAppRole.d_EmpCodingLevels'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmpCodingLevels'.
DBCC results for 'PYAppRole.ACRSCHED'.
There are 0 rows in 0 pages for object 'PYAppRole.ACRSCHED'.
DBCC results for 'PYAppRole.NetPayServerRequests'.
There are 0 rows in 0 pages for object 'PYAppRole.NetPayServerRequests'.
DBCC results for 'Frequency'.
There are 0 rows in 1 pages for object 'Frequency'.
DBCC results for 'PYAppRole.SystemRoles'.
There are 2 rows in 1 pages for object 'PYAppRole.SystemRoles'.
DBCC results for 'PYAppRole.PCCategorySkill'.
There are 8 rows in 1 pages for object 'PYAppRole.PCCategorySkill'.
DBCC results for 'JobGrade'.
There are 0 rows in 1 pages for object 'JobGrade'.
DBCC results for 'PYAppRole.PRCTLCT'.
There are 2 rows in 1 pages for object 'PYAppRole.PRCTLCT'.
DBCC results for 'PYAppRole.JOBTRK'.
There are 13343 rows in 1668 pages for object 'PYAppRole.JOBTRK'.
DBCC results for 'PYAppRole.SSConfig'.
There are 1 rows in 1 pages for object 'PYAppRole.SSConfig'.
DBCC results for 'LevelDefault'.
There are 0 rows in 0 pages for object 'LevelDefault'.
DBCC results for 'PYAppRole.SSPage'.
There are 12 rows in 1 pages for object 'PYAppRole.SSPage'.
DBCC results for 'PYAppRole.d_BenefitItems'.
There are 0 rows in 0 pages for object 'PYAppRole.d_BenefitItems'.
DBCC results for 'Location'.
There are 0 rows in 1 pages for object 'Location'.
DBCC results for 'PYAppRole.PRCTLCS'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLCS'.
DBCC results for 'PYAppRole.EAH'.
There are 3394 rows in 29 pages for object 'PYAppRole.EAH'.
DBCC results for 'PYAppRole.PCPositionTemplates'.
There are 6 rows in 1 pages for object 'PYAppRole.PCPositionTemplates'.
DBCC results for 'NextObjectIDToAssign'.
There are 0 rows in 1 pages for object 'NextObjectIDToAssign'.
DBCC results for 'Page'.
There are 0 rows in 0 pages for object 'Page'.
DBCC results for 'PYAppRole.NetPayDSNList'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayDSNList'.
DBCC results for 'PYAppRole.PRCTLCE'.
There are 4 rows in 1 pages for object 'PYAppRole.PRCTLCE'.
DBCC results for 'PYAppRole.d_ContactInfo'.
There are 0 rows in 0 pages for object 'PYAppRole.d_ContactInfo'.
DBCC results for 'PYAppRole.EMPTAX'.
There are 18162 rows in 1514 pages for object 'PYAppRole.EMPTAX'.
DBCC results for 'PageAuthorization'.
There are 0 rows in 1 pages for object 'PageAuthorization'.
DBCC results for 'PYAppRole.SSRolePage'.
There are 11 rows in 1 pages for object 'PYAppRole.SSRolePage'.
DBCC results for 'PageSaved'.
There are 0 rows in 1 pages for object 'PageSaved'.
DBCC results for 'PYAppRole.PRCTLACH'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLACH'.
DBCC results for 'PYAppRole.STEREC'.
There are 9733 rows in 390 pages for object 'PYAppRole.STEREC'.
DBCC results for 'Process'.
There are 0 rows in 0 pages for object 'Process'.
DBCC results for 'PYAppRole.SSUser'.
There are 0 rows in 0 pages for object 'PYAppRole.SSUser'.
DBCC results for 'RecruitmentSource'.
There are 0 rows in 1 pages for object 'RecruitmentSource'.
DBCC results for 'PYAppRole.PRCTLST'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLST'.
DBCC results for 'Room'.
There are 0 rows in 1 pages for object 'Room'.
DBCC results for 'PYAppRole.BusinessObjectSecurity'.
There are 0 rows in 0 pages for object 'PYAppRole.BusinessObjectSecurity'.
DBCC results for 'Schedule'.
There are 0 rows in 1 pages for object 'Schedule'.
DBCC results for 'PYAppRole.STS_RECORD'.
There are 0 rows in 0 pages for object 'PYAppRole.STS_RECORD'.
DBCC results for 'PYAppRole.SSUserRole'.
There are 0 rows in 0 pages for object 'PYAppRole.SSUserRole'.
DBCC results for 'SectionAuthorization'.
There are 0 rows in 1 pages for object 'SectionAuthorization'.
DBCC results for 'PYAppRole.d_Beneficiaries'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Beneficiaries'.
DBCC results for 'SectionColumn'.
There are 0 rows in 1 pages for object 'SectionColumn'.
DBCC results for 'PYAppRole.SDI'.
There are 9 rows in 1 pages for object 'PYAppRole.SDI'.
DBCC results for 'PYAppRole.SSDelimiter'.
There are 6 rows in 1 pages for object 'PYAppRole.SSDelimiter'.
DBCC results for 'SectionColumnAuthorization'.
There are 0 rows in 1 pages for object 'SectionColumnAuthorization'.
DBCC results for 'PYAppRole.WFProcessClassTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.WFProcessClassTemplates'.
DBCC results for 'SectionColumnSaved'.
There are 0 rows in 1 pages for object 'SectionColumnSaved'.
DBCC results for 'PYAppRole.QTRLINES'.
There are 0 rows in 0 pages for object 'PYAppRole.QTRLINES'.
DBCC results for 'PYAppRole.LTR'.
There are 4 rows in 1 pages for object 'PYAppRole.LTR'.
DBCC results for 'PYAppRole.Taxr2'.
There are 1690 rows in 83 pages for object 'PYAppRole.Taxr2'.
DBCC results for 'PYAppRole.WFProcessTemplates'.
There are 9 rows in 1 pages for object 'PYAppRole.WFProcessTemplates'.
DBCC results for 'PYAppRole.SSAttribute'.
There are 7 rows in 1 pages for object 'PYAppRole.SSAttribute'.
DBCC results for 'SectionSaved'.
There are 0 rows in 1 pages for object 'SectionSaved'.
DBCC results for 'PYAppRole.Icons'.
There are 1036 rows in 11 pages for object 'PYAppRole.Icons'.
DBCC results for 'SurveyJobPosition'.
There are 0 rows in 1 pages for object 'SurveyJobPosition'.
DBCC results for 'PYAppRole.ESTTABLES'.
There are 0 rows in 0 pages for object 'PYAppRole.ESTTABLES'.
DBCC results for 'PYAppRole.REPS'.
There are 150 rows in 8 pages for object 'PYAppRole.REPS'.
DBCC results for 'PYAppRole.Fica'.
There are 26 rows in 1 pages for object 'PYAppRole.Fica'.
DBCC results for 'PYAppRole.SSUserCriteria'.
There are 1 rows in 1 pages for object 'PYAppRole.SSUserCriteria'.
DBCC results for 'TrainingProgram'.
There are 0 rows in 1 pages for object 'TrainingProgram'.
DBCC results for 'PYAppRole.SystemPages'.
There are 232 rows in 3 pages for object 'PYAppRole.SystemPages'.
DBCC results for 'TransactionLog'.
There are 0 rows in 1 pages for object 'TransactionLog'.
DBCC results for 'PYAppRole.EINADD'.
There are 0 rows in 0 pages for object 'PYAppRole.EINADD'.
DBCC results for 'PYAppRole.d_EmployeeNotes'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeNotes'.
DBCC results for 'PYAppRole.LINES'.
There are 2594 rows in 41 pages for object 'PYAppRole.LINES'.
DBCC results for 'PYAppRole.SSTopic'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTopic'.
DBCC results for 'UserAuthorization'.
There are 0 rows in 1 pages for object 'UserAuthorization'.
DBCC results for 'PYAppRole.PCSkills'.
There are 5 rows in 1 pages for object 'PYAppRole.PCSkills'.
DBCC results for 'Users'.
There are 1 rows in 1 pages for object 'Users'.
DBCC results for 'PYAppRole.PRCTLRSR'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLRSR'.
DBCC results for 'PYAppRole.PRCTLCI'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLCI'.
DBCC results for 'IntegrationMappingTable'.
There are 0 rows in 0 pages for object 'IntegrationMappingTable'.
DBCC results for 'PYAppRole.SSPageSection'.
There are 15 rows in 1 pages for object 'PYAppRole.SSPageSection'.
DBCC results for 'Vendor'.
There are 0 rows in 1 pages for object 'Vendor'.
DBCC results for 'WorkActionProposal'.
There are 0 rows in 1 pages for object 'WorkActionProposal'.
DBCC results for 'PYAppRole.PRCTLKSR'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLKSR'.
DBCC results for 'PYAppRole.PRCTLCJ'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLCJ'.
DBCC results for 'PYAppRole.SSAudit'.
There are 0 rows in 0 pages for object 'PYAppRole.SSAudit'.
DBCC results for 'PYAppRole.PCDefaultBOs'.
There are 8 rows in 1 pages for object 'PYAppRole.PCDefaultBOs'.
DBCC results for 'Applicant'.
There are 0 rows in 1 pages for object 'Applicant'.
DBCC results for 'PYAppRole.W2_PR'.
There are 0 rows in 0 pages for object 'PYAppRole.W2_PR'.
DBCC results for 'PYAppRole.WFValues'.
There are 0 rows in 0 pages for object 'PYAppRole.WFValues'.
DBCC results for 'PYAppRole.d_PeopleEmployees'.
There are 0 rows in 0 pages for object 'PYAppRole.d_PeopleEmployees'.
DBCC results for 'BenefitPlan'.
There are 0 rows in 0 pages for object 'BenefitPlan'.
DBCC results for 'PYAppRole.W2REPS'.
There are 1 rows in 1 pages for object 'PYAppRole.W2REPS'.
DBCC results for 'PYAppRole.PRCTLHI'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLHI'.
DBCC results for 'CodeValues'.
There are 0 rows in 0 pages for object 'CodeValues'.
DBCC results for 'PYAppRole.SystemPageAccess'.
There are 0 rows in 0 pages for object 'PYAppRole.SystemPageAccess'.
DBCC results for 'CompSurveyJobs'.
There are 0 rows in 1 pages for object 'CompSurveyJobs'.
DBCC results for 'PYAppRole.d_Accruals'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Accruals'.
DBCC results for 'PYAppRole.PRCTLEC'.
There are 29 rows in 1 pages for object 'PYAppRole.PRCTLEC'.
DBCC results for 'eResHistory'.
There are 0 rows in 0 pages for object 'eResHistory'.
DBCC results for 'PYAppRole.PCEmpPositions'.
There are 0 rows in 0 pages for object 'PYAppRole.PCEmpPositions'.
DBCC results for 'CompSurveyLocation'.
There are 0 rows in 1 pages for object 'CompSurveyLocation'.
DBCC results for 'TransactionLog_MetoliusBACKUP'.
There are 0 rows in 1 pages for object 'TransactionLog_MetoliusBACKUP'.
DBCC results for 'CompanyProfile'.
There are 0 rows in 0 pages for object 'CompanyProfile'.
DBCC results for 'PYAppRole.W2_LINES'.
There are 28 rows in 1 pages for object 'PYAppRole.W2_LINES'.
DBCC results for 'PYAppRole.PRCTLEP'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLEP'.
DBCC results for 'Employee'.
There are 0 rows in 0 pages for object 'Employee'.
DBCC results for 'eResHistory_MetoliusConversion'.
There are 0 rows in 1 pages for object 'eResHistory_MetoliusConversion'.
DBCC results for 'Establishment'.
There are 0 rows in 1 pages for object 'Establishment'.
DBCC results for 'PYAppRole.PRCTLES'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLES'.
DBCC results for 'PYAppRole.PRCTLDT'.
There are 23 rows in 1 pages for object 'PYAppRole.PRCTLDT'.
DBCC results for 'JobGradeCompensation'.
There are 0 rows in 1 pages for object 'JobGradeCompensation'.
DBCC results for 'PYAppRole.W2Format'.
There are 0 rows in 0 pages for object 'PYAppRole.W2Format'.
DBCC results for 'PYAppRole.SystemPageOverrides'.
There are 0 rows in 0 pages for object 'PYAppRole.SystemPageOverrides'.
DBCC results for 'LevelDefaultRule'.
There are 0 rows in 0 pages for object 'LevelDefaultRule'.
DBCC results for 'PYAppRole.PRCTLLC'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLLC'.
DBCC results for 'PYAppRole.W2MagMedia'.
There are 0 rows in 0 pages for object 'PYAppRole.W2MagMedia'.
DBCC results for 'PYAppRole.PRCTLPP'.
There are 3 rows in 1 pages for object 'PYAppRole.PRCTLPP'.
DBCC results for 'PayrollGroup'.
There are 0 rows in 1 pages for object 'PayrollGroup'.
DBCC results for 'PYAppRole.d_EmployeeStatus'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeStatus'.
DBCC results for 'PYAppRole.W2FormSetup'.
There are 0 rows in 0 pages for object 'PYAppRole.W2FormSetup'.
DBCC results for 'PermanentEquipment'.
There are 0 rows in 1 pages for object 'PermanentEquipment'.
DBCC results for 'PYAppRole.PRCTLFC'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLFC'.
DBCC results for 'PYAppRole.W2BoxSetup'.
There are 0 rows in 0 pages for object 'PYAppRole.W2BoxSetup'.
DBCC results for 'PYAppRole.WFOriginatorRoles'.
There are 0 rows in 0 pages for object 'PYAppRole.WFOriginatorRoles'.
DBCC results for 'Position'.
There are 0 rows in 0 pages for object 'Position'.
DBCC results for 'PYAppRole.W2BoxValues'.
There are 0 rows in 0 pages for object 'PYAppRole.W2BoxValues'.
DBCC results for 'ProcessStatus'.
There are 0 rows in 1 pages for object 'ProcessStatus'.
DBCC results for 'PYAppRole.PRCTLAI'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLAI'.
DBCC results for 'PYAppRole.W2BoxOperations'.
There are 0 rows in 0 pages for object 'PYAppRole.W2BoxOperations'.
DBCC results for 'PYAppRole.PRCTLUE'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLUE'.
DBCC results for 'ProcessSubject'.
There are 0 rows in 1 pages for object 'ProcessSubject'.
DBCC results for 'EmploymentTable_MetoliusBACKUP'.
There are 0 rows in 1 pages for object 'EmploymentTable_MetoliusBACKUP'.
DBCC results for 'ScheduleEquipmentNeed'.
There are 0 rows in 1 pages for object 'ScheduleEquipmentNeed'.
DBCC results for 'PYAppRole.PRCTLNC'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLNC'.
DBCC results for 'PYAppRole.PRCTLPF'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLPF'.
DBCC results for 'EmploymentTable'.
There are 0 rows in 0 pages for object 'EmploymentTable'.
DBCC results for 'Section'.
There are 0 rows in 0 pages for object 'Section'.
DBCC results for 'EmploymentTable_PreCursorBACKUP1'.
There are 0 rows in 1 pages for object 'EmploymentTable_PreCursorBACKUP1'.
DBCC results for 'SystemPages'.
There are 0 rows in 1 pages for object 'SystemPages'.
DBCC results for 'PYAppRole.NetPayGenericList'.
There are 0 rows in 1 pages for object 'PYAppRole.NetPayGenericList'.
DBCC results for 'PYAppRole.APPLIST'.
There are 0 rows in 0 pages for object 'PYAppRole.APPLIST'.
DBCC results for 'PYAppRole.PRCTLB'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLB'.
DBCC results for 'EmploymentTable_PreCursorBACKUP2'.
There are 0 rows in 1 pages for object 'EmploymentTable_PreCursorBACKUP2'.
DBCC results for 'TrainingMedium'.
There are 0 rows in 1 pages for object 'TrainingMedium'.
DBCC results for 'EmploymentTable_PreCursorBACKUP3'.
There are 0 rows in 1 pages for object 'EmploymentTable_PreCursorBACKUP3'.
DBCC results for 'PYAppRole.InvalidDateChangeLog'.
There are 47160 rows in 516 pages for object 'PYAppRole.InvalidDateChangeLog'.
DBCC results for 'UnfinishedProcess'.
There are 0 rows in 0 pages for object 'UnfinishedProcess'.
DBCC results for 'PYAppRole.APPDATAED'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAED'.
DBCC results for 'PYAppRole.PRCTL3P'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTL3P'.
DBCC results for 'PYAppRole.TimesheetTemplates'.
There are 0 rows in 0 pages for object 'PYAppRole.TimesheetTemplates'.
DBCC results for 'VendorContact'.
There are 0 rows in 1 pages for object 'VendorContact'.
DBCC results for 'PYAppRole.ProcessScreenPreferences'.
There are 4 rows in 1 pages for object 'PYAppRole.ProcessScreenPreferences'.
DBCC results for 'PYAppRole.d_Compensation'.
There are 0 rows in 0 pages for object 'PYAppRole.d_Compensation'.
DBCC results for 'ApplicantSkill'.
There are 0 rows in 1 pages for object 'ApplicantSkill'.
DBCC results for 'PYAppRole.APPDATADS'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATADS'.
DBCC results for 'PYAppRole.PRCTLCL'.
There are 1 rows in 1 pages for object 'PYAppRole.PRCTLCL'.
DBCC results for 'BeneficiaryDependentTable'.
There are 0 rows in 1 pages for object 'BeneficiaryDependentTable'.
DBCC results for 'PYAppRole.OrgUnits'.
There are 0 rows in 0 pages for object 'PYAppRole.OrgUnits'.
DBCC results for 'BenefitPackageCoverage'.
There are 0 rows in 0 pages for object 'BenefitPackageCoverage'.
DBCC results for 'PYAppRole.APPDATARF'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATARF'.
DBCC results for 'PYAppRole.PRCTLRR'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLRR'.
DBCC results for 'CourseEnrollment'.
There are 0 rows in 1 pages for object 'CourseEnrollment'.
DBCC results for 'EmployeeAbsencesTable'.
There are 0 rows in 0 pages for object 'EmployeeAbsencesTable'.
DBCC results for 'PYAppRole.APPDATAEM'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAEM'.
DBCC results for 'PYAppRole.PRCTLRG'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLRG'.
DBCC results for 'EmployeeEquipment'.
There are 0 rows in 1 pages for object 'EmployeeEquipment'.
DBCC results for 'EmployeePayRatesTable'.
There are 0 rows in 1 pages for object 'EmployeePayRatesTable'.
DBCC results for 'PYAppRole.APPDATACO'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATACO'.
DBCC results for 'EmployeePerfReviewTable'.
There are 0 rows in 1 pages for object 'EmployeePerfReviewTable'.
DBCC results for 'EmployeeSkillTable'.
There are 0 rows in 0 pages for object 'EmployeeSkillTable'.
DBCC results for 'PYAppRole.APPDATAAN'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAAN'.
DBCC results for 'PYAppRole.PRCTLBT'.
There are 0 rows in 0 pages for object 'PYAppRole.PRCTLBT'.
DBCC results for 'EmployeeTrainingNeed'.
There are 0 rows in 1 pages for object 'EmployeeTrainingNeed'.
DBCC results for 'PYAppRole.EmpAltW4'.
There are 0 rows in 0 pages for object 'PYAppRole.EmpAltW4'.
DBCC results for 'PYAppRole.d_EmployeeEEO'.
There are 0 rows in 0 pages for object 'PYAppRole.d_EmployeeEEO'.
DBCC results for 'EmployeeWorkActionTable'.
There are 0 rows in 1 pages for object 'EmployeeWorkActionTable'.
DBCC results for 'PYAppRole.APPDATAOD'.
There are 0 rows in 0 pages for object 'PYAppRole.APPDATAOD'.
DBCC results for 'PYAppRole.SCRSEC'.
There are 46 rows in 4 pages for object 'PYAppRole.SCRSEC'.
DBCC results for 'PYAppRole.TimesheetSettingsByRole'.
There are 0 rows in 0 pages for object 'PYAppRole.TimesheetSettingsByRole'.
DBCC results for 'PYAppRole.WFPageSets'.
There are 4 rows in 1 pages for object 'PYAppRole.WFPageSets'.
DBCC results for 'EmploymentActionProposal'.
There are 0 rows in 1 pages for object 'EmploymentActionProposal'.
DBCC results for 'PYAppRole.SSEntry'.
There are 0 rows in 0 pages for object 'PYAppRole.SSEntry'.
DBCC results for 'PYAppRole.WFPages'.
There are 4 rows in 1 pages for object 'PYAppRole.WFPages'.
DBCC results for 'PYAppRole.SSTemplateAvailableCodes'.
There are 0 rows in 0 pages for object 'PYAppRole.SSTemplateAvailableCodes'.
DBCC results for 'PYAppRole.SYSOPTION'.
There are 110 rows in 1 pages for object 'PYAppRole.SYSOPTION'.
DBCC results for 'PYAppRole.USERNOTE'.
There are 0 rows in 0 pages for object 'PYAppRole.USERNOTE'.
DBCC results for 'PYAppRole.WFPageSections'.
There are 4 rows in 1 pages for object 'PYAppRole.WFPageSections'.
DBCC results for 'EquipmentNeeded'.
There are 0 rows in 1 pages for object 'EquipmentNeeded'.
DBCC results for 'PYAppRole.WFSections'.
There are 4 rows in 1 pages for object 'PYAppRole.WFSections'.
DBCC results for 'Instructor'.
There are 0 rows in 1 pages for object 'Instructor'.
DBCC results for 'PYAppRole.BenefitDetails'.
There are 0 rows in 1 pages for object 'PYAppRole.BenefitDetails'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'CortGrieco'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.



Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-15 : 11:35:02
So there's no activity at all on the CortGreico database? If that's the case, you've got a h/w problem. There's no other way for an error to appear and disappear on a totally quiescent database.

Are you using PAE? Do you have the Windows PAE fix installed?

Are all your drivers/firmware up-to-date? Can you run IO subsystem diagnostics? Is there any evidence of h/w issues in the SQL errorlog or Windows event logs?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-15 : 11:52:53
Hi paul,
Thanks for the quick reply. Don't use PAE - only have 1 gig of memory. I'll check for recent updates for drivers and firmware...haven't done that for about 6 months. Windows Event logs are clean for HW issues. Let me look into running diagnostics. Thanks for the info.


Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

r_darling
Starting Member

14 Posts

Posted - 2006-02-17 : 13:34:23
Hi Paul,
Do you recommend any other stress test, other than the SQLIOStress utility? Also, does anyone have any issues with the SQLIOStress utility? Thanks.

Richard Darling
MCSE/MCSA W2K W2K3
CSA HPUX
sec+, net+
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-17 : 18:54:12
Can't think of anything better.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-02-17 : 21:41:47
Probably not relevant, but if you want to test the RAM I would recommend
http://www.memtest86.com/

Needs a boot floppy (or used to!), and if it doesn't find something instantly you'll need to leave it running for 48 hours, or so, to be confident the machine is OK.

Useful for testing new kit before deploying it ... not so good for a live 24/7 server!

Kristen
Go to Top of Page

machine1
Starting Member

1 Post

Posted - 2006-03-27 : 16:53:38
Was there any resolution to this problem? I get the same thing periodically on one of our servers where I run a dbcc checktable on one table that's been having problems and get the following. I then run it again immediately and get no errors. We've tried restoring the entire database from the backup of the database that is on another server but still get this corruption on the same table periodically. I manage hundreds of databases on over 60 different servers and have never seen this problem. Also, the server team looked at the server and ran some things to check for disk problems and didn't find anything.

Thanks for any help anyone can provide.

Gene

Job 'Check Table' : Step 1, 'Run' : Began Executing 2006-03-27 05:40:01

Msg 8928, Sev 16: Object ID 1234207547, index ID 0: Page (1:884706) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8944, Sev 16: Table error: Object ID 1234207547, index ID 0, page (1:884706), row 11. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 33368 and 374. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'CV3TextualObservationLine'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 4542400 rows in 245668 pages for object 'CV3TextualObservationLine'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'CV3TextualObservationLine' (object ID 1234207547). [SQLSTATE 01000]
Msg 8958, Sev 16: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (BJHSCM.dbo.CV3TextualObservationLine ). [SQLSTATE 01000]
Go to Top of Page
    Next Page

- Advertisement -