SQLServerCentral / SQL Server 2005 / Data Corruption

Database Recovery from Log File Only

Todd Williams-416222 — Wed, 04 Nov 2009 16:45:11 GMT

Is it possible to recover an SQL2005 data from the log file alone?Thank you

Recover from disk crash

pkemp — Thu, 22 Oct 2009 03:19:27 GMT

Hi FolksToday has been a fun day with our SAN partially crashing and I'm looking for a few suggestions on what my next steps should be after it's recovered.Effectively what has happened is the drive/s on our SQL server where the data files reside became disconnected while the server was running. Log files were still available on a separate drive. After the disk crash some users were still processing transactions apparently but I can't verify this. I could certainly query some parts of the database but I'm assuming the buffer cache was fulfilling these queries and most queries usually resulted in error. Thankfully my log shipping was working a treat and my backup server is up to date with the last log shipped should I need it.What have I done so far:1. Disconnected all users2. Backed up the transaction log of the affected databases to potentially roll forward to my backup server or recover the production box.3. Shutdown the SQL server while SAN repairs are in progress.What likely problems will I see and how should I treat them. I'm planning on running a CHECKDB to see if any problems exist.Any ideas would be appreciated.Thanks

hard disk crash

goriporvalona — Fri, 30 Oct 2009 12:34:23 GMT

Hello You do not have to remove the 2nd HD if it is working.You need only to replace the non working HD.The question is which HD broke?? the C drive where XP was installed or theother HD.??If it was the C drive that had XP on it and you replaced it with a new onethen you would need to reinstall XP onto that drive but do leave the otherdrive connected.When you hook up your new drive make sure you set thejumpers on the back of the drive to master.Leave the 2nd drive connectedduring the XP installation so that it can read the programs on that driveand enter the correct parameters in the registry and rebuild the shortcutsto start the programs. [url=http://www.plantesjardinsnature.com/16]Produit jardinage[/url]

Error 823: I/O error (torn page)

dominicgurat — Wed, 04 Nov 2009 02:13:49 GMT

Hi, can anyone help me on this? It all started when we had a power shortage. Eventually my server shutdown. Then I restarted it. I noticed that my database was already marked suspect. Then I tried to detach then attach the database in the hope that it will regain its normal state. However I could not attach it anymore and it shows Error 823: I/O error (torn page). Please advice me on this.

Disk space eats up rapidly when I execute a insert statement

pink.thereisnoif — Wed, 04 Nov 2009 05:36:48 GMT

Hi All,We have a database named 'Track' running on a 64 bit Sql Server 2005 enterprise edition.Currently the Track DB occupies about 100G space, with 77G data, 16G index, mainly on Primary filegroup.The primary filegroup has one data file, with autogrowth enabled at 100M with no limit size. The log file is also autogrowth.When I execute a 'select * into ' query, the disk space is been eaten up rapidly, mainly the mdf file.It dosen't complete after 30 minutes, so I have to stop the query.Now the mdf file is 160G, increased about 60G.The result of 'sp_spaceused' shows:database_name | database_size | unallocated_spaceTrack | 163649.94MB | 70518.09MBreserved | data | index_size | unused94258216KB | 77720304KB | 16200240KB | 337672KBNow I have to shrink the the database data file to free the occupied space.What's the problem?

SQL Server detected a logical consistency-based I/O error

venkuforever — Mon, 02 Nov 2009 23:01:49 GMT

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x15555555). It occurred during a read of page (1:671644) in database ID 14 at offset 0x00000147f38000 in file 'E:\Database\ProductionRep_Data.MDF'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.Help me.

SOLUTION OF THE ERROR

sakthivel.jeevan — Thu, 29 Oct 2009 23:09:38 GMT

Attempt to fetch logical page (1:110552) in database 10 failed. It belongs to allocation unit 4432555802624 not to 412557876723712. I have the above error and also i find the error this is index corruption error. I deleted the index and then re-create the index after that i got same error so what can i do give m e solution please,,,,

SQL corruption...best way to bcp out then in

nickbrennan — Thu, 15 Oct 2009 18:51:26 GMT

Hey guys...new here 1st post. I wanted to know if I run a dbcc checkdb and I find corruption, what is the best way (steps if you would be so kind) to remove the corruption?

Row Order is not getting preserved

Vivek Sharan — Thu, 29 Oct 2009 09:09:46 GMT

When writing a sql table data to a flat file using the SSIS control flow, sometimes the Row Order is not preserved. The SQL table datasource has the record count as the last row. When dumping this table to a file, sometimes the record count appears in the middle of the file which basically renders the file incorrect.This happens randomly and often is the case when the file is large. Is there a way to preserve the row order?Thank you all

Backup detected log corruption in database

DBN — Thu, 11 Jun 2009 08:51:35 GMT

I there!I am trying to reduce my log file and I used the following steps:[code]USE supliesGOCHECKPOINTGOBACKUP LOG suplies TO DISK = 'D:\backup_log.log'GO DBCC SHRINKFILE (suplies_log, 1);Go[/code]But SQL Server is returning the following error:[code]2009-06-11 15:11:47.93 spid63 Backup detected log corruption in database suplies. Context is FirstSector. LogFile: 2 'C:\MSSQL.1\MSSQL\Data\suplies_log.ldf' VLF SeqNo: x2c77c6 VLFBase: x157b9a000 LogBlockOffset: x157bd1e00 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x0 LogBlock.StartLsn.Blk: x0 Size: x0 PrevSize: x02009-06-11 15:11:47.98 Backup Error: 3041, Severity: 16, State: 1.[/code]I always used this procedure to reduce the log file's size but now I'm getting this error. I'm working on a production server so any solutions provided should be carefully applied.Thanks in advance

Bit by the SQL Autogrow bug

Ed-86789 — Thu, 01 Oct 2009 08:33:11 GMT

Hi,I just had one of our production databases autogrow from 300GB to over 1TB, nearly filling up the drive. It was supposed to autogrow 200MB which is represented as 25600 in the system tables. However, the value was changed to 25600%. After some Google time I have come to find that this is a known SQL Bug. There also seems to be some question about whether it has really been fixed in SP2.Two questions:a) Has the issue really been fixed? This server is at build 9.0.3073 b) What approach should I use to get this db file back to a reasonable size? I tried dbcc shrinkfile. After a couple of hours it had no effect - I killed it. I've seen posts that suggest that shrinkfile will work but to only shrink in very small increments like may 5GB at a time. I believe others have suggested moving all the objects into another file. Thanks

SQL 2008 Returning Data Type 6 (currency code) for Stored Procedure Parm on ADO Call to DB

Arnold Gladson — Mon, 26 Oct 2009 08:19:22 GMT

SQL 2008 Enterprise edition is not returning a valid data type code when being called from VB6 com object. We are setting up an ADO command object in VB6.0 (using MDAC 2.8, SP 2), setting it up with a Stored Procedure name in the Command.text and then issuing a command.refresh to get the parm values. My SP Has nvarchar(20) string values and the .REFRESH returns a type 6 code saying it is a currency field. Then when I try to assign my string value, my transaction blows up. Has anyone experienced this and found a way to make this call work! Arnold

Null char in a ntext field

polzyk — Mon, 05 Oct 2009 10:06:14 GMT

Hi guys,I was trying to find an answer on my question all over the internet, but may be I was googl skills for SQl server not as good.I have a Sql server 2005 database that has a field of ntext type..Some records contain a null char at the end of a string..1. How can I select these records that contain null char in a field? I've tried different approaches including PATIndex('%\0%') and replace ('\0', '') nothing actually worked for me2. How can I strip out null char from the NTEXT field and save it back to the same field...Basicly I want to clean up my database.Any sugestions?Thank you Alek

DBCC Errors

Bluesky-539179 — Thu, 17 Sep 2009 11:31:04 GMT

Hi Here is one of the Production DB's which has 16 consistency errors when I run DBCC Checkdb. Can anybody suggest me what to do ? Will this error be resolved if I opt for DBCC Checkdb with REPAIR_REBUILD option ?Error : DBCC results for 'subcontent'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 2014630220, index ID 0: Page (1:309989) could not be processed. See other errors for details.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 2014630220, index ID 0, page ID (1:309990). The PageId in the page header = (1:309998).Server: Msg 8928, Level 16, State 1, Line 1Object ID 2014630220, index ID 0: Page (1:309990) could not be processed. See other errors for details.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 2014630220, index ID 0, page ID (1:309991). The PageId in the page header = (1:309999).Server: Msg 8928, Level 16, State 1, Line 1Object ID 2014630220, index ID 0: Page (1:309991) could not be processed. See other errors for details.There are 660233 rows in 15708 pages for object 'subcontent'.CHECKDB found 0 allocation errors and 16 consistency errors in table 'subcontent' (object ID 2014630220).CHECKDB found 0 allocation errors and 16 consistency errors in database 'docbase'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB ('docbase' ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.

5 consistency errors in table 'sys.syscolpars'

COOL_ICE — Wed, 30 Sep 2009 05:33:36 GMT

DBCC results for 'Test sks'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.DBCC results for 'sys.sysrowsetcolumns'.There are 44477 rows in 408 pages for object "sys.sysrowsetcolumns".DBCC results for 'sys.sysrowsets'.There are 2157 rows in 25 pages for object "sys.sysrowsets".DBCC results for 'sysallocunits'.There are 2794 rows in 47 pages for object "sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syshobtcolumns'.There are 44477 rows in 421 pages for object "sys.syshobtcolumns".DBCC results for 'sys.syshobts'.There are 2157 rows in 25 pages for object "sys.syshobts".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysserefs'.There are 2794 rows in 24 pages for object "sys.sysserefs".DBCC results for 'sys.sysowners'.There are 15 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 121 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 9580 rows in 185 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.Msg 8928, Level 16, State 1, Line 1Object ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 72057594042515456 (type In-row data): Page (1:1564) could not be processed. See other errors for details.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 72057594042515456 (type In-row data). Page (1:1564) was not seen in the scan although its parent (1:49361) and previous (1:2033) refer to it. Check any previous errors.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 72057594042515456 (type In-row data), page (1:1564), row 9. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3866 and 32.Msg 8944, Level 16, State 13, Line 1Table error: Object ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 72057594042515456 (type In-row data), page (1:1564), row 9. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3866 and 32.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 72057594042515456 (type In-row data). Page (1:2165) is missing a reference from previous page (1:1564). Possible chain linkage problem.There are 42857 rows in 1073 pages for object "sys.syscolpars".CHECKDB found 0 allocation errors and 5 consistency errors in table 'sys.syscolpars' (object ID 41).DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysxprops'.There are 3 rows in 2 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 27 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 3854 rows in 106 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 5620 rows in 44 pages for object "sys.sysiscols".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysobjvalues'.There are 11111 rows in 1101 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 15 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 134 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 1054 rows in 8 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysdbfiles'.There are 2 rows in 1 pages for object "sys.sysdbfiles".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.sysqnames'.There are 91 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 93 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 97 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 17 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 0 rows in 0 pages for object "sys.sysbinsubobjs".DBCC results for 'RPD9'.There are 0 rows in 0 pages for object "RPD9".DBCC results for '@CXS_TDS_PTYPE'.There are 5 rows in 1 pages for object "@CXS_TDS_PTYPE".DBCC results for 'OPYB'.There are 0 rows in 0 pages for object "OPYB".DBCC results for 'VTR2'.There are 0 rows in 0 pages for object "VTR2".DBCC results for 'DPI3'.There are 0 rows in 0 pages for object "DPI3".DBCC results for 'TPS1'.There are 1 rows in 1 pages for object "TPS1".DBCC results for 'OSPG'.There are 0 rows in 0 pages for object "OSPG".DBCC results for 'DPO2'.There are 0 rows in 0 pages for object "DPO2".DBCC results for 'PDN1'.There are 5493 rows in 1099 pages for object "PDN1".DBCC results for 'OMTH'.There are 1 rows in 1 pages for object "OMTH".DBCC results for 'ABOE'.There are 0 rows in 0 pages for object "ABOE".DBCC results for 'OIPF'.There are 0 rows in 0 pages for object "OIPF".DBCC results for '@MACM'.There are 0 rows in 0 pages for object "@MACM".DBCC results for 'OCLT'.There are 2 rows in 1 pages for object "OCLT".DBCC results for 'CRD7'.There are 4417 rows in 39 pages for object "CRD7".DBCC results for '@BIZ_WHSTPC'.There are 0 rows in 0 pages for object "@BIZ_WHSTPC".DBCC results for '@BIZ_LENCASH'.There are 0 rows in 0 pages for object "@BIZ_LENCASH".DBCC results for 'OPYD'.There are 0 rows in 0 pages for object "OPYD".DBCC results for '@AOEPCG'.There are 0 rows in 0 pages for object "@AOEPCG".DBCC results for 'OWHS'.There are 15 rows in 1 pages for object "OWHS".DBCC results for 'IGN10'.There are 0 rows in 0 pages for object "IGN10".DBCC results for 'OADMDATA'.There are 1 rows in 1 pages for object "OADMDATA".DBCC results for 'RPC2'.There are 0 rows in 0 pages for object "RPC2".DBCC results for 'DLN5'.There are 0 rows in 0 pages for object "DLN5".DBCC results for 'VTR3'.There are 0 rows in 0 pages for object "VTR3".DBCC results for 'RDN4'.There are 0 rows in 0 pages for object "RDN4".DBCC results for '@MACM1'.There are 0 rows in 0 pages for object "@MACM1".DBCC results for '@ABALE'.There are 0 rows in 0 pages for object "@ABALE".DBCC results for 'TPS2'.There are 2 rows in 1 pages for object "TPS2".DBCC results for '@BIZ_WHSTPM'.There are 0 rows in 0 pages for object "@BIZ_WHSTPM".DBCC results for 'OSPP'.There are 0 rows in 0 pages for object "OSPP".DBCC results for 'DSC1'.There are 5 rows in 1 pages for object "DSC1".DBCC results for 'CPI6'.There are 0 rows in 0 pages for object "CPI6".DBCC results for 'RIN1'.There are 6 rows in 2 pages for object "RIN1".DBCC results for 'OCMT'.There are 0 rows in 0 pages for object "OCMT".DBCC results for 'CSHS'.There are 333 rows in 5 pages for object "CSHS".DBCC results for 'OBOT'.There are 0 rows in 0 pages for object "OBOT".DBCC results for 'RTM1'.There are 0 rows in 0 pages for object "RTM1".DBCC results for 'NNM2'.There are 7 rows in 1 pages for object "NNM2".DBCC results for 'OCTT'.There are 0 rows in 0 pages for object "OCTT".DBCC results for 'WDD1'.There are 357 rows in 3 pages for object "WDD1".DBCC results for 'TPW1'.There are 0 rows in 0 pages for object "TPW1".DBCC results for '@BIZ_LEVCD'.There are 0 rows in 0 pages for object "@BIZ_LEVCD".DBCC results for 'OPYM'.There are 0 rows in 0 pages for object "OPYM".DBCC results for 'RDR6'.There are 2877 rows in 180 pages for object "RDR6".DBCC results for '@CBS_PCS'.There are 10519 rows in 150 pages for object "@CBS_PCS".DBCC results for 'IGN11'.There are 0 rows in 0 pages for object "IGN11".DBCC results for 'POR4'.There are 0 rows in 0 pages for object "POR4".DBCC results for 'ODWZ'.There are 0 rows in 0 pages for object "ODWZ".DBCC results for '@ACBS_RO1'.There are 20258 rows in 701 pages for object "@ACBS_RO1".DBCC results for '@MITM'.There are 0 rows in 0 pages for object "@MITM".DBCC results for 'TPW2'.There are 0 rows in 0 pages for object "TPW2".DBCC results for 'QUT6'.There are 0 rows in 0 pages for object "QUT6".DBCC results for '@BLEACHING'.There are 0 rows in 0 pages for object "@BLEACHING".DBCC results for 'OBOX'.There are 0 rows in 0 pages for object "OBOX".DBCC results for 'NNM3'.There are 82 rows in 1 pages for object "NNM3".DBCC results for 'CIN5'.There are 0 rows in 0 pages for object "CIN5".DBCC results for 'INV6'.There are 1643 rows in 103 pages for object "INV6".DBCC results for 'OMTP'.There are 3 rows in 1 pages for object "OMTP".DBCC results for 'WDD2'.There are 0 rows in 0 pages for object "WDD2".DBCC results for 'OCNA'.There are 0 rows in 0 pages for object "OCNA".DBCC results for '@ACBS_BALE'.There are 10484 rows in 122 pages for object "@ACBS_BALE".DBCC results for 'ADO6'.There are 1516 rows in 153 pages for object "ADO6".DBCC results for 'OSQR'.There are 0 rows in 0 pages for object "OSQR".DBCC results for '@AOEPCG1'.There are 0 rows in 0 pages for object "@AOEPCG1".DBCC results for 'CSV5'.There are 0 rows in 0 pages for object "CSV5".DBCC results for 'IEI4'.There are 0 rows in 0 pages for object "IEI4".DBCC results for 'TPW3'.There are 0 rows in 0 pages for object "TPW3".DBCC results for '@CBS_GE_PLAN_BULK'.There are 0 rows in 0 pages for object "@CBS_GE_PLAN_BULK".DBCC results for 'RTYP'.There are 326 rows in 4 pages for object "RTYP".DBCC results for '@BIZ_LNADV'.There are 0 rows in 0 pages for object "@BIZ_LNADV".DBCC results for 'PDF5'.There are 0 rows in 0 pages for object "PDF5".DBCC results for 'ONCM'.There are 0 rows in 0 pages for object "ONCM".DBCC results for 'ibolt_trigger'.There are 313504 rows in 12992 pages for object "ibolt_trigger".DBCC results for '@ACBS_SHFDEF'.There are 2 rows in 1 pages for object "@ACBS_SHFDEF".DBCC results for 'IGN12'.There are 0 rows in 0 pages for object "IGN12".DBCC results for 'WHT1'.There are 20 rows in 1 pages for object "WHT1".DBCC results for 'OIRT'.There are 0 rows in 0 pages for object "OIRT".DBCC results for 'OCNT'.There are 0 rows in 0 pages for object "OCNT".DBCC results for 'OUBR'.There are 1 rows in 1 pages for object "OUBR".DBCC results for 'DPO4'.There are 0 rows in 0 pages for object "DPO4".DBCC results for '@AOLUT'.There are 0 rows in 0 pages for object "@AOLUT".DBCC results for 'OWKO'.There are 0 rows in 0 pages for object "OWKO".DBCC results for '@MITM_1'.There are 0 rows in 0 pages for object "@MITM_1".DBCC results for 'CSI10'.There are 0 rows in 0 pages for object "CSI10".DBCC results for 'DUT1'.There are 0 rows in 0 pages for object "DUT1".DBCC results for 'SAL1'.There are 0 rows in 0 pages for object "SAL1".DBCC results for 'OACG'.There are 0 rows in 0 pages for object "OACG".DBCC results for 'ONFN'.There are 15 rows in 1 pages for object "ONFN".DBCC results for 'DLN6'.There are 5 rows in 1 pages for object "DLN6".DBCC results for 'ACH1'.There are 0 rows in 0 pages for object "ACH1".DBCC results for 'IGE3'.There are 0 rows in 0 pages for object "IGE3".DBCC results for 'WHT2'.There are 0 rows in 0 pages for object "WHT2".DBCC results for 'ODPO'.There are 0 rows in 0 pages for object "ODPO".DBCC results for 'ARC1'.There are 293 rows in 9 pages for object "ARC1".DBCC results for 'OUDG'.There are 0 rows in 0 pages for object "OUDG".DBCC results for 'TPW4'.There are 0 rows in 0 pages for object "TPW4".DBCC results for 'OSRD'.There are 36611 rows in 1295 pages for object "OSRD".DBCC results for 'CPI7'.There are 0 rows in 0 pages for object "CPI7".DBCC results for 'RPC4'.There are 89 rows in 4 pages for object "RPC4".DBCC results for 'PDF6'.There are 0 rows in 0 pages for object "PDF6".DBCC results for 'OISR'.There are 0 rows in 0 pages for object "OISR".DBCC results for 'OCOG'.There are 1 rows in 1 pages for object "OCOG".DBCC results for 'OBPL'.There are 0 rows in 0 pages for object "OBPL".DBCC results for '@BIZ_LNSCH'.There are 0 rows in 0 pages for object "@BIZ_LNSCH".DBCC results for 'IGN13'.There are 0 rows in 0 pages for object "IGN13".DBCC results for 'WHT3'.There are 0 rows in 0 pages for object "WHT3".DBCC results for 'TPW5'.There are 0 rows in 0 pages for object "TPW5".DBCC results for 'DWZ1'.There are 0 rows in 0 pages for object "DWZ1".DBCC results for 'RDR7'.There are 0 rows in 0 pages for object "RDR7".DBCC results for '@CBS_PO'.There are 1341 rows in 16 pages for object "@CBS_PO".DBCC results for 'RDR3'.There are 0 rows in 0 pages for object "RDR3".DBCC results for '@NOTI'.There are 0 rows in 0 pages for object "@NOTI".DBCC results for 'CSI11'.There are 0 rows in 0 pages for object "CSI11".DBCC results for 'SCL1'.There are 0 rows in 0 pages for object "SCL1".DBCC results for 'OACP'.There are 2 rows in 1 pages for object "OACP".DBCC results for 'ACHO'.There are 0 rows in 0 pages for object "ACHO".DBCC results for 'WKO1'.There are 0 rows in 0 pages for object "WKO1".DBCC results for '@ACBS_BALE1'.There are 10484 rows in 204 pages for object "@ACBS_BALE1".DBCC results for 'TPW6'.There are 0 rows in 0 pages for object "TPW6".DBCC results for 'QUT7'.There are 0 rows in 0 pages for object "QUT7".DBCC results for '@CBS_GE_PLAN_SAMPLE'.There are 0 rows in 0 pages for object "@CBS_GE_PLAN_SAMPLE".DBCC results for 'CPI8'.There are 0 rows in 0 pages for object "CPI8".DBCC results for 'OEI10'.There are 0 rows in 0 pages for object "OEI10".DBCC results for 'CIN6'.There are 0 rows in 0 pages for object "CIN6".DBCC results for 'INV7'.There are 0 rows in 0 pages for object "INV7".DBCC results for 'OIST'.There are 0 rows in 0 pages for object "OIST".DBCC results for 'CSV6'.There are 0 rows in 0 pages for object "CSV6".DBCC results for 'RDN5'.There are 0 rows in 0 pages for object "RDN5".DBCC results for '@OANX'.There are 0 rows in 0 pages for object "@OANX".DBCC results for 'OCPR'.There are 2 rows in 1 pages for object "OCPR".DBCC results for 'OBPP'.There are 0 rows in 0 pages for object "OBPP".DBCC results for 'OSRI'.There are 0 rows in 0 pages for object "OSRI".DBCC results for 'DWZ2'.There are 0 rows in 0 pages for object "DWZ2".DBCC results for 'AKL1'.There are 0 rows in 0 pages for object "AKL1".DBCC results for '@BIZ_LNTP'.There are 0 rows in 0 pages for object "@BIZ_LNTP".DBCC results for 'PDF7'.There are 0 rows in 0 pages for object "PDF7".DBCC results for '@AOLUT11'.There are 0 rows in 0 pages for object "@AOLUT11".DBCC results for 'ONFT'.There are 7 rows in 1 pages for object "ONFT".DBCC results for '@ACBS_SHIFT'.There are 4 rows in 1 pages for object "@ACBS_SHIFT".DBCC results for 'TRA1'.There are 0 rows in 0 pages for object "TRA1".DBCC results for 'ODLN'.There are 5 rows in 2 pages for object "ODLN".DBCC results for 'RDR8'.There are 0 rows in 0 pages for object "RDR8".DBCC results for 'WST1'.There are 2 rows in 1 pages for object "WST1".DBCC results for 'OITB'.There are 7 rows in 1 pages for object "OITB".DBCC results for 'ARC2'.There are 60 rows in 6 pages for object "ARC2".DBCC results for '@ACBS_DEPART'.There are 11 rows in 1 pages for object "@ACBS_DEPART".DBCC results for 'OFML'.There are 16 rows in 1 pages for object "OFML".DBCC results for 'CSI12'.There are 0 rows in 0 pages for object "CSI12".DBCC results for 'OBST'.There are 0 rows in 0 pages for object "OBST".DBCC results for 'SCL2'.There are 0 rows in 0 pages for object "SCL2".DBCC results for 'QUT8'.There are 0 rows in 0 pages for object "QUT8".DBCC results for 'CSI3'.There are 0 rows in 0 pages for object "CSI3".DBCC results for 'ALR1'.There are 0 rows in 0 pages for object "ALR1".DBCC results for 'CPI9'.There are 0 rows in 0 pages for object "CPI9".DBCC results for 'POR5'.There are 0 rows in 0 pages for object "POR5".DBCC results for 'OACT'.There are 589 rows in 54 pages for object "OACT".DBCC results for 'OEI11'.There are 0 rows in 0 pages for object "OEI11".DBCC results for 'INV8'.There are 0 rows in 0 pages for object "INV8".DBCC results for 'OOCR'.There are 0 rows in 0 pages for object "OOCR".DBCC results for 'DLN7'.There are 0 rows in 0 pages for object "DLN7".DBCC results for 'OFPR'.There are 2 rows in 1 pages for object "OFPR".DBCC results for 'OBTD'.There are 170 rows in 2 pages for object "OBTD".DBCC results for '@BIZ_LVAPP'.There are 0 rows in 0 pages for object "@BIZ_LVAPP".DBCC results for 'PDN10'.There are 0 rows in 0 pages for object "PDN10".DBCC results for 'RPC3'.There are 6 rows in 1 pages for object "RPC3".DBCC results for '@CBS_PO1'.There are 1341 rows in 42 pages for object "@CBS_PO1".DBCC results for 'OWST'.There are 2 rows in 1 pages for object "OWST".DBCC results for 'WTM1'.There are 3 rows in 1 pages for object "WTM1".DBCC results for 'TRT1'.There are 0 rows in 0 pages for object "TRT1".DBCC results for '@CBS_PCS1'.There are 19746 rows in 717 pages for object "@CBS_PCS1".DBCC results for 'ENT1'.There are 0 rows in 0 pages for object "ENT1".DBCC results for 'OQCN'.There are 38 rows in 1 pages for object "OQCN".DBCC results for '@APCS1'.There are 0 rows in 0 pages for object "@APCS1".DBCC results for 'RDR9'.There are 0 rows in 0 pages for object "RDR9".DBCC results for 'OCQG'.There are 64 rows in 1 pages for object "OCQG".DBCC results for 'IEI5'.There are 0 rows in 0 pages for object "IEI5".DBCC results for 'CSI13'.There are 0 rows in 0 pages for object "CSI13".DBCC results for '@CBS_MITM'.There are 0 rows in 0 pages for object "@CBS_MITM".DBCC results for 'OCSI'.There are 0 rows in 0 pages for object "OCSI".DBCC results for 'AAD1'.There are 52 rows in 2 pages for object "AAD1".DBCC results for '@CBS_PROCESS'.There are 6 rows in 1 pages for object "@CBS_PROCESS".DBCC results for 'IGN1'.There are 16127 rows in 3193 pages for object "IGN1".DBCC results for '@OANX12'.There are 0 rows in 0 pages for object "@OANX12".DBCC results for 'POR3'.There are 0 rows in 0 pages for object "POR3".DBCC results for 'QUT9'.There are 0 rows in 0 pages for object "QUT9".DBCC results for 'OCBI'.There are 0 rows in 0 pages for object "OCBI".DBCC results for 'OSRL'.There are 0 rows in 0 pages for object "OSRL".DBCC results for 'SCL3'.There are 0 rows in 0 pages for object "SCL3".DBCC results for 'CPI1'.There are 0 rows in 0 pages for object "CPI1".DBCC results for 'DPO5'.There are 0 rows in 0 pages for object "DPO5".DBCC results for '@APRCS'.There are 0 rows in 0 pages for object "@APRCS".DBCC results for 'INV9'.There are 0 rows in 0 pages for object "INV9".DBCC results for 'DLN8'.There are 0 rows in 0 pages for object "DLN8".DBCC results for 'OWTM'.There are 2 rows in 1 pages for object "OWTM".DBCC results for '@ACENVAT'.There are 0 rows in 0 pages for object "@ACENVAT".DBCC results for 'WTM2'.There are 2 rows in 1 pages for object "WTM2".DBCC results for 'CSV7'.There are 0 rows in 0 pages for object "CSV7".DBCC results for 'OCR1'.There are 0 rows in 0 pages for object "OCR1".DBCC results for 'TSI1'.There are 0 rows in 0 pages for object "TSI1".DBCC results for 'ALR2'.There are 1911 rows in 13 pages for object "ALR2".DBCC results for 'CPRF'.There are 104389 rows in 1320 pages for object "CPRF".DBCC results for '@BIZ_LVPR'.There are 0 rows in 0 pages for object "@BIZ_LVPR".DBCC results for 'ORPD'.There are 62 rows in 22 pages for object "ORPD".DBCC results for 'OEI12'.There are 0 rows in 0 pages for object "OEI12".DBCC results for 'CIN7'.There are 0 rows in 0 pages for object "CIN7".DBCC results for 'PDN11'.There are 0 rows in 0 pages for object "PDN11".DBCC results for 'OPDF'.There are 50 rows in 8 pages for object "OPDF".DBCC results for 'AWHS'.There are 37 rows in 3 pages for object "AWHS".DBCC results for 'RDN6'.There are 1 rows in 1 pages for object "RDN6".DBCC results for 'DPI1'.There are 0 rows in 0 pages for object "DPI1".DBCC results for 'OCCD'.There are 0 rows in 0 pages for object "OCCD".DBCC results for 'ADP1'.There are 35 rows in 1 pages for object "ADP1".DBCC results for 'OSRT'.There are 0 rows in 0 pages for object "OSRT".DBCC results for 'EOY1'.There are 0 rows in 0 pages for object "EOY1".DBCC results for 'OQUE'.There are 0 rows in 0 pages for object "OQUE".DBCC results for 'RPC5'.There are 1 rows in 1 pages for object "RPC5".DBCC results for '@APRDN'.There are 0 rows in 0 pages for object "@APRDN".DBCC results for 'OJDT'.There are 37259 rows in 1283 pages for object "OJDT".DBCC results for 'OOFR'.There are 0 rows in 0 pages for object "OOFR".DBCC results for '@ACBS_GE_PLAN_BULK'.There are 1 rows in 1 pages for object "@ACBS_GE_PLAN_BULK".DBCC results for '@CBS_OANX'.There are 0 rows in 0 pages for object "@CBS_OANX".DBCC results for '@BIZ_LVR1'.There are 0 rows in 0 pages for object "@BIZ_LVR1".DBCC results for 'POR1'.There are 0 rows in 0 pages for object "POR1".DBCC results for 'RIN10'.There are 0 rows in 0 pages for object "RIN10".DBCC results for 'IGN2'.There are 0 rows in 0 pages for object "IGN2".DBCC results for 'WTM4'.There are 0 rows in 0 pages for object "WTM4".DBCC results for '@OCT3'.There are 0 rows in 0 pages for object "@OCT3".DBCC results for 'OFRC'.There are 143 rows in 3 pages for object "OFRC".DBCC results for 'OCDC'.There are 0 rows in 0 pages for object "OCDC".DBCC results for 'OWOR'.There are 3904 rows in 236 pages for object "OWOR".DBCC results for 'FCT1'.There are 0 rows in 0 pages for object "FCT1".DBCC results for 'DLN9'.There are 0 rows in 0 pages for object "DLN9".DBCC results for '@ACT3'.There are 0 rows in 0 pages for object "@ACT3".DBCC results for 'CSV8'.There are 0 rows in 0 pages for object "CSV8".DBCC results for 'OCRB'.There are 0 rows in 0 pages for object "OCRB".DBCC results for 'QWZ1'.There are 0 rows in 0 pages for object "QWZ1".DBCC results for 'OSST'.There are 3 rows in 1 pages for object "OSST".DBCC results for 'SCL4'.There are 0 rows in 0 pages for object "SCL4".DBCC results for 'ALR3'.There are 1911 rows in 19 pages for object "ALR3".DBCC results for 'POR6'.There are 0 rows in 0 pages for object "POR6".DBCC results for '@BIZ_MTBM'.There are 0 rows in 0 pages for object "@BIZ_MTBM".DBCC results for 'OEI13'.There are 0 rows in 0 pages for object "OEI13".DBCC results for 'CIN8'.There are 0 rows in 0 pages for object "CIN8".DBCC results for 'PDN12'.There are 3325 rows in 43 pages for object "PDN12".DBCC results for 'OCPI'.There are 0 rows in 0 pages for object "OCPI".DBCC results for 'OOIN'.There are 0 rows in 0 pages for object "OOIN".DBCC results for 'ORIN'.There are 6 rows in 2 pages for object "ORIN".DBCC results for 'OWTT'.There are 0 rows in 0 pages for object "OWTT".DBCC results for 'FLT1'.There are 186 rows in 3 pages for object "FLT1".DBCC results for 'OQWZ'.There are 0 rows in 0 pages for object "OQWZ".DBCC results for '@APRINT'.There are 0 rows in 0 pages for object "@APRINT".DBCC results for 'IPF1'.There are 0 rows in 0 pages for object "IPF1".DBCC results for '@CBS_RO'.There are 1692 rows in 20 pages for object "@CBS_RO".DBCC results for 'ARC3'.There are 0 rows in 0 pages for object "ARC3".DBCC results for 'OUDP'.There are 3 rows in 1 pages for object "OUDP".DBCC results for 'TXD1'.There are 0 rows in 0 pages for object "TXD1".DBCC results for 'OSTA'.There are 31 rows in 1 pages for object "OSTA".DBCC results for 'OEI3'.There are 0 rows in 0 pages for object "OEI3".DBCC results for 'ALT1'.There are 0 rows in 0 pages for object "ALT1".DBCC results for 'RPC1'.There are 71 rows in 15 pages for object "RPC1".DBCC results for 'RIN11'.There are 0 rows in 0 pages for object "RIN11".DBCC results for 'PCH10'.There are 0 rows in 0 pages for object "PCH10".DBCC results for 'WTM5'.There are 0 rows in 0 pages for object "WTM5".DBCC results for 'IEI6'.There are 0 rows in 0 pages for object "IEI6".DBCC results for 'FML1'.There are 84 rows in 1 pages for object "FML1".DBCC results for 'ORCM'.There are 0 rows in 0 pages for object "ORCM".DBCC results for 'OOIR'.There are 0 rows in 0 pages for object "OOIR".DBCC results for 'ACR3'.There are 0 rows in 0 pages for object "ACR3".DBCC results for '@ACT31'.There are 0 rows in 0 pages for object "@ACT31".DBCC results for 'CSV9'.There are 0 rows in 0 pages for object "CSV9".DBCC results for 'OUKD'.There are 1 rows in 1 pages for object "OUKD".DBCC results for '@BIZ_MTHHD'.There are 0 rows in 0 pages for object "@BIZ_MTHHD".DBCC results for 'DPO6'.There are 0 rows in 0 pages for object "DPO6".DBCC results for 'CIN9'.There are 0 rows in 0 pages for object "CIN9".DBCC results for 'PDN13'.There are 0 rows in 0 pages for object "PDN13".DBCC results for 'OCRD'.There are 4071 rows in 477 pages for object "OCRD".DBCC results for 'DMW1'.There are 0 rows in 0 pages for object "DMW1".DBCC results for 'WTR10'.There are 0 rows in 0 pages for object "WTR10".DBCC results for 'OCRC'.There are 0 rows in 0 pages for object "OCRC".DBCC results for '@ACBS_GE_PLAN_SAMPLE'.There are 0 rows in 0 pages for object "@ACBS_GE_PLAN_SAMPLE".DBCC results for '@CBS_OCT3'.There are 0 rows in 0 pages for object "@CBS_OCT3".DBCC results for 'OCDP'.There are 1 rows in 1 pages for object "OCDP".DBCC results for 'CPV10'.There are 0 rows in 0 pages for object "CPV10".DBCC results for '@ARECEIPE'.There are 0 rows in 0 pages for object "@ARECEIPE".DBCC results for 'BGT1'.There are 0 rows in 0 pages for object "BGT1".DBCC results for 'OITG'.There are 64 rows in 1 pages for object "OITG".DBCC results for 'ORDN'.There are 1 rows in 1 pages for object "ORDN".DBCC results for 'RDN7'.There are 0 rows in 0 pages for object "RDN7".DBCC results for '@OCT31'.There are 0 rows in 0 pages for object "@OCT31".DBCC results for 'QWZ2'.There are 0 rows in 0 pages for object "QWZ2".DBCC results for 'RPC6'.There are 69 rows in 5 pages for object "RPC6".DBCC results for 'IPF2'.There are 0 rows in 0 pages for object "IPF2".DBCC results for 'OOND'.There are 0 rows in 0 pages for object "OOND".DBCC results for 'DPI10'.There are 0 rows in 0 pages for object "DPI10".DBCC results for 'RIN12'.There are 6 rows in 1 pages for object "RIN12".DBCC results for 'PCH11'.There are 0 rows in 0 pages for object "PCH11".DBCC results for 'OSTC'.There are 29 rows in 1 pages for object "OSTC".DBCC results for 'FRC1'.There are 42 rows in 2 pages for object "FRC1".DBCC results for 'SCL5'.There are 0 rows in 0 pages for object "SCL5".DBCC results for '@AROUT'.There are 0 rows in 0 pages for object "@AROUT".DBCC results for 'ADOC'.There are 42692 rows in 13453 pages for object "ADOC".DBCC results for 'OITT'.There are 1406 rows in 25 pages for object "OITT".DBCC results for '@OCT311'.There are 0 rows in 0 pages for object "@OCT311".DBCC results for 'OUPT'.There are 0 rows in 0 pages for object "OUPT".DBCC results for 'UDG1'.There are 0 rows in 0 pages for object "UDG1".DBCC results for 'CSI2'.There are 0 rows in 0 pages for object "CSI2".DBCC results for 'AMD1'.There are 0 rows in 0 pages for object "AMD1".DBCC results for '@BIZ_MTRM'.There are 0 rows in 0 pages for object "@BIZ_MTRM".DBCC results for 'ORCN'.There are 0 rows in 0 pages for object "ORCN".DBCC results for 'OOPR'.There are 0 rows in 0 pages for object "OOPR".DBCC results for 'ACR5'.There are 0 rows in 0 pages for object "ACR5".DBCC results for 'OCYC'.There are 0 rows in 0 pages for object "OCYC".DBCC results for '@ADEPT'.There are 0 rows in 0 pages for object "@ADEPT".DBCC results for 'IGN4'.There are 0 rows in 0 pages for object "IGN4".DBCC results for 'WTR11'.There are 0 rows in 0 pages for object "WTR11".DBCC results for 'OCRG'.There are 4 rows in 1 pages for object "OCRG".DBCC results for 'DPO3'.There are 0 rows in 0 pages for object "DPO3".DBCC results for 'OCDT'.There are 0 rows in 0 pages for object "OCDT".DBCC results for 'GBI1'.There are 0 rows in 0 pages for object "GBI1".DBCC results for 'CPV11'.There are 0 rows in 0 pages for object "CPV11".DBCC results for 'POR7'.There are 0 rows in 0 pages for object "POR7".DBCC results for 'CINF'.There are 1 rows in 1 pages for object "CINF".DBCC results for 'BOE1'.There are 0 rows in 0 pages for object "BOE1".DBCC results for 'CTBR'.There are 0 rows in 0 pages for object "CTBR".DBCC results for 'RDN8'.There are 0 rows in 0 pages for object "RDN8".DBCC results for 'DPI12'.There are 0 rows in 0 pages for object "DPI12".DBCC results for 'RIN13'.There are 0 rows in 0 pages for object "RIN13".DBCC results for '@CBS_SHFDEF'.There are 2 rows in 1 pages for object "@CBS_SHFDEF".DBCC results for 'PCH12'.There are 2893 rows in 57 pages for object "PCH12".DBCC results for 'OPOR'.There are 0 rows in 0 pages for object "OPOR".DBCC results for 'QWZ3'.There are 0 rows in 0 pages for object "QWZ3".DBCC results for 'GBI10'.There are 0 rows in 0 pages for object "GBI10".DBCC results for 'SCM1'.There are 0 rows in 0 pages for object "SCM1".DBCC results for 'CIN3'.There are 0 rows in 0 pages for object "CIN3".DBCC results for 'ITM1'.There are 109000 rows in 959 pages for object "ITM1".DBCC results for 'ACRB'.There are 0 rows in 0 pages for object "ACRB".DBCC results for 'ODDG'.There are 0 rows in 0 pages for object "ODDG".DBCC results for '@ODFIA'.There are 0 rows in 0 pages for object "@ODFIA".DBCC results for 'IEI7'.There are 0 rows in 0 pages for object "IEI7".DBCC results for '@CBS_ODFIA'.There are 0 rows in 0 pages for object "@CBS_ODFIA".DBCC results for 'OERN'.There are 4 rows in 1 pages for object "OERN".DBCC results for '@BIZ_OHEM1'.There are 0 rows in 0 pages for object "@BIZ_OHEM1".DBCC results for '@ADEPTGS'.There are 0 rows in 0 pages for object "@ADEPTGS".DBCC results for 'WTR12'.There are 464 rows in 6 pages for object "WTR12".DBCC results for 'CTG1'.There are 0 rows in 0 pages for object "CTG1".DBCC results for 'ARC5'.There are 0 rows in 0 pages for object "ARC5".DBCC results for 'OUQR'.There are 529 rows in 6 pages for object "OUQR".DBCC results for '@ACBS_MACHINE'.There are 25 rows in 1 pages for object "@ACBS_MACHINE".DBCC results for 'OCFH'.There are 0 rows in 0 pages for object "OCFH".DBCC results for 'OSTQ'.There are 0 rows in 0 pages for object "OSTQ".DBCC results for 'GBI11'.There are 0 rows in 0 pages for object "GBI11".DBCC results for 'SCM2'.There are 0 rows in 0 pages for object "SCM2".DBCC results for 'AMR1'.There are 77 rows in 2 pages for object "AMR1".DBCC results for 'CPV12'.There are 0 rows in 0 pages for object "CPV12".DBCC results for 'POR8'.There are 0 rows in 0 pages for object "POR8".DBCC results for 'DPO7'.There are 0 rows in 0 pages for object "DPO7".DBCC results for 'BOT1'.There are 0 rows in 0 pages for object "BOT1".DBCC results for 'RDN9'.There are 0 rows in 0 pages for object "RDN9".DBCC results for 'OCRH'.There are 0 rows in 0 pages for object "OCRH".DBCC results for '@BIZ_OLVR'.There are 0 rows in 0 pages for object "@BIZ_OLVR".DBCC results for 'OEI2'.There are 0 rows in 0 pages for object "OEI2".DBCC results for 'DPI13'.There are 0 rows in 0 pages for object "DPI13".DBCC results for 'ODDT'.There are 0 rows in 0 pages for object "ODDT".DBCC results for 'PCH13'.There are 11 rows in 1 pages for object "PCH13".DBCC results for 'RCR1'.There are 0 rows in 0 pages for object "RCR1".DBCC results for 'OCFL'.There are 0 rows in 0 pages for object "OCFL".DBCC results for 'OHEM'.There are 2 rows in 1 pages for object "OHEM".DBCC results for 'GBI12'.There are 0 rows in 0 pages for object "GBI12".DBCC results for 'ORCR'.There are 0 rows in 0 pages for object "ORCR".DBCC results for 'RPC7'.There are 0 rows in 0 pages for object "RPC7".DBCC results for 'OORL'.There are 0 rows in 0 pages for object "OORL".DBCC results for 'ADO10'.There are 0 rows in 0 pages for object "ADO10".DBCC results for 'OITW'.There are 163486 rows in 7086 pages for object "OITW".DBCC results for 'OUSG'.There are 0 rows in 0 pages for object "OUSG".DBCC results for 'IEI8'.There are 0 rows in 0 pages for object "IEI8".DBCC results for 'OSTT'.There are 19 rows in 1 pages for object "OSTT".DBCC results for 'SCM3'.There are 0 rows in 0 pages for object "SCM3".DBCC results for 'OEXD'.There are 13 rows in 1 pages for object "OEXD".DBCC results for 'OPCH'.There are 2893 rows in 922 pages for object "OPCH".DBCC results for 'ITT1'.There are 2811 rows in 63 pages for object "ITT1".DBCC results for 'BOX1'.There are 0 rows in 0 pages for object "BOX1".DBCC results for '@ADFIA1'.There are 0 rows in 0 pages for object "@ADFIA1".DBCC results for 'WTR13'.There are 0 rows in 0 pages for object "WTR13".DBCC results for 'CTR1'.There are 0 rows in 0 pages for object "CTR1".DBCC results for 'GBI13'.There are 0 rows in 0 pages for object "GBI13".DBCC results for 'AMR2'.There are 0 rows in 0 pages for object "AMR2".DBCC results for 'CPV13'.There are 0 rows in 0 pages for object "CPV13".DBCC results for 'POR9'.There are 0 rows in 0 pages for object "POR9".DBCC results for 'DPO8'.There are 0 rows in 0 pages for object "DPO8".DBCC results for 'OOSR'.There are 0 rows in 0 pages for object "OOSR".DBCC results for '@CBS_SHIFT'.There are 2 rows in 1 pages for object "@CBS_SHIFT".DBCC results for 'ODGP'.There are 0 rows in 0 pages for object "ODGP".DBCC results for 'CSI4'.There are 0 rows in 0 pages for object "CSI4".DBCC results for 'OCFP'.There are 0 rows in 0 pages for object "OCFP".DBCC results for 'SCR1'.There are 0 rows in 0 pages for object "SCR1".DBCC results for '@BIZ_OSSP'.There are 0 rows in 0 pages for object "@BIZ_OSSP".DBCC results for 'PDN2'.There are 0 rows in 0 pages for object "PDN2".DBCC results for 'ONNM'.There are 308 rows in 2 pages for object "ONNM".DBCC results for '@AEPCG'.There are 0 rows in 0 pages for object "@AEPCG".DBCC results for 'CUDC'.There are 3 rows in 1 pages for object "CUDC".DBCC results for 'RDOC'.There are 942 rows in 45 pages for object "RDOC".DBCC results for '@ODFIA12'.There are 0 rows in 0 pages for object "@ODFIA12".DBCC results for 'RCT1'.There are 86 rows in 2 pages for object "RCT1".DBCC results for '@CBS_OEPCG'.There are 0 rows in 0 pages for object "@CBS_OEPCG".DBCC results for 'GBI14'.There are 0 rows in 0 pages for object "GBI14".DBCC results for 'RPC8'.There are 0 rows in 0 pages for object "RPC8".DBCC results for '@AROUTSEQ'.There are 0 rows in 0 pages for object "@AROUTSEQ".DBCC results for 'OOST'.There are 0 rows in 0 pages for object "OOST".DBCC results for 'ADO13'.There are 0 rows in 0 pages for object "ADO13".DBCC results for 'CCAL'.There are 0 rows in 0 pages for object "CCAL".DBCC results for '@ACBS_MITM'.There are 0 rows in 0 pages for object "@ACBS_MITM".DBCC results for 'IEI9'.There are 0 rows in 0 pages for object "IEI9".DBCC results for 'UDG2'.There are 0 rows in 0 pages for object "UDG2".DBCC results for 'OSVR'.There are 0 rows in 0 pages for object "OSVR".DBCC results for 'SCR2'.There are 0 rows in 0 pages for object "SCR2".DBCC results for 'ITW1'.There are 0 rows in 0 pages for object "ITW1".DBCC results for 'ORCT'.There are 713 rows in 103 pages for object "ORCT".DBCC results for 'IGN3'.There are 0 rows in 0 pages for object "IGN3".DBCC results for 'OIWZ'.There are 0 rows in 0 pages for object "OIWZ".DBCC results for 'ARC6'.There are 0 rows in 0 pages for object "ARC6".DBCC results for 'OUSR'.There are 26 rows in 2 pages for object "OUSR".DBCC results for 'GBI15'.There are 0 rows in 0 pages for object "GBI15".DBCC results for 'DPO9'.There are 0 rows in 0 pages for object "DPO9".DBCC results for 'OINV'.There are 1643 rows in 530 pages for object "OINV".DBCC results for '@ASROUT'.There are 0 rows in 0 pages for object "@ASROUT".DBCC results for 'OCFT'.There are 0 rows in 0 pages for object "OCFT".DBCC results for 'OSVT'.There are 0 rows in 0 pages for object "OSVT".DBCC results for 'CPV1'.There are 0 rows in 0 pages for object "CPV1".DBCC results for 'PWZ1'.There are 0 rows in 0 pages for object "PWZ1".DBCC results for '@BIZ_OT'.There are 0 rows in 0 pages for object "@BIZ_OT".DBCC results for 'OPDT'.There are 0 rows in 0 pages for object "OPDT".DBCC results for '@AEPCG1'.There are 0 rows in 0 pages for object "@AEPCG1".DBCC results for 'IGN5'.There are 0 rows in 0 pages for object "IGN5".DBCC results for 'INV1'.There are 1828 rows in 437 pages for object "INV1".DBCC results for 'GBI16'.There are 0 rows in 0 pages for object "GBI16".DBCC results for 'SCR3'.There are 0 rows in 0 pages for object "SCR3".DBCC results for 'AMRV'.There are 77 rows in 2 pages for object "AMRV".DBCC results for 'RPC9'.There are 0 rows in 0 pages for object "RPC9".DBCC results for 'OIGE'.There are 9141 rows in 2286 pages for object "OIGE".DBCC results for 'RIN3'.There are 5 rows in 1 pages for object "RIN3".DBCC results for 'ACRD'.There are 5008 rows in 691 pages for object "ACRD".DBCC results for '@OEPC11'.There are 0 rows in 0 pages for object "@OEPC11".DBCC results for '@ACBS_OANX'.There are 0 rows in 0 pages for object "@ACBS_OANX".DBCC results for 'DPO1'.There are 0 rows in 0 pages for object "DPO1".DBCC results for 'OCFW'.There are 0 rows in 0 pages for object "OCFW".DBCC results for 'OTCD'.There are 4 rows in 1 pages for object "OTCD".DBCC results for 'PWZ2'.There are 0 rows in 0 pages for object "PWZ2".DBCC results for 'OEI4'.There are 0 rows in 0 pages for object "OEI4".DBCC results for 'IVLG'.There are 0 rows in 0 pages for object "IVLG".DBCC results for 'OPEX'.There are 0 rows in 0 pages for object "OPEX".DBCC results for 'RIN2'.There are 0 rows in 0 pages for object "RIN2".DBCC results for 'CCPD'.There are 0 rows in 0 pages for object "CCPD".DBCC results for 'GBI2'.There are 0 rows in 0 pages for object "GBI2".DBCC results for 'SDEX'.There are 0 rows in 0 pages for object "SDEX".DBCC results for 'OADF'.There are 18 rows in 1 pages for object "OADF".DBCC results for 'ORFL'.There are 0 rows in 0 pages for object "ORFL".DBCC results for '@BALE'.There are 0 rows in 0 pages for object "@BALE".DBCC results for 'QUT1'.There are 0 rows in 0 pages for object "QUT1".DBCC results for '@AGMACH'.There are 369 rows in 6 pages for object "@AGMACH".DBCC results for 'CULG'.There are 53 rows in 2 pages for object "CULG".DBCC results for 'ARC7'.There are 0 rows in 0 pages for object "ARC7".DBCC results for 'IGE10'.There are 0 rows in 0 pages for object "IGE10".DBCC results for '@CBS_OLUT'.There are 0 rows in 0 pages for object "@CBS_OLUT".DBCC results for 'PWZ3'.There are 0 rows in 0 pages for object "PWZ3".DBCC results for '@BIZ_PAYACC'.There are 0 rows in 0 pages for object "@BIZ_PAYACC".DBCC results for 'DPS1'.There are 70 rows in 1 pages for object "DPS1".DBCC results for 'OCRN'.There are 5 rows in 1 pages for object "OCRN".DBCC results for 'RCT2'.There are 1 rows in 1 pages for object "RCT2".DBCC results for 'OTER'.There are 0 rows in 0 pages for object "OTER".DBCC results for 'GBI3'.There are 0 rows in 0 pages for object "GBI3".DBCC results for 'OAGP'.There are 0 rows in 0 pages for object "OAGP".DBCC results for 'ORIT'.There are 0 rows in 0 pages for object "ORIT".DBCC results for '@OEPCG'.There are 0 rows in 0 pages for object "@OEPCG".DBCC results for 'OADM'.There are 1 rows in 1 pages for object "OADM".DBCC results for 'DRF10'.There are 0 rows in 0 pages for object "DRF10".DBCC results for 'RPD10'.There are 0 rows in 0 pages for object "RPD10".DBCC results for 'PDN4'.There are 6733 rows in 241 pages for object "PDN4".DBCC results for 'DPI2'.There are 0 rows in 0 pages for object "DPI2".DBCC results for 'PCH2'.There are 0 rows in 0 pages for object "PCH2".DBCC results for 'CUMF'.There are 0 rows in 0 pages for object "CUMF".DBCC results for 'OCHD'.There are 0 rows in 0 pages for object "OCHD".DBCC results for 'CSV3'.There are 0 rows in 0 pages for object "CSV3".DBCC results for 'GBI4'.There are 0 rows in 0 pages for object "GBI4".DBCC results for 'OFCT'.There are 0 rows in 0 pages for object "OFCT".DBCC results for 'OAIB'.There are 163 rows in 1 pages for object "OAIB".DBCC results for 'CDC1'.There are 0 rows in 0 pages for object "CDC1".DBCC results for 'ARI1'.There are 334 rows in 2 pages for object "ARI1".DBCC results for 'IGE11'.There are 0 rows in 0 pages for object "IGE11".DBCC results for '@BIZ_PAYACC1'.There are 0 rows in 0 pages for object "@BIZ_PAYACC1".DBCC results for 'RPD1'.There are 96 rows in 21 pages for object "RPD1".DBCC results for 'ACPR'.There are 4 rows in 1 pages for object "ACPR".DBCC results for '@BCENOTE'.There are 28 rows in 1 pages for object "@BCENOTE".DBCC results for 'IVRU'.There are 0 rows in 0 pages for object "IVRU".DBCC results for 'RPD3'.There are 11 rows in 1 pages for object "RPD3".DBCC results for 'WTR2'.There are 0 rows in 0 pages for object "WTR2".DBCC results for '@ACBS_OCT3'.There are 0 rows in 0 pages for object "@ACBS_OCT3".DBCC results for 'UKD1'.There are 1 rows in 1 pages for object "UKD1".DBCC results for 'OTFC'.There are 12 rows in 1 pages for object "OTFC".DBCC results for 'GBI5'.There are 0 rows in 0 pages for object "GBI5".DBCC results for 'AOB1'.There are 1140 rows in 15 pages for object "AOB1".DBCC results for 'CPV2'.There are 0 rows in 0 pages for object "CPV2".DBCC results for 'ORTM'.There are 0 rows in 0 pages for object "ORTM".DBCC results for 'CDRO'.There are 209 rows in 1 pages for object "CDRO".DBCC results for 'IGN6'.There are 0 rows in 0 pages for object "IGN6".DBCC results for 'CSI5'.There are 0 rows in 0 pages for object "CSI5".DBCC results for 'SDIS'.There are 25 rows in 1 pages for object "SDIS".DBCC results for 'OFLT'.There are 69 rows in 10 pages for object "OFLT".DBCC results for '@BIZ_PAYCD'.There are 0 rows in 0 pages for object "@BIZ_PAYCD".DBCC results for 'DRF11'.There are 0 rows in 0 pages for object "DRF11".DBCC results for 'RPD11'.There are 0 rows in 0 pages for object "RPD11".DBCC results for 'IWZ1'.There are 0 rows in 0 pages for object "IWZ1".DBCC results for 'OPFT'.There are 0 rows in 0 pages for object "OPFT".DBCC results for 'ADO2'.There are 0 rows in 0 pages for object "ADO2".DBCC results for 'CUMI'.There are 105 rows in 1 pages for object "CUMI".DBCC results for 'ASC1'.There are 0 rows in 0 pages for object "ASC1".DBCC results for 'UPT1'.There are 0 rows in 0 pages for object "UPT1".DBCC results for 'QUT3'.There are 0 rows in 0 pages for object "QUT3".DBCC results for '@CBS_OTHER_PLAN_BULK'.There are 0 rows in 0 pages for object "@CBS_OTHER_PLAN_BULK".DBCC results for 'OTNC'.There are 0 rows in 0 pages for object "OTNC".DBCC results for 'GBI6'.There are 0 rows in 0 pages for object "GBI6".DBCC results for '@BCESETT'.There are 1 rows in 1 pages for object "@BCESETT".DBCC results for '@AGNDEPT'.There are 39 rows in 1 pages for object "@AGNDEPT".DBCC results for 'IGE12'.There are 0 rows in 0 pages for object "IGE12".DBCC results for '@CBS_RO1'.There are 5432 rows in 218 pages for object "@CBS_RO1".DBCC results for 'OALC'.There are 0 rows in 0 pages for object "OALC".DBCC results for '@PLANNINGREPORT'.There are 8 rows in 1 pages for object "@PLANNINGREPORT".DBCC results for 'RIN4'.There are 11 rows in 1 pages for object "RIN4".DBCC results for '@OEPCG1'.There are 0 rows in 0 pages for object "@OEPCG1".DBCC results for 'USR1'.There are 7 rows in 1 pages for object "USR1".DBCC results for 'OTNN'.There are 0 rows in 0 pages for object "OTNN".DBCC results for 'GBI7'.There are 0 rows in 0 pages for object "GBI7".DBCC results for 'ACR1'.There are 275 rows in 12 pages for object "ACR1".DBCC results for 'OPID'.There are 3 rows in 1 pages for object "OPID".DBCC results for 'CDRU'.There are 0 rows in 0 pages for object "CDRU".DBCC results for 'OJPE'.There are 0 rows in 0 pages for object "OJPE".DBCC results for 'OCRP'.There are 0 rows in 0 pages for object "OCRP".DBCC results for 'OFRM'.There are 0 rows in 0 pages for object "OFRM".DBCC results for '@BIZ_PAYMD'.There are 0 rows in 0 pages for object "@BIZ_PAYMD".DBCC results for 'DRF12'.There are 384 rows in 6 pages for object "DRF12".DBCC results for 'RPD12'.There are 62 rows in 2 pages for object "RPD12".DBCC results for 'IWZ2'.There are 0 rows in 0 pages for object "IWZ2".DBCC results for 'RITM'.There are 57140 rows in 3481 pages for object "RITM".DBCC results for '@OITEM'.There are 0 rows in 0 pages for object "@OITEM".DBCC results for 'ASC2'.There are 0 rows in 0 pages for object "ASC2".DBCC results for 'USR2'.There are 0 rows in 0 pages for object "USR2".DBCC results for 'PWZ4'.There are 0 rows in 0 pages for object "PWZ4".DBCC results for 'ORTT'.There are 198 rows in 1 pages for object "ORTT".DBCC results for 'OPKG'.There are 0 rows in 0 pages for object "OPKG".DBCC results for '@DELIVERY'.There are 1 rows in 1 pages for object "@DELIVERY".DBCC results for 'OKRT'.There are 0 rows in 0 pages for object "OKRT".DBCC results for '@ACBS_ODFIA'.There are 0 rows in 0 pages for object "@ACBS_ODFIA".DBCC results for 'IGE13'.There are 0 rows in 0 pages for object "IGE13".DBCC results for 'OFRT'.There are 2 rows in 1 pages for object "OFRT".DBCC results for 'AIT1'.There are 145800 rows in 1431 pages for object "AIT1".DBCC results for 'OTOB'.There are 0 rows in 0 pages for object "OTOB".DBCC results for 'SHR1'.There are 0 rows in 0 pages for object "SHR1".DBCC results for 'OALI'.There are 0 rows in 0 pages for object "OALI".DBCC results for 'OEI5'.There are 0 rows in 0 pages for object "OEI5".DBCC results for 'IWZ3'.There are 0 rows in 0 pages for object "IWZ3".DBCC results for 'DPI4'.There are 0 rows in 0 pages for object "DPI4".DBCC results for 'PCH4'.There are 6072 rows in 218 pages for object "PCH4".DBCC results for 'CUPC'.There are 65 rows in 1 pages for object "CUPC".DBCC results for 'USR3'.There are 0 rows in 0 pages for object "USR3".DBCC results for '@DEP'.There are 1 rows in 1 pages for object "@DEP".DBCC results for 'GBI8'.There are 0 rows in 0 pages for object "GBI8".DBCC results for 'PWZ5'.There are 0 rows in 0 pages for object "PWZ5".DBCC results for '@GNDEPT'.There are 39 rows in 1 pages for object "@GNDEPT".DBCC results for 'DRF13'.There are 0 rows in 0 pages for object "DRF13".DBCC results for 'OPLN'.There are 10 rows in 1 pages for object "OPLN".DBCC results for 'OLCT'.There are 0 rows in 0 pages for object "OLCT".DBCC results for 'CSI6'.There are 0 rows in 0 pages for object "CSI6".DBCC results for 'RCT3'.There are 0 rows in 0 pages for object "RCT3".DBCC results for '@CBS_OTHER_PLAN_SAMP'.There are 0 rows in 0 pages for object "@CBS_OTHER_PLAN_SAMP".DBCC results for 'SLM1'.There are 0 rows in 0 pages for object "SLM1".DBCC results for 'AADM'.There are 55 rows in 8 pages for object "AADM".DBCC results for '@BIZ_PFCHALLAN'.There are 0 rows in 0 pages for object "@BIZ_PFCHALLAN".DBCC results for 'OALR'.There are 1140 rows in 21 pages for object "OALR".DBCC results for 'ACR2'.There are 4570 rows in 23 pages for object "ACR2".DBCC results for 'OSAL'.There are 0 rows in 0 pages for object "OSAL".DBCC results for 'RPD13'.There are 0 rows in 0 pages for object "RPD13".DBCC results for '@BFEXTDBVERSION'.There are 2 rows in 1 pages for object "@BFEXTDBVERSION".DBCC results for 'CFH1'.There are 0 rows in 0 pages for object "CFH1".DBCC results for '@AGNMACH'.There are 0 rows in 0 pages for object "@AGNMACH".DBCC results for 'IGN7'.There are 0 rows in 0 pages for object "IGN7".DBCC results for 'WTR4'.There are 0 rows in 0 pages for object "WTR4".DBCC results for '@OLUT'.There are 0 rows in 0 pages for object "@OLUT".DBCC results for 'OCRV'.There are 0 rows in 0 pages for object "OCRV".DBCC results for 'DRF3'.There are 396 rows in 19 pages for object "DRF3".DBCC results for 'OTPA'.There are 1 rows in 1 pages for object "OTPA".DBCC results for 'GBI9'.There are 0 rows in 0 pages for object "GBI9".DBCC results for 'CPV4'.There are 0 rows in 0 pages for object "CPV4".DBCC results for 'ADO5'.There are 0 rows in 0 pages for object "ADO5".DBCC results for 'OLGT'.There are 6 rows in 1 pages for object "OLGT".DBCC results for 'CUVV'.There are 90 rows in 1 pages for object "CUVV".DBCC results for 'ASC3'.There are 0 rows in 0 pages for object "ASC3".DBCC results for 'VLG1'.There are 0 rows in 0 pages for object "VLG1".DBCC results for '@BIZ_PQDET'.There are 0 rows in 0 pages for object "@BIZ_PQDET".DBCC results for 'PDN5'.There are 0 rows in 0 pages for object "PDN5".DBCC results for '@BIZ_ASSET'.There are 0 rows in 0 pages for object "@BIZ_ASSET".DBCC results for '@AGSMC'.There are 0 rows in 0 pages for object "@AGSMC".DBCC results for 'GFL1'.There are 1 rows in 1 pages for object "GFL1".DBCC results for 'MDR1'.There are 0 rows in 0 pages for object "MDR1".DBCC results for 'VPM4'.There are 2593 rows in 63 pages for object "VPM4".DBCC results for 'DDT1'.There are 0 rows in 0 pages for object "DDT1".DBCC results for 'VPM1'.There are 2046 rows in 39 pages for object "VPM1".DBCC results for 'PYD1'.There are 0 rows in 0 pages for object "PYD1".DBCC results for '@BIZ_PQMAS'.There are 0 rows in 0 pages for object "@BIZ_PQMAS".DBCC results for '@BIZ_ATNST'.There are 0 rows in 0 pages for object "@BIZ_ATNST".DBCC results for 'CHD1'.There are 0 rows in 0 pages for object "CHD1".DBCC results for 'IGN8'.There are 0 rows in 0 pages for object "IGN8".DBCC results for '@ACBS_OEPCG'.There are 0 rows in 0 pages for object "@ACBS_OEPCG".DBCC results for 'OCHF'.There are 17 rows in 1 pages for object "OCHF".DBCC results for 'OTPI'.There are 0 rows in 0 pages for object "OTPI".DBCC results for 'GFL2'.There are 1 rows in 1 pages for object "GFL2".DBCC results for 'SLR1'.There are 0 rows in 0 pages for object "SLR1".DBCC results for 'OALT'.There are 6 rows in 1 pages for object "OALT".DBCC results for 'OPPA'.There are 1 rows in 1 pages for object "OPPA".DBCC results for 'OLNG'.There are 7 rows in 1 pages for object "OLNG".DBCC results for 'RCC4'.There are 0 rows in 0 pages for object "RCC4".DBCC results for 'PCH3'.There are 402 rows in 18 pages for object "PCH3".DBCC results for 'PYM1'.There are 0 rows in 0 pages for object "PYM1".DBCC results for 'MIN1'.There are 0 rows in 0 pages for object "MIN1".DBCC results for 'ODIM'.There are 5 rows in 1 pages for object "ODIM".DBCC results for '@ALAB'.There are 0 rows in 0 pages for object "@ALAB".DBCC results for 'DGP1'.There are 0 rows in 0 pages for object "DGP1".DBCC results for '@BUYER'.There are 42 rows in 1 pages for object "@BUYER".DBCC results for 'ASC4'.There are 0 rows in 0 pages for object "ASC4".DBCC results for '@CENVAT'.There are 0 rows in 0 pages for object "@CENVAT".DBCC results for 'OCHH'.There are 86 rows in 2 pages for object "OCHH".DBCC results for 'OSCD'.There are 0 rows in 0 pages for object "OSCD".DBCC results for 'OEI6'.There are 0 rows in 0 pages for object "OEI6".DBCC results for '@OLUT11'.There are 0 rows in 0 pages for object "@OLUT11".DBCC results for 'ODRF'.There are 387 rows in 115 pages for object "ODRF".DBCC results for 'OGBI'.There are 0 rows in 0 pages for object "OGBI".DBCC results for 'CSI7'.There are 0 rows in 0 pages for object "CSI7".DBCC results for 'HEM1'.There are 0 rows in 0 pages for object "HEM1".DBCC results for '@BIZ_PSAL'.There are 0 rows in 0 pages for object "@BIZ_PSAL".DBCC results for '@BIZ_ATREG'.There are 0 rows in 0 pages for object "@BIZ_ATREG".DBCC results for 'WOR1'.There are 7862 rows in 192 pages for object "WOR1".DBCC results for 'RIN5'.There are 0 rows in 0 pages for object "RIN5".DBCC results for 'IGN9'.There are 0 rows in 0 pages for object "IGN9".DBCC results for '@CBS_BALE'.There are 10484 rows in 122 pages for object "@CBS_BALE".DBCC results for 'CSI1'.There are 0 rows in 0 pages for object "CSI1".DBCC results for 'QUE1'.There are 0 rows in 0 pages for object "QUE1".DBCC results for 'CPI3'.There are 0 rows in 0 pages for object "CPI3".DBCC results for 'ACR4'.There are 35 rows in 1 pages for object "ACR4".DBCC results for 'MIN2'.There are 0 rows in 0 pages for object "MIN2".DBCC results for 'ADO7'.There are 0 rows in 0 pages for object "ADO7".DBCC results for 'ODLL'.There are 0 rows in 0 pages for object "ODLL".DBCC results for 'OEI1'.There are 0 rows in 0 pages for object "OEI1".DBCC results for 'OMDR'.There are 0 rows in 0 pages for object "OMDR".DBCC results for 'DGP2'.There are 0 rows in 0 pages for object "DGP2".DBCC results for 'HEM2'.There are 0 rows in 0 pages for object "HEM2".DBCC results for 'SPP1'.There are 0 rows in 0 pages for object "SPP1".DBCC results for 'OWHT'.There are 20 rows in 1 pages for object "OWHT".DBCC results for 'OSCG'.There are 0 rows in 0 pages for object "OSCG".DBCC results for 'CPI10'.There are 0 rows in 0 pages for object "CPI10".DBCC results for 'OVPM'.There are 4232 rows in 634 pages for object "OVPM".DBCC results for '@AMACM1'.There are 0 rows in 0 pages for object "@AMACM1".DBCC results for 'OGFL'.There are 1 rows in 1 pages for object "OGFL".DBCC results for '@CT3'.There are 0 rows in 0 pages for object "@CT3".DBCC results for 'QUE2'.There are 0 rows in 0 pages for object "QUE2".DBCC results for 'PDN6'.There are 3325 rows in 208 pages for object "PDN6".DBCC results for 'WTM3'.There are 2 rows in 1 pages for object "WTM3".DBCC results for 'ODMW'.There are 0 rows in 0 pages for object "ODMW".DBCC results for 'CHFL'.There are 103 rows in 1 pages for object "CHFL".DBCC results for 'DGP3'.There are 0 rows in 0 pages for object "DGP3".DBCC results for 'RDR10'.There are 0 rows in 0 pages for object "RDR10".DBCC results for '@ACBS_OLUT'.There are 0 rows in 0 pages for object "@ACBS_OLUT".DBCC results for 'IGE2'.There are 0 rows in 0 pages for object "IGE2".DBCC results for 'VPM2'.There are 243 rows in 12 pages for object "VPM2".DBCC results for 'DRF1'.There are 2126 rows in 429 pages for object "DRF1".DBCC results for 'RCT4'.There are 369 rows in 10 pages for object "RCT4".DBCC results for 'CSI8'.There are 0 rows in 0 pages for object "CSI8".DBCC results for 'RCT5'.There are 0 rows in 0 pages for object "RCT5".DBCC results for 'HEM3'.There are 0 rows in 0 pages for object "HEM3".DBCC results for '@BIZ_PTCLD'.There are 0 rows in 0 pages for object "@BIZ_PTCLD".DBCC results for 'OSCL'.There are 0 rows in 0 pages for object "OSCL".DBCC results for '@BIZ_BENCD'.There are 0 rows in 0 pages for object "@BIZ_BENCD".DBCC results for 'MIV1'.There are 0 rows in 0 pages for object "MIV1".DBCC results for 'DPI5'.There are 0 rows in 0 pages for object "DPI5".DBCC results for 'ADO8'.There are 0 rows in 0 pages for object "ADO8".DBCC results for 'PCH5'.There are 14 rows in 1 pages for object "PCH5".DBCC results for 'OITM'.There are 10900 rows in 1434 pages for object "OITM".DBCC results for '@OTHER'.There are 0 rows in 0 pages for object "@OTHER".DBCC results for 'OCRY'.There are 239 rows in 3 pages for object "OCRY".DBCC results for 'ODPI'.There are 0 rows in 0 pages for object "ODPI".DBCC results for 'QUT10'.There are 0 rows in 0 pages for object "QUT10".DBCC results for 'DRF2'.There are 0 rows in 0 pages for object "DRF2".DBCC results for 'RDN1'.There are 1 rows in 1 pages for object "RDN1".DBCC results for 'INV10'.There are 0 rows in 0 pages for object "INV10".DBCC results for 'ASC5'.There are 0 rows in 0 pages for object "ASC5".DBCC results for 'OGSP'.There are 0 rows in 0 pages for object "OGSP".DBCC results for 'HEM4'.There are 0 rows in 0 pages for object "HEM4".DBCC results for '@BIZ_PTHDR'.There are 0 rows in 0 pages for object "@BIZ_PTHDR".DBCC results for 'RPD2'.There are 0 rows in 0 pages for object "RPD2".DBCC results for 'CPI11'.There are 0 rows in 0 pages for object "CPI11".DBCC results for '@AMITM'.There are 0 rows in 0 pages for object "@AMITM".DBCC results for 'WTR5'.There are 0 rows in 0 pages for object "WTR5".DBCC results for 'DGP4'.There are 0 rows in 0 pages for object "DGP4".DBCC results for '@CT31'.There are 0 rows in 0 pages for object "@CT31".DBCC results for 'SPP2'.There are 0 rows in 0 pages for object "SPP2".DBCC results for 'CPV5'.There are 0 rows in 0 pages for object "CPV5".DBCC results for 'OAMD'.There are 0 rows in 0 pages for object "OAMD".DBCC results for 'MIV2'.There are 0 rows in 0 pages for object "MIV2".DBCC results for 'OMGP'.There are 0 rows in 0 pages for object "OMGP".DBCC results for 'RDR11'.There are 0 rows in 0 pages for object "RDR11".DBCC results for '@CBS_BALE1'.There are 10484 rows in 204 pages for object "@CBS_BALE1".DBCC results for 'OHED'.There are 0 rows in 0 pages for object "OHED".DBCC results for 'CSI9'.There are 0 rows in 0 pages for object "CSI9".DBCC results for 'OCHO'.There are 2046 rows in 112 pages for object "OCHO".DBCC results for 'HEM5'.There are 0 rows in 0 pages for object "HEM5".DBCC results for 'OEI7'.There are 0 rows in 0 pages for object "OEI7".DBCC results for '@BIZ_BFRM'.There are 0 rows in 0 pages for object "@BIZ_BFRM".DBCC results for 'AFPR'.There are 4 rows in 1 pages for object "AFPR".DBCC results for '@PCS1'.There are 0 rows in 0 pages for object "@PCS1".DBCC results for 'SPRG'.There are 1 rows in 1 pages for object "SPRG".DBCC results for 'QUT11'.There are 0 rows in 0 pages for object "QUT11".DBCC results for 'RIN6'.There are 6 rows in 1 pages for object "RIN6".DBCC results for 'ODNF'.There are 0 rows in 0 pages for object "ODNF".DBCC results for 'INV11'.There are 0 rows in 0 pages for object "INV11".DBCC results for 'OMIN'.There are 0 rows in 0 pages for object "OMIN".DBCC results for 'DLN10'.There are 0 rows in 0 pages for object "DLN10".DBCC results for '@CBS_DEPART'.There are 7 rows in 1 pages for object "@CBS_DEPART".DBCC results for 'OCSQ'.There are 0 rows in 0 pages for object "OCSQ".DBCC results for 'ASCL'.There are 0 rows in 0 pages for object "ASCL".DBCC results for 'OTPR'.There are 2 rows in 1 pages for object "OTPR".DBCC results for '@BIZ_RBCD'.There are 0 rows in 0 pages for object "@BIZ_RBCD".DBCC results for 'OAOB'.There are 1140 rows in 4 pages for object "OAOB".DBCC results for 'OCSV'.There are 0 rows in 0 pages for object "OCSV".DBCC results for 'WTR1'.There are 5392 rows in 972 pages for object "WTR1".DBCC results for 'CPI12'.There are 0 rows in 0 pages for object "CPI12".DBCC results for 'MLS1'.There are 0 rows in 0 pages for object "MLS1".DBCC results for 'OPR1'.There are 0 rows in 0 pages for object "OPR1".DBCC results for 'INV3'.There are 1412 rows in 65 pages for object "INV3".DBCC results for 'CHO1'.There are 3217 rows in 66 pages for object "CHO1".DBCC results for '@AMITM_1'.There are 0 rows in 0 pages for object "@AMITM_1".DBCC results for '@PLANREPORT'.There are 0 rows in 0 pages for object "@PLANREPORT".DBCC results for '@ACBS_OTHER_PLAN_BUL'.There are 0 rows in 0 pages for object "@ACBS_OTHER_PLAN_BUL".DBCC results for 'OHLD'.There are 3 rows in 1 pages for object "OHLD".DBCC results for 'PDF4'.There are 0 rows in 1 pages for object "PDF4".DBCC results for '@FABNOTAX'.There are 1 rows in 1 pages for object "@FABNOTAX".DBCC results for 'ADM1'.There are 1 rows in 1 pages for object "ADM1".DBCC results for 'ODOR'.There are 0 rows in 0 pages for object "ODOR".DBCC results for 'RDR12'.There are 2877 rows in 34 pages for object "RDR12".DBCC results for 'OVNM'.There are 0 rows in 0 pages for object "OVNM".DBCC results for 'RCT6'.There are 0 rows in 0 pages for object "RCT6".DBCC results for '@CXS_TDS_CONCN'.There are 0 rows in 0 pages for object "@CXS_TDS_CONCN".DBCC results for 'OEI8'.There are 0 rows in 0 pages for object "OEI8".DBCC results for 'PDN7'.There are 0 rows in 0 pages for object "PDN7".DBCC results for '@BIZ_BM1'.There are 0 rows in 0 pages for object "@BIZ_BM1".DBCC results for 'MLT1'.There are 0 rows in 0 pages for object "MLT1".DBCC results for 'OMIV'.There are 0 rows in 0 pages for object "OMIV".DBCC results for '@PRCS'.There are 0 rows in 0 pages for object "@PRCS".DBCC results for 'OCTG'.There are 2 rows in 1 pages for object "OCTG".DBCC results for 'QUT12'.There are 0 rows in 0 pages for object "QUT12".DBCC results for 'OARG'.There are 1 rows in 1 pages for object "OARG".DBCC results for 'OWTR'.There are 464 rows in 126 pages for object "OWTR".DBCC results for 'DPI6'.There are 0 rows in 0 pages for object "DPI6".DBCC results for 'ODOW'.There are 30 rows in 1 pages for object "ODOW".DBCC results for 'PCH6'.There are 2893 rows in 181 pages for object "PCH6".DBCC results for 'INV12'.There are 1643 rows in 19 pages for object "INV12".DBCC results for 'DLN11'.There are 0 rows in 0 pages for object "DLN11".DBCC results for 'IGE4'.There are 0 rows in 0 pages for object "IGE4".DBCC results for 'CSTN'.There are 0 rows in 0 pages for object "CSTN".DBCC results for '@CXS_TDS_ENADJ'.There are 0 rows in 0 pages for object "@CXS_TDS_ENADJ".DBCC results for 'SRI1'.There are 0 rows in 0 pages for object "SRI1".DBCC results for '@BIZ_RM1'.There are 0 rows in 0 pages for object "@BIZ_RM1".DBCC results for 'OSCM'.There are 0 rows in 0 pages for object "OSCM".DBCC results for 'AITT'.There are 1458 rows in 17 pages for object "AITT".DBCC results for 'CPI13'.There are 0 rows in 0 pages for object "CPI13".DBCC results for '@BIZ_BONDTL'.There are 0 rows in 0 pages for object "@BIZ_BONDTL".DBCC results for 'MRV1'.There are 77 rows in 2 pages for object "MRV1".DBCC results for 'OPR2'.There are 0 rows in 0 pages for object "OPR2".DBCC results for '@ANNEXURE9'.There are 0 rows in 0 pages for object "@ANNEXURE9".DBCC results for '@PRDN'.There are 0 rows in 0 pages for object "@PRDN".DBCC results for 'OTPS'.There are 1 rows in 1 pages for object "OTPS".DBCC results for 'CPV6'.There are 0 rows in 0 pages for object "CPV6".DBCC results for 'DRF4'.There are 851 rows in 33 pages for object "DRF4".DBCC results for 'ARC4'.There are 265 rows in 12 pages for object "ARC4".DBCC results for 'CHO2'.There are 0 rows in 0 pages for object "CHO2".DBCC results for 'WTR6'.There are 0 rows in 0 pages for object "WTR6".DBCC results for 'OMLS'.There are 0 rows in 0 pages for object "OMLS".DBCC results for 'RDR13'.There are 0 rows in 0 pages for object "RDR13".DBCC results for 'OVRT'.There are 0 rows in 0 pages for object "OVRT".DBCC results for 'CSV10'.There are 0 rows in 0 pages for object "CSV10".DBCC results for '@CXS_TDS_QTDS'.There are 0 rows in 0 pages for object "@CXS_TDS_QTDS".DBCC results for '@BIZ_SALLOG'.There are 0 rows in 0 pages for object "@BIZ_SALLOG".DBCC results for 'RPD4'.There are 53 rows in 2 pages for object "RPD4".DBCC results for 'OEI9'.There are 0 rows in 0 pages for object "OEI9".DBCC results for 'PDN8'.There are 0 rows in 0 pages for object "PDN8".DBCC results for '@BIZ_BONUSCAL'.There are 0 rows in 0 pages for object "@BIZ_BONUSCAL".DBCC results for 'OCPV'.There are 0 rows in 0 pages for object "OCPV".DBCC results for 'OPR3'.There are 0 rows in 0 pages for object "OPR3".DBCC results for 'AITB'.There are 30 rows in 3 pages for object "AITB".DBCC results for '@CBS_MACHINE'.There are 21 rows in 1 pages for object "@CBS_MACHINE".DBCC results for 'VPM3'.There are 0 rows in 0 pages for object "VPM3".DBCC results for 'OHPS'.There are 2 rows in 1 pages for object "OHPS".DBCC results for 'RCT7'.There are 0 rows in 0 pages for object "RCT7".DBCC results for 'OTPW'.There are 0 rows in 0 pages for object "OTPW".DBCC results for 'CHEN'.There are 26 rows in 1 pages for object "CHEN".DBCC results for 'HEM6'.There are 2 rows in 1 pages for object "HEM6".DBCC results for 'QUT13'.There are 0 rows in 0 pages for object "QUT13".DBCC results for 'OARI'.There are 15 rows in 1 pages for object "OARI".DBCC results for 'ORPC'.There are 69 rows in 25 pages for object "ORPC".DBCC results for '@EXINVOICE'.There are 1 rows in 1 pages for object "@EXINVOICE".DBCC results for '@ANXINVOICE'.There are 1 rows in 1 pages for object "@ANXINVOICE".DBCC results for 'INV13'.There are 0 rows in 0 pages for object "INV13".DBCC results for 'DLN12'.There are 5 rows in 1 pages for object "DLN12".DBCC results for 'OVTG'.There are 0 rows in 0 pages for object "OVTG".DBCC results for '@ACBS_OTHER_PLAN_SAM'.There are 0 rows in 0 pages for object "@ACBS_OTHER_PLAN_SAM".DBCC results for '@DEPT'.There are 0 rows in 0 pages for object "@DEPT".DBCC results for '@BIZ_SECTN'.There are 0 rows in 0 pages for object "@BIZ_SECTN".DBCC results for 'OSCN'.There are 0 rows in 0 pages for object "OSCN".DBCC results for '@BIZ_BOTYPE'.There are 0 rows in 0 pages for object "@BIZ_BOTYPE".DBCC results for 'MRV2'.There are 0 rows in 0 pages for object "MRV2".DBCC results for 'RIN7'.There are 0 rows in 0 pages for object "RIN7".DBCC results for 'CIN10'.There are 0 rows in 0 pages for object "CIN10".DBCC results for 'OMLT'.There are 0 rows in 0 pages for object "OMLT".DBCC results for '@PRINT'.There are 0 rows in 0 pages for object "@PRINT".DBCC results for 'OHST'.There are 0 rows in 0 pages for object "OHST".DBCC results for 'DLN3'.There are 0 rows in 0 pages for object "DLN3".DBCC results for 'HLD1'.There are 44 rows in 1 pages for object "HLD1".DBCC results for 'SRT1'.There are 0 rows in 0 pages for object "SRT1".DBCC results for 'ADO12'.There are 1522 rows in 54 pages for object "ADO12".DBCC results for 'OPR4'.There are 0 rows in 0 pages for object "OPR4".DBCC results for '@FAPEXINVOICE'.There are 1 rows in 1 pages for object "@FAPEXINVOICE".DBCC results for 'ODOX'.There are 0 rows in 0 pages for object "ODOX".DBCC results for 'ATC1'.There are 0 rows in 0 pages for object "ATC1".DBCC results for 'CSV11'.There are 0 rows in 0 pages for object "CSV11".DBCC results for 'OTRA'.There are 0 rows in 0 pages for object "OTRA".DBCC results for 'CUFD'.There are 7077 rows in 67 pages for object "CUFD".DBCC results for 'OASC'.There are 0 rows in 0 pages for object "OASC".DBCC results for 'PDN9'.There are 0 rows in 0 pages for object "PDN9".DBCC results for '@ANXSER'.There are 1 rows in 1 pages for object "@ANXSER".DBCC results for 'OHSV'.There are 0 rows in 0 pages for object "OHSV".DBCC results for 'RDFL'.There are 18 rows in 1 pages for object "RDFL".DBCC results for 'HTM1'.There are 0 rows in 0 pages for object "HTM1".DBCC results for 'SRT2'.There are 0 rows in 0 pages for object "SRT2".DBCC results for '@FAPGSMINVOICE'.There are 1 rows in 1 pages for object "@FAPGSMINVOICE".DBCC results for 'OMRC'.There are 1 rows in 1 pages for object "OMRC".DBCC results for 'DLN13'.There are 0 rows in 0 pages for object "DLN13".DBCC results for '@DEPTGS'.There are 0 rows in 0 pages for object "@DEPTGS".DBCC results for '@BIZ_SSP1'.There are 0 rows in 0 pages for object "@BIZ_SSP1".DBCC results for 'OASG'.There are 0 rows in 0 pages for object "OASG".DBCC results for 'OWDD'.There are 357 rows in 6 pages for object "OWDD".DBCC results for 'OENC'.There are 0 rows in 0 pages for object "OENC".DBCC results for '@BIZ_CHLNDET'.There are 0 rows in 0 pages for object "@BIZ_CHLNDET".DBCC results for 'OPR5'.There are 0 rows in 0 pages for object "OPR5".DBCC results for 'DPI7'.There are 0 rows in 0 pages for object "DPI7".DBCC results for 'RIN8'.There are 0 rows in 0 pages for object "RIN8".DBCC results for 'CIN12'.There are 0 rows in 0 pages for object "CIN12".DBCC results for 'PCH7'.There are 0 rows in 0 pages for object "PCH7".DBCC results for '@AOANX'.There are 0 rows in 0 pages for object "@AOANX".DBCC results for 'OCIN'.There are 0 rows in 0 pages for object "OCIN".DBCC results for 'ORDR'.There are 2877 rows in 836 pages for object "ORDR".DBCC results for '@PRO'.There are 0 rows in 0 pages for object "@PRO".DBCC results for 'OHTM'.There are 0 rows in 0 pages for object "OHTM".DBCC results for 'STA1'.There are 32 rows in 1 pages for object "STA1".DBCC results for 'CPV7'.There are 0 rows in 0 pages for object "CPV7".DBCC results for 'OSCO'.There are 3 rows in 1 pages for object "OSCO".DBCC results for 'AITW'.There are 175512 rows in 5190 pages for object "AITW".DBCC results for 'MSN1'.There are 0 rows in 0 pages for object "MSN1".DBCC results for 'JDT1'.There are 113977 rows in 6294 pages for object "JDT1".DBCC results for 'ATT1'.There are 2906 rows in 60 pages for object "ATT1".DBCC results for 'CSV12'.There are 0 rows in 0 pages for object "CSV12".DBCC results for 'RDN10'.There are 0 rows in 0 pages for object "RDN10".DBCC results for 'IBT1'.There are 53563 rows in 2313 pages for object "IBT1".DBCC results for '@BIZ_SSP10'.There are 0 rows in 0 pages for object "@BIZ_SSP10".DBCC results for 'OENT'.There are 0 rows in 0 pages for object "OENT".DBCC results for '@BIZ_CHLNMAS'.There are 0 rows in 0 pages for object "@BIZ_CHLNMAS".DBCC results for 'OPRC'.There are 5 rows in 1 pages for object "OPRC".DBCC results for 'ODPS'.There are 54 rows in 2 pages for object "ODPS".DBCC results for 'WTR7'.There are 0 rows in 0 pages for object "WTR7".DBCC results for 'OMRL'.There are 0 rows in 0 pages for object "OMRL".DBCC results for '@RECEIPE'.There are 0 rows in 0 pages for object "@RECEIPE".DBCC results for 'OCTR'.There are 0 rows in 0 pages for object "OCTR".DBCC results for 'IEI1'.There are 0 rows in 0 pages for object "IEI1".DBCC results for 'OHTR'.There are 0 rows in 0 pages for object "OHTR".DBCC results for 'OCHP'.There are 0 rows in 0 pages for object "OCHP".DBCC results for 'STC1'.There are 68 rows in 1 pages for object "STC1".DBCC results for 'OATC'.There are 0 rows in 0 pages for object "OATC".DBCC results for 'OSCP'.There are 0 rows in 0 pages for object "OSCP".DBCC results for 'PEX1'.There are 0 rows in 0 pages for object "PEX1".DBCC results for 'MSN2'.There are 0 rows in 0 pages for object "MSN2".DBCC results for '@ACBS_PCS'.There are 10572 rows in 168 pages for object "@ACBS_PCS".DBCC results for '@DEPTS'.There are 0 rows in 0 pages for object "@DEPTS".DBCC results for 'UFD1'.There are 3919 rows in 28 pages for object "UFD1".DBCC results for '@BIZ_SSP2'.There are 0 rows in 0 pages for object "@BIZ_SSP2".DBCC results for 'DPI8'.There are 0 rows in 0 pages for object "DPI8".DBCC results for 'RIN9'.There are 0 rows in 0 pages for object "RIN9".DBCC results for 'CIN13'.There are 0 rows in 0 pages for object "CIN13".DBCC results for 'PCH8'.There are 0 rows in 0 pages for object "PCH8".DBCC results for '@RECEPIT'.There are 0 rows in 0 pages for object "@RECEPIT".DBCC results for 'OHTY'.There are 3 rows in 1 pages for object "OHTY".DBCC results for 'OQUT'.There are 0 rows in 0 pages for object "OQUT".DBCC results for 'OCLA'.There are 2 rows in 1 pages for object "OCLA".DBCC results for 'OTRC'.There are 0 rows in 0 pages for object "OTRC".DBCC results for 'CPV8'.There are 0 rows in 0 pages for object "CPV8".DBCC results for 'OBCA'.There are 0 rows in 0 pages for object "OBCA".DBCC results for 'OSCR'.There are 0 rows in 0 pages for object "OSCR".DBCC results for 'POR10'.There are 0 rows in 0 pages for object "POR10".DBCC results for 'MSN3'.There are 0 rows in 0 pages for object "MSN3".DBCC results for 'ATX1'.There are 0 rows in 0 pages for object "ATX1".DBCC results for 'IGE5'.There are 0 rows in 0 pages for object "IGE5".DBCC results for 'CSV13'.There are 0 rows in 0 pages for object "CSV13".DBCC results for 'RDN11'.There are 0 rows in 0 pages for object "RDN11".DBCC results for '@DFIA'.There are 0 rows in 0 pages for object "@DFIA".DBCC results for 'SVR1'.There are 0 rows in 0 pages for object "SVR1".DBCC results for 'CSV1'.There are 0 rows in 0 pages for object "CSV1".DBCC results for '@BIZ_SSP3'.There are 0 rows in 0 pages for object "@BIZ_SSP3".DBCC results for 'ADO1'.There are 8348 rows in 2335 pages for object "ADO1".DBCC results for 'CPI2'.There are 0 rows in 0 pages for object "CPI2".DBCC results for '@BIZ_CMPDTL'.There are 0 rows in 0 pages for object "@BIZ_CMPDTL".DBCC results for 'WTR8'.There are 0 rows in 0 pages for object "WTR8".DBCC results for '@ROUT'.There are 0 rows in 0 pages for object "@ROUT".DBCC results for 'VPM5'.There are 0 rows in 0 pages for object "VPM5".DBCC results for 'OUTB'.There are 172 rows in 3 pages for object "OUTB".DBCC results for 'IEI10'.There are 0 rows in 0 pages for object "IEI10".DBCC results for 'OBCG'.There are 0 rows in 0 pages for object "OBCG".DBCC results for 'DRF5'.There are 0 rows in 0 pages for object "DRF5".DBCC results for 'AJD1'.There are 3150 rows in 165 pages for object "AJD1".DBCC results for '@CTX_CONF'.There are 1 rows in 1 pages for object "@CTX_CONF".DBCC results for 'OPRF'.There are 0 rows in 0 pages for object "OPRF".DBCC results for '@AOCT3'.There are 0 rows in 0 pages for object "@AOCT3".DBCC results for 'PCH1'.There are 4774 rows in 975 pages for object "PCH1".DBCC results for 'RDR2'.There are 0 rows in 0 pages for object "RDR2".DBCC results for 'OVTP'.There are 6 rows in 1 pages for object "OVTP".DBCC results for 'OIDC'.There are 0 rows in 0 pages for object "OIDC".DBCC results for 'OCLG'.There are 0 rows in 1 pages for object "OCLG".DBCC results for 'TCD1'.There are 0 rows in 0 pages for object "TCD1".DBCC results for '@BIZ_SSP4'.There are 0 rows in 0 pages for object "@BIZ_SSP4".DBCC results for '@GMACH'.There are 184 rows in 6 pages for object "@GMACH".DBCC results for 'RPD5'.There are 0 rows in 0 pages for object "RPD5".DBCC results for 'NFN1'.There are 0 rows in 0 pages for object "NFN1".DBCC results for 'WTR3'.There are 0 rows in 0 pages for object "WTR3".DBCC results for 'DPI9'.There are 0 rows in 0 pages for object "DPI9".DBCC results for 'PCH9'.There are 0 rows in 0 pages for object "PCH9".DBCC results for 'IEI3'.There are 0 rows in 0 pages for object "IEI3".DBCC results for 'OTRT'.There are 0 rows in 0 pages for object "OTRT".DBCC results for 'CPV9'.There are 0 rows in 0 pages for object "CPV9".DBCC results for 'QUT2'.There are 0 rows in 0 pages for object "QUT2".DBCC results for 'OBGD'.There are 3 rows in 1 pages for object "OBGD".DBCC results for 'OSCS'.There are 3 rows in 1 pages for object "OSCS".DBCC results for 'OEOY'.There are 0 rows in 0 pages for object "OEOY".DBCC results for 'POR11'.There are 0 rows in 0 pages for object "POR11".DBCC results for 'OPRJ'.There are 0 rows in 0 pages for object "OPRJ".DBCC results for 'RIT1'.There are 0 rows in 0 pages for object "RIT1".DBCC results for 'AACNV001'.There are 0 rows in 0 pages for object "AACNV001".DBCC results for 'INV2'.There are 0 rows in 0 pages for object "INV2".DBCC results for 'OIDX'.There are 1 rows in 1 pages for object "OIDX".DBCC results for 'RDN12'.There are 1 rows in 1 pages for object "RDN12".DBCC results for '@DFIA1'.There are 0 rows in 0 pages for object "@DFIA1".DBCC results for '@BIZ_SSP5'.There are 0 rows in 0 pages for object "@BIZ_SSP5".DBCC results for '@CXS_TDS_SETUP'.There are 1 rows in 1 pages for object "@CXS_TDS_SETUP".DBCC results for '@BIZ_CMPDTL1'.There are 0 rows in 0 pages for object "@BIZ_CMPDTL1".DBCC results for 'WTR9'.There are 0 rows in 0 pages for object "WTR9".DBCC results for 'OVTR'.There are 0 rows in 0 pages for object "OVTR".DBCC results for 'OUDO'.There are 75 rows in 1 pages for object "OUDO".DBCC results for 'IEI11'.There are 0 rows in 0 pages for object "IEI11".DBCC results for 'OPDN'.There are 3325 rows in 939 pages for object "OPDN".DBCC results for 'OSCT'.There are 0 rows in 0 pages for object "OSCT".DBCC results for 'RDR1'.There are 5301 rows in 1214 pages for object "RDR1".DBCC results for 'RPC10'.There are 0 rows in 0 pages for object "RPC10".DBCC results for 'AITM'.There are 14581 rows in 1841 pages for object "AITM".DBCC results for 'OCST'.There are 65 rows in 1 pages for object "OCST".DBCC results for 'ATXI'.There are 0 rows in 0 pages for object "ATXI".DBCC results for '@ACBS_PCS1'.There are 20280 rows in 748 pages for object "@ACBS_PCS1".DBCC results for 'RDN3'.There are 0 rows in 0 pages for object "RDN3".DBCC results for '@DYEING'.There are 0 rows in 0 pages for object "@DYEING".DBCC results for '@BIZ_SSP6'.There are 0 rows in 0 pages for object "@BIZ_SSP6".DBCC results for 'OBGS'.There are 1 rows in 1 pages for object "OBGS".DBCC results for 'OADP'.There are 1 rows in 1 pages for object "OADP".DBCC results for '@CXS_TDS_ASSES'.There are 2 rows in 1 pages for object "@CXS_TDS_ASSES".DBCC results for '@BIZ_DEDCD'.There are 0 rows in 0 pages for object "@BIZ_DEDCD".DBCC results for 'OSGP'.There are 0 rows in 0 pages for object "OSGP".DBCC results for 'POR12'.There are 0 rows in 0 pages for object "POR12".DBCC results for 'OPRT'.There are 0 rows in 0 pages for object "OPRT".DBCC results for 'DPO10'.There are 0 rows in 0 pages for object "DPO10".DBCC results for 'PDF1'.There are 24 rows in 1 pages for object "PDF1".DBCC results for 'DLN2'.There are 0 rows in 0 pages for object "DLN2".DBCC results for 'OIND'.There are 0 rows in 0 pages for object "OIND".DBCC results for 'RDN13'.There are 0 rows in 0 pages for object "RDN13".DBCC results for '@EPCG'.There are 0 rows in 0 pages for object "@EPCG".DBCC results for 'TCD2'.There are 0 rows in 0 pages for object "TCD2".DBCC results for 'CRD1'.There are 205 rows in 9 pages for object "CRD1".DBCC results for '@BIZ_SSP7'.There are 0 rows in 0 pages for object "@BIZ_SSP7".DBCC results for '@CXS_TDS_CERNG'.There are 6 rows in 1 pages for object "@CXS_TDS_CERNG".DBCC results for '@AOCT31'.There are 0 rows in 0 pages for object "@AOCT31".DBCC results for '@ACBS_PO'.There are 1414 rows in 16 pages for object "@ACBS_PO".DBCC results for 'IGE6'.There are 0 rows in 0 pages for object "IGE6".DBCC results for 'VPM6'.There are 32 rows in 1 pages for object "VPM6".DBCC results for 'OTSC'.There are 0 rows in 0 pages for object "OTSC".DBCC results for 'OSHP'.There are 0 rows in 0 pages for object "OSHP".DBCC results for 'OOEI'.There are 0 rows in 0 pages for object "OOEI".DBCC results for 'RPC11'.There are 0 rows in 0 pages for object "RPC11".DBCC results for 'ODPT'.There are 0 rows in 0 pages for object "ODPT".DBCC results for 'OMRV'.There are 77 rows in 2 pages for object "OMRV".DBCC results for 'OINM'.There are 55655 rows in 4777 pages for object "OINM".DBCC results for 'IEI12'.There are 0 rows in 0 pages for object "IEI12".DBCC results for 'TCD3'.There are 0 rows in 0 pages for object "TCD3".DBCC results for '@BIZ_SSP8'.There are 0 rows in 0 pages for object "@BIZ_SSP8".DBCC results for 'DRF6'.There are 260 rows in 17 pages for object "DRF6".DBCC results for 'CPI4'.There are 0 rows in 0 pages for object "CPI4".DBCC results for '@BIZ_DEDDTS'.There are 0 rows in 0 pages for object "@BIZ_DEDDTS".DBCC results for 'OPTF'.There are 0 rows in 0 pages for object "OPTF".DBCC results for '@AOCT311'.There are 0 rows in 0 pages for object "@AOCT311".DBCC results for 'CPV3'.There are 0 rows in 0 pages for object "CPV3".DBCC results for 'RPD6'.There are 62 rows in 4 pages for object "RPD6".DBCC results for 'POR13'.There are 0 rows in 0 pages for object "POR13".DBCC results for 'DPO12'.There are 0 rows in 0 pages for object "DPO12".DBCC results for 'RDR4'.There are 0 rows in 0 pages for object "RDR4".DBCC results for '@EPCG1'.There are 0 rows in 0 pages for object "@EPCG1".DBCC results for 'TCD4'.There are 0 rows in 0 pages for object "TCD4".DBCC results for 'PDN3'.There are 607 rows in 27 pages for object "PDN3".DBCC results for '@BIZ_SSP9'.There are 0 rows in 0 pages for object "@BIZ_SSP9".DBCC results for 'OBGT'.There are 0 rows in 0 pages for object "OBGT".DBCC results for 'OSHR'.There are 0 rows in 0 pages for object "OSHR".DBCC results for '@CXS_TDS_CTGRY'.There are 5 rows in 1 pages for object "@CXS_TDS_CTGRY".DBCC results for 'OPVL'.There are 0 rows in 0 pages for object "OPVL".DBCC results for 'CIN2'.There are 0 rows in 0 pages for object "CIN2".DBCC results for '@ROUTSEQ'.There are 0 rows in 0 pages for object "@ROUTSEQ".DBCC results for 'OIBT'.There are 29631 rows in 2501 pages for object "OIBT".DBCC results for 'OTSI'.There are 0 rows in 0 pages for object "OTSI".DBCC results for 'CRD2'.There are 3734 rows in 21 pages for object "CRD2".DBCC results for 'QUT4'.There are 0 rows in 0 pages for object "QUT4".DBCC results for 'NFN2'.There are 0 rows in 0 pages for object "NFN2".DBCC results for 'RPC12'.There are 69 rows in 2 pages for object "RPC12".DBCC results for 'OIGN'.Msg 2570, Level 16, State 3, Line 1Page (1:129427), slot 0 in object ID 1912015680, index ID 1, partition ID 72057595100069888, alloc unit ID 72057595549581312 (type "In-row data"). Column "VatSumSy" value is out of range for data type "numeric". Update column to a legal value.There are 16045 rows in 4014 pages for object "OIGN".CHECKDB found 0 allocation errors and 1 consistency errors in table 'OIGN' (object ID 1912015680).DBCC results for 'INV4'.There are 3240 rows in 117 pages for object "INV4".DBCC results for 'VPM7'.There are 0 rows in 0 pages for object "VPM7".DBCC results for 'CSV2'.There are 0 rows in 0 pages for object "CSV2".DBCC results for '@EXCISE'.There are 0 rows in 0 pages for object "@EXCISE".DBCC results for 'IEI13'.There are 0 rows in 0 pages for object "IEI13".DBCC results for '@BIZ_TDSC'.There are 0 rows in 0 pages for object "@BIZ_TDSC".DBCC results for 'OSLM'.There are 0 rows in 0 pages for object "OSLM".DBCC results for '@CXS_TDS_DETLS'.There are 10 rows in 1 pages for object "@CXS_TDS_DETLS".DBCC results for '@BIZ_EMPTP'.There are 0 rows in 0 pages for object "@BIZ_EMPTP".DBCC results for '@AODFIA'.There are 0 rows in 0 pages for object "@AODFIA".DBCC results for '@SROUT'.There are 0 rows in 0 pages for object "@SROUT".DBCC results for 'ADO3'.There are 491 rows in 36 pages for object "ADO3".DBCC results for 'TCD5'.There are 0 rows in 0 pages for object "TCD5".DBCC results for 'OBNK'.There are 0 rows in 0 pages for object "OBNK".DBCC results for 'AACP'.There are 20 rows in 3 pages for object "AACP".DBCC results for 'OPWZ'.There are 0 rows in 0 pages for object "OPWZ".DBCC results for 'DPO13'.There are 0 rows in 0 pages for object "DPO13".DBCC results for 'ODSC'.There are 7 rows in 1 pages for object "ODSC".DBCC results for 'PDF2'.There are 0 rows in 0 pages for object "PDF2".DBCC results for 'OMSN'.There are 0 rows in 0 pages for object "OMSN".DBCC results for '@GNMACH'.There are 0 rows in 0 pages for object "@GNMACH".DBCC results for '@BIZ_TDSCHILD'.There are 0 rows in 0 pages for object "@BIZ_TDSCHILD".DBCC results for 'ADO4'.There are 1573 rows in 102 pages for object "ADO4".DBCC results for 'NFN3'.There are 0 rows in 0 pages for object "NFN3".DBCC results for 'OIEI'.There are 0 rows in 0 pages for object "OIEI".DBCC results for '@ACBS_PO1'.There are 1365 rows in 41 pages for object "@ACBS_PO1".DBCC results for 'CRD3'.There are 0 rows in 0 pages for object "CRD3".DBCC results for 'RPC13'.There are 0 rows in 0 pages for object "RPC13".DBCC results for 'DLN4'.There are 1 rows in 1 pages for object "DLN4".DBCC results for 'IGE7'.There are 0 rows in 0 pages for object "IGE7".DBCC results for 'VRT1'.There are 0 rows in 0 pages for object "VRT1".DBCC results for '@GSMC'.There are 0 rows in 0 pages for object "@GSMC".DBCC results for 'TFC1'.There are 32 rows in 1 pages for object "TFC1".DBCC results for '@BIZ_TDSM'.There are 0 rows in 0 pages for object "@BIZ_TDSM".DBCC results for 'OSLP'.There are 1 rows in 1 pages for object "OSLP".DBCC results for '@CXS_TDS_ENTRY'.There are 18 rows in 1 pages for object "@CXS_TDS_ENTRY".DBCC results for '@BIZ_ESICHALLAN'.There are 0 rows in 0 pages for object "@BIZ_ESICHALLAN".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for '@SUPPLIERMASTER'.There are 0 rows in 0 pages for object "@SUPPLIERMASTER".DBCC results for 'AUSR'.There are 101 rows in 10 pages for object "AUSR".DBCC results for 'UDO1'.There are 32 rows in 1 pages for object "UDO1".DBCC results for 'DRF7'.There are 0 rows in 0 pages for object "DRF7".DBCC results for 'OBTF'.There are 170 rows in 6 pages for object "OBTF".DBCC results for 'AACT'.There are 575 rows in 42 pages for object "AACT".DBCC results for '@ACBS_PROCESS'.There are 6 rows in 1 pages for object "@ACBS_PROCESS".DBCC results for 'VRT2'.There are 0 rows in 0 pages for object "VRT2".DBCC results for 'TNN1'.There are 0 rows in 0 pages for object "TNN1".DBCC results for 'RPD7'.There are 0 rows in 0 pages for object "RPD7".DBCC results for '@BIZ_F510'.There are 0 rows in 0 pages for object "@BIZ_F510".DBCC results for 'NFN4'.There are 0 rows in 0 pages for object "NFN4".DBCC results for 'BTF1'.There are 340 rows in 19 pages for object "BTF1".DBCC results for 'ODTY'.There are 0 rows in 0 pages for object "ODTY".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for '@TEST'.There are 0 rows in 0 pages for object "@TEST".DBCC results for '@NOEXINVOICE'.There are 1 rows in 1 pages for object "@NOEXINVOICE".DBCC results for '@AODFIA12'.There are 0 rows in 0 pages for object "@AODFIA12".DBCC results for 'IGE8'.There are 0 rows in 0 pages for object "IGE8".DBCC results for 'VTG1'.There are 0 rows in 0 pages for object "VTG1".DBCC results for 'RDN2'.There are 0 rows in 0 pages for object "RDN2".DBCC results for '@LAB'.There are 0 rows in 0 pages for object "@LAB".DBCC results for 'OCLO'.There are 1 rows in 1 pages for object "OCLO".DBCC results for 'UDO2'.There are 462 rows in 4 pages for object "UDO2".DBCC results for 'CRD4'.There are 17 rows in 1 pages for object "CRD4".DBCC results for '@BIZ_TDSMASTER'.There are 0 rows in 0 pages for object "@BIZ_TDSMASTER".DBCC results for 'OBOE'.There are 0 rows in 0 pages for object "OBOE".DBCC results for '@CXS_TDS_FINYR'.There are 1 rows in 1 pages for object "@CXS_TDS_FINYR".DBCC results for '@BIZ_FFS'.There are 0 rows in 0 pages for object "@BIZ_FFS".DBCC results for 'ODUN'.There are 0 rows in 0 pages for object "ODUN".DBCC results for 'CIN4'.There are 0 rows in 0 pages for object "CIN4".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'TPI1'.There are 0 rows in 0 pages for object "TPI1".DBCC results for 'OSLR'.There are 0 rows in 0 pages for object "OSLR".DBCC results for 'DRF8'.There are 0 rows in 0 pages for object "DRF8".DBCC results for 'NNM1'.There are 82 rows in 1 pages for object "NNM1".DBCC results for 'OINS'.There are 0 rows in 0 pages for object "OINS".DBCC results for 'CSV4'.There are 0 rows in 0 pages for object "CSV4".DBCC results for 'RPD8'.There are 0 rows in 0 pages for object "RPD8".DBCC results for 'CPI5'.There are 0 rows in 0 pages for object "CPI5".DBCC results for 'VTR1'.There are 0 rows in 0 pages for object "VTR1".DBCC results for 'IGE1'.There are 12822 rows in 2532 pages for object "IGE1".DBCC results for 'UDO3'.There are 328 rows in 3 pages for object "UDO3".DBCC results for 'PKL1'.There are 0 rows in 0 pages for object "PKL1".DBCC results for 'CRD5'.There are 0 rows in 0 pages for object "CRD5".DBCC results for 'POR2'.There are 0 rows in 0 pages for object "POR2".DBCC results for 'ODUT'.There are 0 rows in 0 pages for object "ODUT".DBCC results for 'RDR5'.There are 0 rows in 0 pages for object "RDR5".DBCC results for 'IGE9'.There are 0 rows in 0 pages for object "IGE9".DBCC results for '@LOT'.There are 0 rows in 0 pages for object "@LOT".DBCC results for 'OCLS'.There are 0 rows in 0 pages for object "OCLS".DBCC results for 'OTXD'.There are 0 rows in 0 pages for object "OTXD".DBCC results for '@BIZ_WH'.There are 0 rows in 0 pages for object "@BIZ_WH".DBCC results for 'OPKL'.There are 0 rows in 0 pages for object "OPKL".DBCC results for 'AJDT'.There are 1504 rows in 49 pages for object "AJDT".DBCC results for 'CIN1'.There are 0 rows in 0 pages for object "CIN1".DBCC results for '@CXS_TDS_SECTN'.There are 6 rows in 1 pages for object "@CXS_TDS_SECTN".DBCC results for '@BIZ_FRM16'.There are 0 rows in 0 pages for object "@BIZ_FRM16".DBCC results for '@AOEPC11'.There are 0 rows in 0 pages for object "@AOEPC11".DBCC results for 'ARCT'.There are 5280 rows in 849 pages for object "ARCT".DBCC results for 'OWGT'.There are 5 rows in 1 pages for object "OWGT".DBCC results for 'QUT5'.There are 0 rows in 0 pages for object "QUT5".DBCC results for 'OSLT'.There are 0 rows in 0 pages for object "OSLT".DBCC results for 'DRF9'.There are 0 rows in 0 pages for object "DRF9".DBCC results for 'PDF3'.There are 0 rows in 0 pages for object "PDF3".DBCC results for 'INV5'.There are 0 rows in 0 pages for object "INV5".DBCC results for '@WCMR'.There are 0 rows in 0 pages for object "@WCMR".DBCC results for '@ACBS_RO'.There are 4977 rows in 67 pages for object "@ACBS_RO".DBCC results for '@MACHS'.There are 0 rows in 0 pages for object "@MACHS".DBCC results for '@AAAA'.There are 0 rows in 0 pages for object "@AAAA".DBCC results for 'IEI2'.There are 0 rows in 0 pages for object "IEI2".DBCC results for 'DLN1'.There are 5 rows in 1 pages for object "DLN1".DBCC results for 'CRD6'.There are 0 rows in 0 pages for object "CRD6".CHECKDB found 0 allocation errors and 6 consistency errors in database 'Test sks'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.

System database corrupted

rob.shelton — Tue, 22 Sep 2009 13:41:14 GMT

Is there a way to revert the Master and MSDB database back to their initial configration after install without uninstalling and reinstalling SQL Server?

DBCC CHECKTABLE found data consistency errors

mojo-168709 — Tue, 15 Sep 2009 13:42:30 GMT

One of servers reported this, when running DBCC Checktable locally:[code]Msg 8914, Level 16, State 1, Line 1Incorrect PFS free space information for page (1:218034) in object ID 85575343, index ID 1, partition ID 72057594701611008, alloc unit ID 71781727326896128 (type LOB data). Expected value 50_PCT_FULL, actual value 80_PCT_FULL.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 85575343, index ID 1, partition ID 72057594701611008, alloc unit ID 71781727326896128 (type LOB data). The off-row data node at page (1:218034), slot 2, text ID 65938128896 is referenced by page (1:318334), slot 0, but was not seen in the scan.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 85575343, index ID 1, partition ID 72057594701611008, alloc unit ID 71781727326896128 (type LOB data). The off-row data node at page (1:218034), slot 3, text ID 65938128896 is referenced by page (1:215148), slot 26, but was not seen in the scan.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 85575343, index ID 1, partition ID 72057594701611008, alloc unit ID 71781727326896128 (type LOB data). The off-row data node at page (1:318334), slot 0, text ID 65938128896 is not referenced.Msg 8929, Level 16, State 1, Line 1Object ID 85575343, index ID 1, partition ID 72057594701611008, alloc unit ID 72057594705870848 (type In-row data): Errors found in off-row data with ID 65938128896 owned by data record identified by RID = (1:215148:26)CHECKTABLE found 0 allocation errors and 5 consistency errors in table 'aaaaaaa' (object ID 85575343).repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (aaaaaaa.dbo.aaaaaaa).[/code]this is a SQL 2005 server, SP2.Oddly enough, if I run DBCC Checktable, using my desktop's SSMS (SQL 2008) and remote connect to that server, I don't get any error. Why?The table has a clustered index on a varchar(18) column as PK, a non-clustered unique index on a datetime column, and an image type column, among other columns.Based on Paul Randal's blog:http://www.sqlskills.com/BLOGS/PAUL/post/Corruption-bug-that-people-are-hitting-Msg-8914-PFS-free-space.aspxI tried:alter index PK_abcde on dbo.aaaaaaaa REORGANIZE WITH ( LOB_COMPACTION = ON )The problem still persists.What's the proper way to fix this? Since I don't get consistent results, I now wonder if the error is actually real.Thanks,Jason

SQL SERVER detected a logical consistency-based I/O error: torn page

tzertuche — Mon, 23 Jun 2008 14:07:02 GMT

I have seen several entries for this error but they have been contained to non-system databases. I discovered today that one of our servers is throwing this error on the DBCC CheckDB of the [b]MSDB[/b] database. It looks like the server was configured as a SQLSERVER 2005 and then SQL SERVER 2000 databases were restored to it and upgraded to 2005. At that point in time the MSDB database began to throw this error and there is no backup for it. How do I fix the MSDB database so that this error stops?Thanks!

No catalog entry found for partition ID (MSSQL 2005)

abolduc — Mon, 14 Sep 2009 11:20:25 GMT

I've seen few posts regarding this error msg but none that have yet helped me. This error has happened a few times in our environment at seemingly random times, necessitating a restart of the DB service. SQL logs the error as:Date 9/13/2009 1:06:36 AMLog SQL Server (Archive #1 - 9/13/2009 1:09:00 AM)Source spid57MessageNo catalog entry found for partition ID xxx in database yyy. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.In the Windows Event Viewer:Source:MSSQLSERVERTime: 1:06:36 AMCategory: (2)Type: ErrorEventID: 608Description:No catalog entry found for partition ID xxx in database yyy. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.The following SQL statement returns no results:SELECT OBJECT_NAME([object_id]) FROM sys.partitions WHERE partition_id = xxxThe SQL log does provide the SpID...is it possible to identify the process that ran into this problem? Are there additional things I can look at to try and determine where/what is causing this problem.Further Note: I do not have any jobs scheduled for this time and DBCC returns no errorsTIA

error# 625

simon shen — Sat, 12 Sep 2009 03:24:17 GMT

when I execute DBCC CHECKDB sql server returnsCHECKDB found 0 allocation errors and 2 consistency errors in database 'sbli9'.repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDatabase ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.Please advise how to deal with this issuebest regardsShen

Log fills Disk drive. DB down!

Francisco Rosado — Tue, 08 Sep 2009 14:56:09 GMT

Hi friendsI'm running shareportal and the drive where db was located reached the size limit. The database becomes non-operational. File log is huge. the last backup of this clients is about 1 year old. I'm running Sql server 2008.i think that server admins move db files to other disk drive. my attemts to recover database leaves me with a db in emergency mode now.I've tried attach mdf without ldf file unsuccessfulynow, i took both mdf and ldf files and have them in my box with sql server 2008 installed.I need to attach and recover dataPlease help me!(sorry my bad english)

Is CHECKDB necessary on Read-Only DB's?

Ed-86789 — Fri, 28 Aug 2009 13:35:46 GMT

We create daily snapshots of our DB2 core system database on a SQL 2005 server and groom the snapshots according to a retention schedule and have around 40 30GB databases (these are normal db's not MSSQL database snapshots).When the databases are created DBCC CHECKDB is executed and then the db is placed in read-only mode.Since these db's are never written to again, is it still necessary to run CHECKDB on them? They are fairly large and it would take some time to run CHECKDB on all of them. What is advisable in this situation?

sql rounding numbers

MalindaB — Sat, 05 Sep 2009 15:07:11 GMT

I am sending decimal numbers to sql server 2008 express from Flex 3 using ColdFusion. If I set a default value of say 1.5 and send that to sql server it puts it into the table as 2.00. If I do an insertion directly in sql manager the number appears as it should 1.5. Why is it rounding up when I send from flex. This is happening no matter what data type I am using, decimal(4,2), money, float, numeric(6.2).Can anyone shed some light on this problem?

big problem with stored procedure runs very slow- please help

t_marciniszyn — Fri, 04 Sep 2009 11:00:51 GMT

Hi Everyone,i have big problem with stored procedure since 3 weeks. Everything was perfect and now is working very slow. I don't know what is going on. I didn't change nothing on data base since 3 months and suddenly i have got a message from customer that his report doesn't work.I use view like this which is working perfect, i have result in 1 sec.this is view:SELECT dbo.v_TargetGetDataForTotalAccessories.StoreId, dbo.v_TargetGetDataForTotalAccessories.StoreName,dbo.v_TargetGetDataForTotalAccessories.Description, dbo.v_TargetGetDataForTotalAccessories.Contract,SUM(dbo.v_TargetGetDataForTotalAccessories.LineTotal) AS Revenue, COUNT(dbo.v_TargetGetDataForTotalAccessories.Description) AS QtySold,dbo.v_TargetGetDataForTotalAccessories.ProductType, dbo.v_TargetGetDataForTotalAccessories.PCCCode,dbo.v_TargetGetDataForTotalAccessories.DateCreated, dbo.tblUser.UserNameFROM dbo.v_TargetGetDataForTotalAccessories INNER JOINdbo.tblUser ON dbo.v_TargetGetDataForTotalAccessories.PCCCode = dbo.tblUser.PCCCodeWHERE (dbo.v_TargetGetDataForTotalAccessories.ProductType = 3) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 8) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 9) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 10) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 11) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 12) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 14) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 15) OR(dbo.v_TargetGetDataForTotalAccessories.ProductType = 16)GROUP BY dbo.v_TargetGetDataForTotalAccessories.StoreId, dbo.v_TargetGetDataForTotalAccessories.StoreName,dbo.v_TargetGetDataForTotalAccessories.Description, dbo.v_TargetGetDataForTotalAccessories.Contract,dbo.v_TargetGetDataForTotalAccessories.ProductType, dbo.v_TargetGetDataForTotalAccessories.PCCCode,dbo.v_TargetGetDataForTotalAccessories.DateCreated, dbo.tblUser.UserNameAnd after that i use stored procedure which takes ages to get result for example from 2009-07-01 to 2009-07-30 takes 12 min.this is stored procedure:USE [Rosbeg]GO/****** Object: StoredProcedure [CPOS].[RP_TotalAccessories] Script Date: 09/04/2009 16:20:53 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [CPOS].[RP_TotalAccessories](@STARTDATE DATETIME,@ENDDATE DATETIME,@PIVOT BIT)ASSET NOCOUNT ONIF OBJECT_ID('TempDB..#PREPAYSALESNOEQUIP') IS NOT NULLDROP TABLE #PREPAYSALESNOEQUIPSELECT StoreName AS Location, SUM (Revenue) AS Contracts, UserNameINTO [#PREPAYSALESNOEQUIP]FROM dbo.v_TotalAccessoriesWHERE (DateCreated BETWEEN @STARTDATE AND @ENDDATE)GROUP BY StoreName, UserNameIF @PIVOT = 1EXEC sp_transform@TableOrView_name = '[#PREPAYSALESNOEQUIP]',@Aggregate_Column = 'Contracts',@Select_Column = 'Location', -- row header@pivot_column = 'Username' -- column headerELSEEXEC sp_transform@TableOrView_name = '[#PREPAYSALESNOEQUIP]',@Aggregate_Column = 'Contracts',@Select_Column = 'Username', -- row header@pivot_column = 'Location' -- column headerRETURNDatabase has 237Mb. Could you help me where i have to search to fix that problem, because this is strange not every stored procedure are to slow like this above.RegardsThomas

Script to get notification on NTFS Error in event viewer

SQL DBA-909494 — Fri, 28 Aug 2009 03:42:04 GMT

Hi All,I want to implement a script which will send me an alert/notification, whenever it logs a NTFS error in the eventviewer.The event ID for NTFS error in event viewer is 55. Please share some ideas or scripts if any. Thanks

Reading DBCC Checktable Ouptut

Dave Lobas — Thu, 27 Aug 2009 10:01:08 GMT

I am dealing with corruption in one of my tables that was flagged when I ran a DBCC CHECKDB. I backed up the database and restored it to a test version and ran a DBCC CHECKTABLE with the REPAIR_ALLOW_DATA_LOSS option. Here is a sample of the output:DBCC results for 'JournalArchive'.Repair: Deleted record for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data), on page (1:327), slot 5. Indexes will be rebuilt.Repair: Deleted off-row data column with ID 183229939712, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:327), slot 5.Repair: Deleted off-row data column with ID 183230005248, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:327), slot 5.Repair: Deleted record for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data), on page (1:9646), slot 25. Indexes will be rebuilt.Repair: Deleted off-row data column with ID 183114334208, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:9646), slot 25.Repair: Deleted off-row data column with ID 183114399744, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:9646), slot 25.Repair: Deleted record for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data), on page (1:9646), slot 26. Indexes will be rebuilt.Repair: Deleted off-row data column with ID 183115120640, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:9646), slot 26.Repair: Deleted off-row data column with ID 183115186176, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:9646), slot 26.Repair: Deleted record for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data), on page (1:9646), slot 27. Indexes will be rebuilt.Repair: Deleted off-row data column with ID 183115382784, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:9646), slot 27.Repair: Deleted off-row data column with ID 183115448320, for object ID 2009058193, index ID 0, partition ID 72057594038779904, alloc unit ID 413140614447104 (type In-row data) on page (1:9646), slot 27.How do I interpret this output to know what data it is repairing/deleteing?Thanks for your help!

writing result to a file

anujahnavi — Tue, 13 Nov 2007 05:53:00 GMT

execution of a query in sql server express and saving the result/output in a doc /pdf file.

Event ID 832

hdoan — Sun, 23 Aug 2009 08:36:43 GMT

In the past week I see following error, run DBCC and reboot the machine, the error goes away then comes back again. Sometime it shows one or two, sometime it shows a whole page with errors.I run memory check on the server (Windows 2003 Std R2 64 bit) but no errors found. The server is a Dell PE1955 blade server. Is this a bogus error regarding hardware issue? I find only one hit for event id 832 and MSSQLServer as event source on Google.Thanks for your help.hdoanEvent Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 832Date: 8/23/2009Time: 12:10:24 AMUser: N/AComputer: STPSQL1Description:A page that should have been constant has changed (expected checksum: 1dcb28a7, actual checksum: 68c626bb, database 13, file 'E:\Program Files\microsoft sql server\MSSQL\data\WSS_Content.mdf', page (1:885961)). This usually indicates a memory failure or other hardware or OS corruption.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Data:0000: 40 03 00 00 18 00 00 00 @.......0008: 08 00 00 00 53 00 54 00 ....S.T.0010: 50 00 53 00 51 00 4c 00 P.S.Q.L.0018: 31 00 00 00 00 00 00 00 1.......

MSDB Suspect

Viky — Tue, 18 Aug 2009 09:45:27 GMT

I have the following error:TITLE: Microsoft SQL Server Management Studio------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------ADDITIONAL INFORMATION:Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926)------------------------------------------I don´t have a backup file for MSDB database. What can I do?Thanks a lot.Viky.

Lost Certificate and master key

luckysql.kinda — Sun, 23 Aug 2009 02:43:40 GMT

The original post is removed from here as this is sql server 2000 forum. -LK

data corruption

salma-398171 — Tue, 21 Jul 2009 01:51:34 GMT

iam a dba in a large government institution in a database with sql2000 a problem,when i make a dbcc checkdb ,REPAIR_ALLOW_DATA_LOSS i recieve these resultsObject ID 2: Errors found in text ID 124886646784 owned by data record identified by RID = (1:262872:0) id = 1353472296 and indid = 9.Server: Msg 8929, Level 16, State 1, Line 1Object ID 2: Errors found in text ID 124886712320 owned by data record identified by RID = (1:262872:1) id = 1353472296 and indid = 10.Server: Msg 8929, Level 16, State 1, Line 1Object ID 2: Errors found in text ID 124886777856 owned by data record identified by RID = (1:262872:2) id = 1353472296 and indid = 11.the id = 1353472296 is a table when i tried to drop it , i recieve this result:Server: Msg 7105, Level 22, State 6, Line 1Page (1:74480), slot 0 for text, ntext, or image node does not exist.Connection BrokenPlease help me quickly

SQL Server 2005 xp_logininfo error message

Scott E-381021 — Wed, 25 Mar 2009 14:05:17 GMT

If anyone has a valid solution, I am all ears.Here is the issue....when you run xp_logininfo, for some AD accounts (or run a SQL job as the owner being an AD account) you get the following error message: Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62Could not obtain information about Windows NT group/user 'mydomain\UserA', error code 0x5.The OS is Server 2003 Enterprise Edition SP1. SQL Server 2005 SP2 Cummulative update package #2UserA is an admin on the server and has SA rights in SQL Server......exact error message.UserB is not an admin on the server and has datareader only permissions in a single db, and xp_logininfo will validate UserB just fine.This is not a case sensitive username issue in this specific isntance, as noted on this website. I have tried every possible combination, and none of them work!I have tried dropping the login and recreating it..exact same error message.

error 'An inconsistency was detected during an internal operation in database '

mjarsaniya — Fri, 07 Aug 2009 05:46:22 GMT

I get following massage repeatedly in duration of 2 or 3 days.Database name is 'DBNAME'.'An inconsistency was detected during an internal operation in database 'DBNAME'(ID:16) on page (1:524021).Please contact technical support. Reference number 4.'I run following script and it worked out each and every time.GO ALTER DATABASE DBNAME SET EMERGENCYALTER DATABASE DBNAME SET SINGLE_USERDBCC CHECKDB (DBNAME, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;DBCC CHECKDB WITH NO_INFOMSGS;ALTER DATABASE DBNAME SET MULTI_USERBut I want to know the issue and permanent solution for them.I have used 'SELECT * FROM msdb..suspect_pages'but it does not give relevant results for my problem.Can I know which table has corruption or any thing else which solve this problem or explain?

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = or when the subquery is used as an expression.

thieuquanghuy — Wed, 05 Aug 2009 09:02:54 GMT

I want to read an excel file. In that excel file, ID column is generated automatically in stored procedure. I insert them to a temp table, then I update the column ID. After that I insert it to main table. While querying , it shows the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." I don't know why and where it happen. Please help me! It's so important to me. Thanks in advance!Stored procedure code is below: PROCEDURE [ManageStudent].[sp_insertStudentFormExcelFile] -- Add the parameters for the stored procedure here @fileurl nvarchar(400), @prefixStudentID varchar(4), @classid decimal(3,0)ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Declare @SQLString nvarchar(400), @rowcount int, @counter int, @studentnumber int, @studentid varchar(7) Select @studentnumber = (SELECT count(*) from _Student where StudentID like @prefixStudentID+'___' ) -- Insert statements for procedure here SET @SQLString = 'SELECT StudentID, LastName, FirstName, Birthday, Birthplace, Sex, ProvinceID, Address, Telephone, ClassID, NationalityID, ReligionID, SV_Image, GradeID, SystemID, StatusID, NoteFROMOPENDATASOURCE(''Microsoft.ACE.OLEDB.12.0'', ''Data Source='+ @fileurl+';Extended Properties=''''Excel 12.0'''''')...[Sheet1$]' INSERT INTO ManageStudent.StudentTemp EXEC(@SQLString) select @rowcount = (select count(*) from ManageStudent.StudentTemp ) set @counter = 1 while @counter <= @rowcount begin set @studentnumber = @studentnumber+1 set @studentid = @prefixStudentID +'000'+@studentnumber if @studentid < 1000000 set @studentid = '0' + @studentid update ManageStudent.StudentTemp set StudentID = @studentid, ClassID = @classid where StudentID = Convert(varchar(7),@counter) set @counter = @counter+1 end insert into ManageStudent._Student exec('Select * from ManageStudent.StudentTemp') delete from ManageStudent.StudentTemp END

SQLDump

QZheng — Thu, 30 Jul 2009 09:56:22 GMT

My server creating sqldump files that taking up all the C: space. the server stop. when I delete one of my database then the dump file stop create. After I restore the database, it start creating sqldump files again. This is our production database. I have to get it back to work as soon as passible. Anyone can help?Thanks,Qinghong

table restoration question

joshua.aanderson — Fri, 24 Jul 2009 07:54:08 GMT

I had a customer take tables from a test environment and import them to there live environment.Is there an easy way to undo that without comparing the data in both tables and possibly missing something? Tricks / tips ? Thanks.

msg 824 wierd one

Bekir-212336 — Mon, 20 Jul 2009 16:20:29 GMT

Apparent Power loss caused this database to go corrupt. This database in particular did not have any good backups prior to failure. Any select, or drop statements against the table produces to below error message.select * from TBLSTHARMsg 824, Level 24, State 2, Line 1SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0xaa955555). It occurred during a read of page (1:29364) in database ID 7 at offset 0x0000000e568000 in file 'c:\harman.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. dbcc checkdb command in emergency mode or in single user mode produces following message ;dbcc checkdb (harman,repair_allow_data_loss)Msg 8921, Level 16, State 1, Line 1Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 824, Level 24, State 2, Line 1SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0xaa955555). It occurred during a read of page (1:29364) in database ID 7 at offset 0x0000000e568000 in file 'c:\harman.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.Trying to query sys.sysobjects also results in the followingMsg 824, Level 24, State 2, Line 1SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0xaa955555). It occurred during a read of page (1:29364) in database ID 7 at offset 0x0000000e568000 in file 'c:\harman.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.I need to get to the data in that particular table somehow; What other options do I have besides messing with the hex editors :( or third party recovery tools ;Any help would be really appreciated. thanks

Severe error occurred on DBCC SHRINKFILE, EMPTYFILE

Tommy Bollhofer — Thu, 18 Jun 2009 07:44:52 GMT

After approx. 2 minutes into the EMPTYFILE, the error message:Msg 0, Level 11, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded. Command executed: [code]DBCC SHRINKFILE (N'TitlePointDB_Data3' , EMPTYFILE)[/code]Database:[code]CREATE DATABASE [LargeDatabase] ON PRIMARY ( NAME = N'LargeDatabase_Data', FILENAME = N'j:\SqlData\LargeDatabase.mdf' , SIZE = 870400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 0), ( NAME = N'LargeDatabase_Data12', FILENAME = N'H:\SQLData\LargeDatabase_Data12.ndf' , SIZE = 230400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1048576KB ), ( NAME = N'LargeDatabase_Data13', FILENAME = N'G:\SQLData\LargeDatabase_Data13.ndf' , SIZE = 230400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1048576KB ), ( NAME = N'LargeDatabase_Data14', FILENAME = N'G:\SQLData\LargeDatabase_Data14.ndf' , SIZE = 230400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1048576KB ), ( NAME = N'LargeDatabase_Data15', FILENAME = N'F:\SQLData\LargeDatabase_Data15.ndf' , SIZE = 230400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1048576KB ), ( NAME = N'LargeDatabase_Data16', FILENAME = N'F:\SQLData\LargeDatabase_Data16.ndf' , SIZE = 230400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1048576KB ), ( NAME = N'LargeDatabase_Data2', FILENAME = N'k:\SqlData\LargeDatabase_1.mdf' , SIZE = 870400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 0), ( NAME = N'LargeDatabase_Data3', FILENAME = N'l:\SqlData\LargeDatabase_Data3.ndf' , SIZE = 870400000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 0) LOG ON ( NAME = N'LargeDatabase_log', FILENAME = N'n:\SqlLog\LargeDatabase_log.ldf' , SIZE = 40960000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1048576KB ), ( NAME = N'LargeDatabase_log2', FILENAME = N'O:\SqlLog\LargeDatabase_log2.ldf' , SIZE = 30720000KB , MAXSIZE = 2048GB , FILEGROWTH = 1048576KB )GO[/code]Any ideas?

Possible Data corruption ?

Laerte Poltronieri Junior-367636 — Sat, 25 Jul 2009 06:50:26 GMT

Hi all, I have this error whith this commandbackup log yp01financeiro with truncate_onlygodbcc shrinkdatabase(N'yp01financeiro')Msg 8966, Level 16, State 4, Line 1Unable to read and latch page (1:412488) with latch type SH. UtilDbccVerifyPageId failed.This is a possible data corruption ?..[b]Dbcc checkdb returns [/b]Msg 8946, Level 16, State 12, Line 1Table error: Allocation page (1:412488) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.DBCC results for 'yp01financeiro'.Msg 8921, Level 16, State 1, Line 1Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 8966, Level 16, State 4, Line 1Unable to read and latch page (1:412488) with latch type SH. UtilDbccVerifyPageId failed. CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.Msg 2579, Level 16, State 1, Line 1Table error: Extent (1:413448) in object ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data) is beyond the range of this database.Msg 2579, Level 16, State 1, Line 1Table error: Extent (1:413472) in object ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data) is beyond the range of this database.Msg 2579, Level 16, State 1, Line 1Table error: Extent (1:413480) in object ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data) is beyond the range of this database.Msg 2579, Level 16, State 1, Line 1Table error: Extent (1:413688) in object ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data) is beyond the range of this database.CHECKDB found 4 allocation errors and 0 consistency errors in table 'sys.sysfiles1' (object ID 8).CHECKDB found 4 allocation errors and 1 consistency errors in database 'yp01financeiro'.what is the severity of this error and what can I do?Thanks all

Database in Transition

Tim Riley-492074 — Thu, 17 Jan 2008 07:11:58 GMT

I was trying to detach a database offline but the operation failed because there was an existing connection. Now, when I try to access the database I'm told that it does not exist and if I try to look at the properties I get the message that the database is in transition and to try the operation at a later time.How do I correct/remove the 'in transition' so I can detach the database?Tim