DBCC error with upgrade for MS Dynamics 9

  • Follow


Hi,

I am testing a MS Dynamics 9 to 10 upgrade. According to the Upgrade 
Instructions release 10 (pg 25), I need to run [for database maintenance]

DBCC CHECKDB
DBCC CHECKCATALOG

against the DYNAMICS database and company databases.

When I run it against the DYNAMICS database, I get the following error:


DBCC results for 'DYNAMICS'.
DBCC results for 'sysobjects'.
There are 1718 rows in 23 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 662 rows in 37 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 10141 rows in 199 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 1559 rows in 461 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 1498 rows in 6 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 21 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 15145 rows in 86 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 2 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'SY70700'.
There are 13 rows in 1 pages for object 'SY70700'.
DBCC results for 'WDC41500'.
There are 0 rows in 0 pages for object 'WDC41500'.
DBCC results for 'SY03003'.
There are 0 rows in 0 pages for object 'SY03003'.
DBCC results for 'SYUPDATE'.
There are 0 rows in 0 pages for object 'SYUPDATE'.
DBCC results for 'SY03500'.
There are 1 rows in 1 pages for object 'SY03500'.
DBCC results for 'WDC51102'.
There are 145 rows in 1 pages for object 'WDC51102'.
DBCC results for 'SY03600'.
There are 0 rows in 0 pages for object 'SY03600'.
DBCC results for 'SY03700'.
There are 0 rows in 1 pages for object 'SY03700'.
DBCC results for 'SY01600'.
There are 78 rows in 4 pages for object 'SY01600'.
DBCC results for 'SY04000'.
There are 0 rows in 0 pages for object 'SY04000'.
DBCC results for 'STN41300'.
There are 1 rows in 1 pages for object 'STN41300'.
DBCC results for 'SY04300'.
There are 1 rows in 1 pages for object 'SY04300'.
DBCC results for 'SY04400'.
There are 0 rows in 0 pages for object 'SY04400'.
DBCC results for 'ACTIVITY'.
There are 0 rows in 1 pages for object 'ACTIVITY'.
DBCC results for 'ALERT3RD'.
There are 0 rows in 0 pages for object 'ALERT3RD'.
DBCC results for 'SY04701'.
There are 0 rows in 0 pages for object 'SY04701'.
DBCC results for 'CONSTANTS'.
There are 6762 rows in 521 pages for object 'CONSTANTS'.
DBCC results for 'SY04702'.
There are 0 rows in 0 pages for object 'SY04702'.
DBCC results for 'DBVERSION'.
There are 0 rows in 0 pages for object 'DBVERSION'.
DBCC results for 'DEFLTCOA'.
There are 1761 rows in 29 pages for object 'DEFLTCOA'.
DBCC results for 'SY04703'.
There are 0 rows in 0 pages for object 'SY04703'.
DBCC results for 'LKACTVTY'.
There are 0 rows in 0 pages for object 'LKACTVTY'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'SY04704'.
There are 0 rows in 0 pages for object 'SY04704'.
DBCC results for 'frl_ofsi_data'.
There are 1 rows in 1 pages for object 'frl_ofsi_data'.
DBCC results for 'SY05000'.
There are 0 rows in 0 pages for object 'SY05000'.
DBCC results for 'ASIEXP86'.
There are 1344 rows in 51 pages for object 'ASIEXP86'.
DBCC results for 'SY05100'.
There are 1212 rows in 3 pages for object 'SY05100'.
DBCC results for 'ASIEXP81'.
There are 199 rows in 40 pages for object 'ASIEXP81'.
DBCC results for 'SY01500'.
There are 5 rows in 1 pages for object 'SY01500'.
DBCC results for 'GPS_SQL_Error_Codes'.
There are 1016 rows in 40 pages for object 'GPS_SQL_Error_Codes'.
DBCC results for 'SY05400'.
There are 0 rows in 0 pages for object 'SY05400'.
DBCC results for 'IC40100'.
There are 0 rows in 0 pages for object 'IC40100'.
DBCC results for 'SY05501'.
There are 0 rows in 0 pages for object 'SY05501'.
DBCC results for 'ASIEXP50'.
There are 0 rows in 0 pages for object 'ASIEXP50'.
DBCC results for 'SY40200'.
There are 0 rows in 0 pages for object 'SY40200'.
DBCC results for 'SY40300'.
There are 0 rows in 1 pages for object 'SY40300'.
DBCC results for 'MC00100'.
There are 102 rows in 2 pages for object 'MC00100'.
DBCC results for 'SY40400'.
There are 0 rows in 1 pages for object 'SY40400'.
DBCC results for 'MC40200'.
There are 10 rows in 1 pages for object 'MC40200'.
DBCC results for 'SY40500'.
There are 55 rows in 6 pages for object 'SY40500'.
DBCC results for 'MC40300'.
There are 17 rows in 1 pages for object 'MC40300'.
DBCC results for 'ASIEXP51'.
There are 0 rows in 0 pages for object 'ASIEXP51'.
DBCC results for 'SY60100'.
There are 24 rows in 1 pages for object 'SY60100'.
DBCC results for 'MC40400'.
There are 0 rows in 0 pages for object 'MC40400'.
DBCC results for 'WDC51100'.
There are 44 rows in 1 pages for object 'WDC51100'.
DBCC results for 'MC40401'.
There are 0 rows in 0 pages for object 'MC40401'.
DBCC results for 'MC60100'.
There are 10 rows in 1 pages for object 'MC60100'.
DBCC results for 'SY40501'.
There are 442 rows in 10 pages for object 'SY40501'.
DBCC results for 'MC60200'.
There are 17 rows in 1 pages for object 'MC60200'.
DBCC results for 'SY40502'.
There are 115 rows in 2 pages for object 'SY40502'.
DBCC results for 'WDC41300'.
There are 0 rows in 0 pages for object 'WDC41300'.
DBCC results for 'MESSAGES'.
There are 23923 rows in 825 pages for object 'MESSAGES'.
DBCC results for 'SY40503'.
There are 375 rows in 8 pages for object 'SY40503'.
DBCC results for 'ORG00100'.
There are 0 rows in 0 pages for object 'ORG00100'.
DBCC results for 'SY40504'.
There are 235 rows in 9 pages for object 'SY40504'.
DBCC results for 'ASITAB20'.
There are 6838 rows in 855 pages for object 'ASITAB20'.
DBCC results for 'ORG40000'.
There are 0 rows in 0 pages for object 'ORG40000'.
DBCC results for 'SY40505'.
There are 0 rows in 0 pages for object 'SY40505'.
DBCC results for 'SY40506'.
There are 0 rows in 0 pages for object 'SY40506'.
DBCC results for 'ORG40100'.
There are 0 rows in 0 pages for object 'ORG40100'.
DBCC results for 'PATH'.
There are 0 rows in 0 pages for object 'PATH'.
DBCC results for 'WDC51101'.
There are 146897 rows in 1099 pages for object 'WDC51101'.
DBCC results for 'STN41100'.
There are 2 rows in 1 pages for object 'STN41100'.
DBCC results for 'DB_Upgrade'.
There are 84 rows in 1 pages for object 'DB_Upgrade'.
DBCC results for 'SY80000'.
There are 0 rows in 0 pages for object 'SY80000'.
DBCC results for 'ASITAB30'.
There are 32 rows in 1 pages for object 'ASITAB30'.
DBCC results for 'DU000010'.
There are 236 rows in 11 pages for object 'DU000010'.
DBCC results for 'STN41200'.
There are 223 rows in 3 pages for object 'STN41200'.
DBCC results for 'UPR10300'.
There are 0 rows in 0 pages for object 'UPR10300'.
DBCC results for 'SY90100'.
There are 0 rows in 0 pages for object 'SY90100'.
DBCC results for 'UPR10304'.
There are 0 rows in 0 pages for object 'UPR10304'.
DBCC results for 'UPR41105'.
There are 262 rows in 2 pages for object 'UPR41105'.
DBCC results for 'CHG_RG01'.
There are 1 rows in 1 pages for object 'CHG_RG01'.
DBCC results for 'UPR41300'.
There are 0 rows in 0 pages for object 'UPR41300'.
DBCC results for 'ASIEXP83'.
There are 58 rows in 2 pages for object 'ASIEXP83'.
DBCC results for 'UPR41301'.
There are 0 rows in 0 pages for object 'UPR41301'.
DBCC results for 'SY05300'.
There are 358 rows in 6 pages for object 'SY05300'.
DBCC results for 'STN41350'.
There are 0 rows in 0 pages for object 'STN41350'.
DBCC results for 'UPR41302'.
There are 0 rows in 0 pages for object 'UPR41302'.
DBCC results for 'SY07110'.
There are 822 rows in 5 pages for object 'SY07110'.
DBCC results for 'SY_SQL_Options'.
There are 1 rows in 1 pages for object 'SY_SQL_Options'.
DBCC results for 'UPR41303'.
There are 0 rows in 0 pages for object 'UPR41303'.
DBCC results for 'SY003001'.
There are 1 rows in 1 pages for object 'SY003001'.
DBCC results for 'DU000020'.
There are 73 rows in 3 pages for object 'DU000020'.
DBCC results for 'WDC41101'.
There are 1 rows in 1 pages for object 'WDC41101'.
DBCC results for 'SY00302'.
There are 5 rows in 1 pages for object 'SY00302'.
DBCC results for 'DU000030'.
There are 442 rows in 16 pages for object 'DU000030'.
DBCC results for 'UPR41600'.
There are 4 rows in 1 pages for object 'UPR41600'.
DBCC results for 'SY01403'.
There are 10 rows in 3 pages for object 'SY01403'.
DBCC results for 'SY00800'.
There are 1 rows in 1 pages for object 'SY00800'.
DBCC results for 'SY01404'.
There are 53 rows in 3 pages for object 'SY01404'.
DBCC results for 'W200001'.
There are 0 rows in 0 pages for object 'W200001'.
DBCC results for 'SY00801'.
There are 0 rows in 1 pages for object 'SY00801'.
DBCC results for 'SY07210'.
There are 631 rows in 5 pages for object 'SY07210'.
DBCC results for 'W200002'.
There are 0 rows in 0 pages for object 'W200002'.
DBCC results for 'SY01301'.
There are 0 rows in 1 pages for object 'SY01301'.
DBCC results for 'SY07200'.
There are 43 rows in 1 pages for object 'SY07200'.
DBCC results for 'SY01400'.
There are 8 rows in 1 pages for object 'SY01400'.
DBCC results for 'SY07125'.
There are 315 rows in 2 pages for object 'SY07125'.
DBCC results for 'duLCK'.
There are 1 rows in 1 pages for object 'duLCK'.
DBCC results for 'SY07121'.
There are 90 rows in 2 pages for object 'SY07121'.
DBCC results for 'SY01402'.
There are 143 rows in 7 pages for object 'SY01402'.
DBCC results for 'SY07101'.
There are 0 rows in 0 pages for object 'SY07101'.
DBCC results for 'CHG_ACT1'.
There are 0 rows in 0 pages for object 'CHG_ACT1'.
DBCC results for 'SY07105'.
There are 0 rows in 0 pages for object 'SY07105'.
DBCC results for 'CHG_ACT2'.
There are 0 rows in 0 pages for object 'CHG_ACT2'.
DBCC results for 'CHG_ACT3'.
There are 0 rows in 0 pages for object 'CHG_ACT3'.
DBCC results for 'ASIEXP95'.
There are 1 rows in 1 pages for object 'ASIEXP95'.
DBCC results for 'CHG_ACT4'.
There are 0 rows in 0 pages for object 'CHG_ACT4'.
DBCC results for 'CHG_ACT5'.
There are 0 rows in 0 pages for object 'CHG_ACT5'.
DBCC results for 'SY07130'.
There are 81 rows in 1 pages for object 'SY07130'.
DBCC results for 'WDC41400'.
There are 0 rows in 0 pages for object 'WDC41400'.
DBCC results for 'CHG_PROD'.
There are 49 rows in 1 pages for object 'CHG_PROD'.
DBCC results for 'SY01450'.
There are 0 rows in 0 pages for object 'SY01450'.
DBCC results for 'ASIEXP60'.
There are 275 rows in 3 pages for object 'ASIEXP60'.
DBCC results for 'SY01700'.
There are 41639 rows in 1602 pages for object 'SY01700'.
DBCC results for 'W200005'.
There are 0 rows in 0 pages for object 'W200005'.
DBCC results for 'SY08000'.
There are 8 rows in 1 pages for object 'SY08000'.
DBCC results for 'POA40001'.
There are 5 rows in 1 pages for object 'POA40001'.
DBCC results for 'SY01900'.
There are 0 rows in 0 pages for object 'SY01900'.
DBCC results for 'SY08100'.
There are 40 rows in 2 pages for object 'SY08100'.
DBCC results for 'POA40002'.
There are 0 rows in 0 pages for object 'POA40002'.
DBCC results for 'SY01990'.
There are 51 rows in 11 pages for object 'SY01990'.
DBCC results for 'SY08120'.
There are 32 rows in 2 pages for object 'SY08120'.
DBCC results for 'EBSKEYS'.
There are 0 rows in 0 pages for object 'EBSKEYS'.
DBCC results for 'SY02000'.
There are 4975 rows in 33 pages for object 'SY02000'.
DBCC results for 'SY08130'.
There are 43 rows in 2 pages for object 'SY08130'.
DBCC results for 'ECM00201'.
There are 0 rows in 0 pages for object 'ECM00201'.
DBCC results for 'SY02100'.
There are 48 rows in 4 pages for object 'SY02100'.
DBCC results for 'SY08140'.
There are 58 rows in 6 pages for object 'SY08140'.
DBCC results for 'ECM10001'.
There are 0 rows in 0 pages for object 'ECM10001'.
DBCC results for 'W200006'.
There are 0 rows in 0 pages for object 'W200006'.
DBCC results for 'SY02400'.
There are 1 rows in 1 pages for object 'SY02400'.
DBCC results for 'SY40600'.
There are 194 rows in 13 pages for object 'SY40600'.
DBCC results for 'ASIEXP98'.
There are 440 rows in 5 pages for object 'ASIEXP98'.
DBCC results for 'SY02600'.
There are 0 rows in 0 pages for object 'SY02600'.
DBCC results for 'ECM10005'.
There are 0 rows in 0 pages for object 'ECM10005'.
DBCC results for 'SY40601'.
There are 0 rows in 0 pages for object 'SY40601'.
DBCC results for 'ECM10110'.
There are 0 rows in 0 pages for object 'ECM10110'.
DBCC results for 'SY02700'.
There are 63 rows in 9 pages for object 'SY02700'.
DBCC results for 'STN41250'.
There are 1 rows in 1 pages for object 'STN41250'.
DBCC results for 'ECM40001'.
There are 0 rows in 0 pages for object 'ECM40001'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 
'DYNAMICS'.
DBCC execution completed. If DBCC printed error messages, contact your 
system administrator.
DBCC results for 'current database'.
DBCC execution completed. If DBCC printed error messages, contact your 
system administrator. 
0
Reply Utf 1/20/2010 9:47:03 PM

Hi Biren,

This is just detailing how many rows each table has and data pages allocated 
to store these rows.

"CHECKDB found 0 allocation errors and 0 consistency errors in database 
'DYNAMICS'."

The report looks good, proceed on the next step.

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

"biren" <biren@discussions.microsoft.com> wrote in message 
news:5D0C2D5D-32FE-40CC-A055-B8F708EF187A@microsoft.com...
> Hi,
>
> I am testing a MS Dynamics 9 to 10 upgrade. According to the Upgrade
> Instructions release 10 (pg 25), I need to run [for database maintenance]
>
> DBCC CHECKDB
> DBCC CHECKCATALOG
>
> against the DYNAMICS database and company databases.
>
> When I run it against the DYNAMICS database, I get the following error:
>
>
> DBCC results for 'DYNAMICS'.
> DBCC results for 'sysobjects'.
> There are 1718 rows in 23 pages for object 'sysobjects'.
> DBCC results for 'sysindexes'.
> There are 662 rows in 37 pages for object 'sysindexes'.
> DBCC results for 'syscolumns'.
> There are 10141 rows in 199 pages for object 'syscolumns'.
> DBCC results for 'systypes'.
> There are 26 rows in 1 pages for object 'systypes'.
> DBCC results for 'syscomments'.
> There are 1559 rows in 461 pages for object 'syscomments'.
> DBCC results for 'sysfiles1'.
> There are 2 rows in 1 pages for object 'sysfiles1'.
> DBCC results for 'syspermissions'.
> There are 1498 rows in 6 pages for object 'syspermissions'.
> DBCC results for 'sysusers'.
> There are 21 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 15145 rows in 86 pages for object 'sysdepends'.
> DBCC results for 'sysreferences'.
> There are 2 rows in 1 pages for object 'sysreferences'.
> DBCC results for 'sysfulltextcatalogs'.
> There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
> DBCC results for 'sysfulltextnotify'.
> There are 0 rows in 0 pages for object 'sysfulltextnotify'.
> DBCC results for 'sysfilegroups'.
> There are 1 rows in 1 pages for object 'sysfilegroups'.
> DBCC results for 'SY70700'.
> There are 13 rows in 1 pages for object 'SY70700'.
> DBCC results for 'WDC41500'.
> There are 0 rows in 0 pages for object 'WDC41500'.
> DBCC results for 'SY03003'.
> There are 0 rows in 0 pages for object 'SY03003'.
> DBCC results for 'SYUPDATE'.
> There are 0 rows in 0 pages for object 'SYUPDATE'.
> DBCC results for 'SY03500'.
> There are 1 rows in 1 pages for object 'SY03500'.
> DBCC results for 'WDC51102'.
> There are 145 rows in 1 pages for object 'WDC51102'.
> DBCC results for 'SY03600'.
> There are 0 rows in 0 pages for object 'SY03600'.
> DBCC results for 'SY03700'.
> There are 0 rows in 1 pages for object 'SY03700'.
> DBCC results for 'SY01600'.
> There are 78 rows in 4 pages for object 'SY01600'.
> DBCC results for 'SY04000'.
> There are 0 rows in 0 pages for object 'SY04000'.
> DBCC results for 'STN41300'.
> There are 1 rows in 1 pages for object 'STN41300'.
> DBCC results for 'SY04300'.
> There are 1 rows in 1 pages for object 'SY04300'.
> DBCC results for 'SY04400'.
> There are 0 rows in 0 pages for object 'SY04400'.
> DBCC results for 'ACTIVITY'.
> There are 0 rows in 1 pages for object 'ACTIVITY'.
> DBCC results for 'ALERT3RD'.
> There are 0 rows in 0 pages for object 'ALERT3RD'.
> DBCC results for 'SY04701'.
> There are 0 rows in 0 pages for object 'SY04701'.
> DBCC results for 'CONSTANTS'.
> There are 6762 rows in 521 pages for object 'CONSTANTS'.
> DBCC results for 'SY04702'.
> There are 0 rows in 0 pages for object 'SY04702'.
> DBCC results for 'DBVERSION'.
> There are 0 rows in 0 pages for object 'DBVERSION'.
> DBCC results for 'DEFLTCOA'.
> There are 1761 rows in 29 pages for object 'DEFLTCOA'.
> DBCC results for 'SY04703'.
> There are 0 rows in 0 pages for object 'SY04703'.
> DBCC results for 'LKACTVTY'.
> There are 0 rows in 0 pages for object 'LKACTVTY'.
> DBCC results for 'dtproperties'.
> There are 0 rows in 0 pages for object 'dtproperties'.
> DBCC results for 'SY04704'.
> There are 0 rows in 0 pages for object 'SY04704'.
> DBCC results for 'frl_ofsi_data'.
> There are 1 rows in 1 pages for object 'frl_ofsi_data'.
> DBCC results for 'SY05000'.
> There are 0 rows in 0 pages for object 'SY05000'.
> DBCC results for 'ASIEXP86'.
> There are 1344 rows in 51 pages for object 'ASIEXP86'.
> DBCC results for 'SY05100'.
> There are 1212 rows in 3 pages for object 'SY05100'.
> DBCC results for 'ASIEXP81'.
> There are 199 rows in 40 pages for object 'ASIEXP81'.
> DBCC results for 'SY01500'.
> There are 5 rows in 1 pages for object 'SY01500'.
> DBCC results for 'GPS_SQL_Error_Codes'.
> There are 1016 rows in 40 pages for object 'GPS_SQL_Error_Codes'.
> DBCC results for 'SY05400'.
> There are 0 rows in 0 pages for object 'SY05400'.
> DBCC results for 'IC40100'.
> There are 0 rows in 0 pages for object 'IC40100'.
> DBCC results for 'SY05501'.
> There are 0 rows in 0 pages for object 'SY05501'.
> DBCC results for 'ASIEXP50'.
> There are 0 rows in 0 pages for object 'ASIEXP50'.
> DBCC results for 'SY40200'.
> There are 0 rows in 0 pages for object 'SY40200'.
> DBCC results for 'SY40300'.
> There are 0 rows in 1 pages for object 'SY40300'.
> DBCC results for 'MC00100'.
> There are 102 rows in 2 pages for object 'MC00100'.
> DBCC results for 'SY40400'.
> There are 0 rows in 1 pages for object 'SY40400'.
> DBCC results for 'MC40200'.
> There are 10 rows in 1 pages for object 'MC40200'.
> DBCC results for 'SY40500'.
> There are 55 rows in 6 pages for object 'SY40500'.
> DBCC results for 'MC40300'.
> There are 17 rows in 1 pages for object 'MC40300'.
> DBCC results for 'ASIEXP51'.
> There are 0 rows in 0 pages for object 'ASIEXP51'.
> DBCC results for 'SY60100'.
> There are 24 rows in 1 pages for object 'SY60100'.
> DBCC results for 'MC40400'.
> There are 0 rows in 0 pages for object 'MC40400'.
> DBCC results for 'WDC51100'.
> There are 44 rows in 1 pages for object 'WDC51100'.
> DBCC results for 'MC40401'.
> There are 0 rows in 0 pages for object 'MC40401'.
> DBCC results for 'MC60100'.
> There are 10 rows in 1 pages for object 'MC60100'.
> DBCC results for 'SY40501'.
> There are 442 rows in 10 pages for object 'SY40501'.
> DBCC results for 'MC60200'.
> There are 17 rows in 1 pages for object 'MC60200'.
> DBCC results for 'SY40502'.
> There are 115 rows in 2 pages for object 'SY40502'.
> DBCC results for 'WDC41300'.
> There are 0 rows in 0 pages for object 'WDC41300'.
> DBCC results for 'MESSAGES'.
> There are 23923 rows in 825 pages for object 'MESSAGES'.
> DBCC results for 'SY40503'.
> There are 375 rows in 8 pages for object 'SY40503'.
> DBCC results for 'ORG00100'.
> There are 0 rows in 0 pages for object 'ORG00100'.
> DBCC results for 'SY40504'.
> There are 235 rows in 9 pages for object 'SY40504'.
> DBCC results for 'ASITAB20'.
> There are 6838 rows in 855 pages for object 'ASITAB20'.
> DBCC results for 'ORG40000'.
> There are 0 rows in 0 pages for object 'ORG40000'.
> DBCC results for 'SY40505'.
> There are 0 rows in 0 pages for object 'SY40505'.
> DBCC results for 'SY40506'.
> There are 0 rows in 0 pages for object 'SY40506'.
> DBCC results for 'ORG40100'.
> There are 0 rows in 0 pages for object 'ORG40100'.
> DBCC results for 'PATH'.
> There are 0 rows in 0 pages for object 'PATH'.
> DBCC results for 'WDC51101'.
> There are 146897 rows in 1099 pages for object 'WDC51101'.
> DBCC results for 'STN41100'.
> There are 2 rows in 1 pages for object 'STN41100'.
> DBCC results for 'DB_Upgrade'.
> There are 84 rows in 1 pages for object 'DB_Upgrade'.
> DBCC results for 'SY80000'.
> There are 0 rows in 0 pages for object 'SY80000'.
> DBCC results for 'ASITAB30'.
> There are 32 rows in 1 pages for object 'ASITAB30'.
> DBCC results for 'DU000010'.
> There are 236 rows in 11 pages for object 'DU000010'.
> DBCC results for 'STN41200'.
> There are 223 rows in 3 pages for object 'STN41200'.
> DBCC results for 'UPR10300'.
> There are 0 rows in 0 pages for object 'UPR10300'.
> DBCC results for 'SY90100'.
> There are 0 rows in 0 pages for object 'SY90100'.
> DBCC results for 'UPR10304'.
> There are 0 rows in 0 pages for object 'UPR10304'.
> DBCC results for 'UPR41105'.
> There are 262 rows in 2 pages for object 'UPR41105'.
> DBCC results for 'CHG_RG01'.
> There are 1 rows in 1 pages for object 'CHG_RG01'.
> DBCC results for 'UPR41300'.
> There are 0 rows in 0 pages for object 'UPR41300'.
> DBCC results for 'ASIEXP83'.
> There are 58 rows in 2 pages for object 'ASIEXP83'.
> DBCC results for 'UPR41301'.
> There are 0 rows in 0 pages for object 'UPR41301'.
> DBCC results for 'SY05300'.
> There are 358 rows in 6 pages for object 'SY05300'.
> DBCC results for 'STN41350'.
> There are 0 rows in 0 pages for object 'STN41350'.
> DBCC results for 'UPR41302'.
> There are 0 rows in 0 pages for object 'UPR41302'.
> DBCC results for 'SY07110'.
> There are 822 rows in 5 pages for object 'SY07110'.
> DBCC results for 'SY_SQL_Options'.
> There are 1 rows in 1 pages for object 'SY_SQL_Options'.
> DBCC results for 'UPR41303'.
> There are 0 rows in 0 pages for object 'UPR41303'.
> DBCC results for 'SY003001'.
> There are 1 rows in 1 pages for object 'SY003001'.
> DBCC results for 'DU000020'.
> There are 73 rows in 3 pages for object 'DU000020'.
> DBCC results for 'WDC41101'.
> There are 1 rows in 1 pages for object 'WDC41101'.
> DBCC results for 'SY00302'.
> There are 5 rows in 1 pages for object 'SY00302'.
> DBCC results for 'DU000030'.
> There are 442 rows in 16 pages for object 'DU000030'.
> DBCC results for 'UPR41600'.
> There are 4 rows in 1 pages for object 'UPR41600'.
> DBCC results for 'SY01403'.
> There are 10 rows in 3 pages for object 'SY01403'.
> DBCC results for 'SY00800'.
> There are 1 rows in 1 pages for object 'SY00800'.
> DBCC results for 'SY01404'.
> There are 53 rows in 3 pages for object 'SY01404'.
> DBCC results for 'W200001'.
> There are 0 rows in 0 pages for object 'W200001'.
> DBCC results for 'SY00801'.
> There are 0 rows in 1 pages for object 'SY00801'.
> DBCC results for 'SY07210'.
> There are 631 rows in 5 pages for object 'SY07210'.
> DBCC results for 'W200002'.
> There are 0 rows in 0 pages for object 'W200002'.
> DBCC results for 'SY01301'.
> There are 0 rows in 1 pages for object 'SY01301'.
> DBCC results for 'SY07200'.
> There are 43 rows in 1 pages for object 'SY07200'.
> DBCC results for 'SY01400'.
> There are 8 rows in 1 pages for object 'SY01400'.
> DBCC results for 'SY07125'.
> There are 315 rows in 2 pages for object 'SY07125'.
> DBCC results for 'duLCK'.
> There are 1 rows in 1 pages for object 'duLCK'.
> DBCC results for 'SY07121'.
> There are 90 rows in 2 pages for object 'SY07121'.
> DBCC results for 'SY01402'.
> There are 143 rows in 7 pages for object 'SY01402'.
> DBCC results for 'SY07101'.
> There are 0 rows in 0 pages for object 'SY07101'.
> DBCC results for 'CHG_ACT1'.
> There are 0 rows in 0 pages for object 'CHG_ACT1'.
> DBCC results for 'SY07105'.
> There are 0 rows in 0 pages for object 'SY07105'.
> DBCC results for 'CHG_ACT2'.
> There are 0 rows in 0 pages for object 'CHG_ACT2'.
> DBCC results for 'CHG_ACT3'.
> There are 0 rows in 0 pages for object 'CHG_ACT3'.
> DBCC results for 'ASIEXP95'.
> There are 1 rows in 1 pages for object 'ASIEXP95'.
> DBCC results for 'CHG_ACT4'.
> There are 0 rows in 0 pages for object 'CHG_ACT4'.
> DBCC results for 'CHG_ACT5'.
> There are 0 rows in 0 pages for object 'CHG_ACT5'.
> DBCC results for 'SY07130'.
> There are 81 rows in 1 pages for object 'SY07130'.
> DBCC results for 'WDC41400'.
> There are 0 rows in 0 pages for object 'WDC41400'.
> DBCC results for 'CHG_PROD'.
> There are 49 rows in 1 pages for object 'CHG_PROD'.
> DBCC results for 'SY01450'.
> There are 0 rows in 0 pages for object 'SY01450'.
> DBCC results for 'ASIEXP60'.
> There are 275 rows in 3 pages for object 'ASIEXP60'.
> DBCC results for 'SY01700'.
> There are 41639 rows in 1602 pages for object 'SY01700'.
> DBCC results for 'W200005'.
> There are 0 rows in 0 pages for object 'W200005'.
> DBCC results for 'SY08000'.
> There are 8 rows in 1 pages for object 'SY08000'.
> DBCC results for 'POA40001'.
> There are 5 rows in 1 pages for object 'POA40001'.
> DBCC results for 'SY01900'.
> There are 0 rows in 0 pages for object 'SY01900'.
> DBCC results for 'SY08100'.
> There are 40 rows in 2 pages for object 'SY08100'.
> DBCC results for 'POA40002'.
> There are 0 rows in 0 pages for object 'POA40002'.
> DBCC results for 'SY01990'.
> There are 51 rows in 11 pages for object 'SY01990'.
> DBCC results for 'SY08120'.
> There are 32 rows in 2 pages for object 'SY08120'.
> DBCC results for 'EBSKEYS'.
> There are 0 rows in 0 pages for object 'EBSKEYS'.
> DBCC results for 'SY02000'.
> There are 4975 rows in 33 pages for object 'SY02000'.
> DBCC results for 'SY08130'.
> There are 43 rows in 2 pages for object 'SY08130'.
> DBCC results for 'ECM00201'.
> There are 0 rows in 0 pages for object 'ECM00201'.
> DBCC results for 'SY02100'.
> There are 48 rows in 4 pages for object 'SY02100'.
> DBCC results for 'SY08140'.
> There are 58 rows in 6 pages for object 'SY08140'.
> DBCC results for 'ECM10001'.
> There are 0 rows in 0 pages for object 'ECM10001'.
> DBCC results for 'W200006'.
> There are 0 rows in 0 pages for object 'W200006'.
> DBCC results for 'SY02400'.
> There are 1 rows in 1 pages for object 'SY02400'.
> DBCC results for 'SY40600'.
> There are 194 rows in 13 pages for object 'SY40600'.
> DBCC results for 'ASIEXP98'.
> There are 440 rows in 5 pages for object 'ASIEXP98'.
> DBCC results for 'SY02600'.
> There are 0 rows in 0 pages for object 'SY02600'.
> DBCC results for 'ECM10005'.
> There are 0 rows in 0 pages for object 'ECM10005'.
> DBCC results for 'SY40601'.
> There are 0 rows in 0 pages for object 'SY40601'.
> DBCC results for 'ECM10110'.
> There are 0 rows in 0 pages for object 'ECM10110'.
> DBCC results for 'SY02700'.
> There are 63 rows in 9 pages for object 'SY02700'.
> DBCC results for 'STN41250'.
> There are 1 rows in 1 pages for object 'STN41250'.
> DBCC results for 'ECM40001'.
> There are 0 rows in 0 pages for object 'ECM40001'.
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'DYNAMICS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> DBCC results for 'current database'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator. 

0
Reply Dencio 1/20/2010 11:47:18 PM


1 Replies
405 Views

(page loaded in 4.865 seconds)

Similiar Articles:
















7/24/2012 3:55:23 PM


Reply: