Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wawansur
Starting Member
44 Posts |
 Posted - 2009-08-13 : 23:05:21
|
| I Don't know where to post this problem, sorry if wrong placei run this query in the other PC from my PC in the Query Analyzer.ALTER VIEW dbo.vNeraca--WITH ENCRYPTIONASSelect AA.FBln,AA.FThn,AA.FCOA,ATy.FType,IsNull((Select Sum(FNominal) from J_R Where FCOA In(SELECT FCOA FROM COA CINNER JOIN AType A ON C.FType = A.FType WHERE A.FOrder >= 4000 ANDA.FOrder < 9000 And Month(FTgl)=AA.FBln And Year(Ftgl)=AA.FThn)),0) As FNominalFrom ALR AAINNER JOIN COA C ON C.FCOA=AA.FCOAINNER JOIN ATYPE ATy ON ATy.FType=C.FTypei have result like thisServer: Msg 644, Level 21, State 3, Procedure vNeraca, Line 10Could not find the index entry for RID '16072cfd1bfed272131000500' in index page (1:152), index ID 0, database 'dbIntegrated_BNI_WOEn'.ODBC: Msg 0, Level 16, State 1Communication link failureODBC: Msg 0, Level 16, State 1Communication link failureConnection BrokenAny suggest ?As information, this happen after i defragment the PC.That error is happen when i run qeury only.I can do the other task, like backup,restore,attach and detach the database.Rgds |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-14 : 00:38:17
|
| run DBCC CHECKDB on dbIntegrated_BNI_WOEn.DON'T Detach it |
 |
|
|
wawansur
Starting Member
44 Posts |
Posted - 2009-08-14 : 03:24:03
|
| How?I don't idea about itRgds |
|
|
|
wawansur
Starting Member
44 Posts |
Posted - 2009-08-14 : 03:30:10
|
| I get this result, I don't know to analyze thatServer: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 6, index ID 1. Page (1:627) is missing a reference from previous page (1:130). Possible chain linkage problem.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 12, index ID 1. The high key value on page (1:152) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:511).Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 12, index ID 1. The previous link (1:511) on page (1:438) does not match the previous page (1:152) that the parent (1:54), slot 5 expects for this page.Server: Msg 8977, Level 16, State 1, Line 1Table error: Object ID 12, index ID 1. Parent node for page (1:511) was not encountered.DBCC results for 'dbIntegrated_BNI_WOEn'.DBCC results for 'sysobjects'.There are 800 rows in 14 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 348 rows in 12 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 2382 rows in 33 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 645 rows in 133 pages for object 'syscomments'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'syscomments' (object ID 6).DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 18 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 12 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 7713 rows in 39 pages for object 'sysdepends'.CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysdepends' (object ID 12).DBCC results for 'sysreferences'.There are 96 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'BCASH'.There are 2 rows in 1 pages for object 'BCASH'.DBCC results for 'Cmpy'.There are 1 rows in 1 pages for object 'Cmpy'.DBCC results for 'TrPOBeliRet_R'.There are 2 rows in 1 pages for object 'TrPOBeliRet_R'.DBCC results for 'COA_R'.There are 88 rows in 1 pages for object 'COA_R'.DBCC results for 'Merk'.There are 1 rows in 1 pages for object 'Merk'.DBCC results for 'TrPOBeliRet_Terima'.There are 2 rows in 1 pages for object 'TrPOBeliRet_Terima'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'FByr'.There are 2 rows in 1 pages for object 'FByr'.DBCC results for 'TrPOBeliRet_Biaya'.There are 0 rows in 1 pages for object 'TrPOBeliRet_Biaya'.DBCC results for 'TrPO_Biaya'.There are 1 rows in 1 pages for object 'TrPO_Biaya'.DBCC results for 'SALESMAN'.There are 2 rows in 1 pages for object 'SALESMAN'.DBCC results for 'TrSOJualRet_H'.There are 1 rows in 1 pages for object 'TrSOJualRet_H'.DBCC results for 'PARAMETER'.There are 41 rows in 1 pages for object 'PARAMETER'.DBCC results for 'TrSO_R'.There are 1 rows in 1 pages for object 'TrSO_R'.DBCC results for 'PELANGGAN'.There are 3 rows in 1 pages for object 'PELANGGAN'.DBCC results for 'TrProd_H'.There are 1 rows in 1 pages for object 'TrProd_H'.DBCC results for 'UserList'.There are 0 rows in 0 pages for object 'UserList'.DBCC results for 'TrProd_Msk'.There are 1 rows in 1 pages for object 'TrProd_Msk'.DBCC results for 'VENDOR'.There are 2 rows in 1 pages for object 'VENDOR'.DBCC results for 'TrSOJual_R'.There are 3 rows in 1 pages for object 'TrSOJual_R'.DBCC results for 'ALR'.There are 5 rows in 1 pages for object 'ALR'.DBCC results for 'TrSOJualRet_Byr'.There are 1 rows in 1 pages for object 'TrSOJualRet_Byr'.DBCC results for 'TrPOBatal_H'.There are 0 rows in 1 pages for object 'TrPOBatal_H'.DBCC results for 'TrSOJualRet_Biaya'.There are 0 rows in 0 pages for object 'TrSOJualRet_Biaya'.DBCC results for 'TrProd_Klr'.There are 1 rows in 1 pages for object 'TrProd_Klr'.DBCC results for 'MtdHPP'.There are 2 rows in 1 pages for object 'MtdHPP'.DBCC results for 'TrPOBatal_R'.There are 0 rows in 1 pages for object 'TrPOBatal_R'.DBCC results for 'Gdg'.There are 2 rows in 1 pages for object 'Gdg'.DBCC results for 'Htg_H'.There are 3 rows in 1 pages for object 'Htg_H'.DBCC results for 'TrProd_Biaya'.There are 1 rows in 1 pages for object 'TrProd_Biaya'.DBCC results for 'MtdPenyFA'.There are 1 rows in 1 pages for object 'MtdPenyFA'.DBCC results for 'Htg_KasMsk'.There are 0 rows in 0 pages for object 'Htg_KasMsk'.DBCC results for 'TrSO_Biaya'.There are 0 rows in 1 pages for object 'TrSO_Biaya'.DBCC results for 'Ktgr'.There are 2 rows in 1 pages for object 'Ktgr'.DBCC results for 'Htg_R'.There are 3 rows in 1 pages for object 'Htg_R'.DBCC results for 'TrSOJualRet_R'.There are 1 rows in 1 pages for object 'TrSOJualRet_R'.DBCC results for 'Stck'.There are 3 rows in 1 pages for object 'Stck'.DBCC results for 'HtgByr_H'.There are 0 rows in 1 pages for object 'HtgByr_H'.DBCC results for 'HtgByr_KasKlr'.There are 0 rows in 1 pages for object 'HtgByr_KasKlr'.DBCC results for 'HtgByr_R'.There are 0 rows in 1 pages for object 'HtgByr_R'.DBCC results for 'Stck_R'.There are 1 rows in 1 pages for object 'Stck_R'.DBCC results for 'J_H'.There are 29 rows in 1 pages for object 'J_H'.DBCC results for 'J_R'.There are 134 rows in 2 pages for object 'J_R'.DBCC results for 'PAJAK'.There are 2 rows in 1 pages for object 'PAJAK'.DBCC results for 'KasKlr'.There are 7 rows in 1 pages for object 'KasKlr'.DBCC results for 'TrPOBeli_R'.There are 2 rows in 1 pages for object 'TrPOBeli_R'.DBCC results for 'FKrm'.There are 1 rows in 1 pages for object 'FKrm'.DBCC results for 'KasKlrCair'.There are 0 rows in 0 pages for object 'KasKlrCair'.DBCC results for 'KasKlrDebet'.There are 1 rows in 1 pages for object 'KasKlrDebet'.DBCC results for 'KasKlrKredit'.There are 7 rows in 1 pages for object 'KasKlrKredit'.DBCC results for 'TrSOBatal_R'.There are 0 rows in 1 pages for object 'TrSOBatal_R'.DBCC results for 'KasMsk'.There are 9 rows in 1 pages for object 'KasMsk'.DBCC results for 'KasMskCair'.There are 0 rows in 0 pages for object 'KasMskCair'.DBCC results for 'TrStckMsk_H'.There are 0 rows in 1 pages for object 'TrStckMsk_H'.DBCC results for 'KasMskDebet'.There are 9 rows in 1 pages for object 'KasMskDebet'.DBCC results for 'TrStckPdh_R'.There are 1 rows in 1 pages for object 'TrStckPdh_R'.DBCC results for 'KasMskKredit'.There are 11 rows in 1 pages for object 'KasMskKredit'.DBCC results for 'TrPOBeli_H'.There are 2 rows in 1 pages for object 'TrPOBeli_H'.DBCC results for 'PdhBuku_H'.There are 2 rows in 1 pages for object 'PdhBuku_H'.DBCC results for 'StckKlr_Temp'.There are 0 rows in 1 pages for object 'StckKlr_Temp'.DBCC results for 'PdhBuku_R'.There are 2 rows in 1 pages for object 'PdhBuku_R'.DBCC results for 'StckMsk_Temp'.There are 0 rows in 1 pages for object 'StckMsk_Temp'.DBCC results for 'TrStckKlr_H'.There are 0 rows in 1 pages for object 'TrStckKlr_H'.DBCC results for 'TrStckAdj_R'.There are 1 rows in 1 pages for object 'TrStckAdj_R'.DBCC results for 'TrStckKlr_R'.There are 0 rows in 1 pages for object 'TrStckKlr_R'.DBCC results for 'Penerimaan'.There are 2 rows in 1 pages for object 'Penerimaan'.DBCC results for 'PenerimaanDetail'.There are 2 rows in 1 pages for object 'PenerimaanDetail'.DBCC results for 'TrStckPdh_H'.There are 1 rows in 1 pages for object 'TrStckPdh_H'.DBCC results for 'Pengeluaran'.There are 1 rows in 1 pages for object 'Pengeluaran'.DBCC results for 'TrPOBeli_Byr'.There are 2 rows in 1 pages for object 'TrPOBeli_Byr'.DBCC results for 'PengeluaranDetail'.There are 1 rows in 1 pages for object 'PengeluaranDetail'.DBCC results for 'TrStckAdj_H'.There are 1 rows in 1 pages for object 'TrStckAdj_H'.DBCC results for 'TrPOBeli_Biaya'.There are 1 rows in 1 pages for object 'TrPOBeli_Biaya'.DBCC results for 'TrSOJual_H'.There are 3 rows in 1 pages for object 'TrSOJual_H'.DBCC results for 'Piutg_H'.There are 10 rows in 1 pages for object 'Piutg_H'.DBCC results for 'Pinjaman_H'.There are 4 rows in 1 pages for object 'Pinjaman_H'.DBCC results for 'Piutg_KasKlr'.There are 0 rows in 0 pages for object 'Piutg_KasKlr'.DBCC results for 'Piutg_R'.There are 59 rows in 2 pages for object 'Piutg_R'.DBCC results for 'TrPO_H'.There are 1 rows in 1 pages for object 'TrPO_H'.DBCC results for 'Pinjaman_KasKlr'.There are 3 rows in 1 pages for object 'Pinjaman_KasKlr'.DBCC results for 'PiutgHtg_R'.There are 62 rows in 2 pages for object 'PiutgHtg_R'.DBCC results for 'Pinjaman_R'.There are 53 rows in 2 pages for object 'Pinjaman_R'.DBCC results for 'PiutgTerima_H'.There are 5 rows in 1 pages for object 'PiutgTerima_H'.DBCC results for 'PiutgTerima_KasMsk'.There are 5 rows in 1 pages for object 'PiutgTerima_KasMsk'.DBCC results for 'PiutgTerima_R'.There are 10 rows in 1 pages for object 'PiutgTerima_R'.DBCC results for 'Dept'.There are 6 rows in 1 pages for object 'Dept'.DBCC results for 'TrSO_H'.There are 1 rows in 1 pages for object 'TrSO_H'.DBCC results for 'WILYH'.There are 1 rows in 1 pages for object 'WILYH'.DBCC results for 'TrSOJual_Biaya'.There are 0 rows in 1 pages for object 'TrSOJual_Biaya'.DBCC results for 'StckKlr'.There are 7 rows in 1 pages for object 'StckKlr'.DBCC results for 'TrSOJual_Terima'.There are 3 rows in 1 pages for object 'TrSOJual_Terima'.DBCC results for 'AType'.There are 30 rows in 1 pages for object 'AType'.DBCC results for 'StckMsk'.There are 6 rows in 1 pages for object 'StckMsk'.DBCC results for 'COA'.There are 128 rows in 3 pages for object 'COA'.DBCC results for 'TrPOBeliRet_H'.There are 2 rows in 1 pages for object 'TrPOBeliRet_H'.DBCC results for 'TrSOBatal_H'.There are 0 rows in 1 pages for object 'TrSOBatal_H'.DBCC results for 'FA'.There are 1 rows in 1 pages for object 'FA'.DBCC results for 'TrStckMsk_R'.There are 0 rows in 0 pages for object 'TrStckMsk_R'.DBCC results for 'TrPO_R'.There are 1 rows in 1 pages for object 'TrPO_R'.DBCC results for 'BCASHType'.There are 2 rows in 1 pages for object 'BCASHType'.DBCC results for 'FA_R'.There are 120 rows in 2 pages for object 'FA_R'.CHECKDB found 0 allocation errors and 4 consistency errors in database 'dbIntegrated_BNI_WOEn'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (dbIntegrated_BNI_WOEn ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.Rgds |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-14 : 10:13:41
|
| ok, you have some corruption in a couple of system tables. sysdepends i'm not too worried about. syscomments is where info on your SPs and Views are stored...First try dropping that view and recreating it. Then run DBCC CHECKDB again. IF it still reports same errors (on object_id 6 & 12):1. get a backup ready2. script out all of your views, functions and stored procs. And save the script.3. run DBCC CHECKDB ('dbIntegrated_BNI_WOEn', REPAIR_ALLOW_DATA_LOSS)You may lose some views/SPs. check all of them after running the repair. Let us see the output of checkdb after doing this |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-14 : 11:17:42
|
Is it a great plan yo jump straight to REPAIR_ALLOW_DATA_LOSS?I understand that if you follow the instructions you will have backups of the stored procs and views but wouldn't it be better to attemptDBCC CHECKDB ('dbIntegrated_BNI_WOEn', REPAIR_REBUILD)first as this is safe?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-14 : 11:35:55
|
Also -- you'll need to put the database into single user mode to do either of those suggestionsALTER DATABASE dbIntegrated_BNI_WOEn SET SINGLE_USER Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
wawansur
Starting Member
44 Posts |
Posted - 2009-08-14 : 23:45:16
|
| When I run :DBCC CHECKDB ('dbIntegrated_BNI_WOEn', REPAIR_REBUILD)orDBCC CHECKDB ('dbIntegrated_BNI_WOEn', REPAIR_ALLOW_DATA_LOSS)i got this message, what i should to do ?Server: Msg 1505, Level 16, State 1, Line 1CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '514100872'.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 6, index ID 1. Page (1:627) is missing a reference from previous page (1:130). Possible chain linkage problem.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 12, index ID 1. The high key value on page (1:152) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:511).Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 12, index ID 1. The previous link (1:511) on page (1:438) does not match the previous page (1:152) that the parent (1:54), slot 5 expects for this page.Server: Msg 8977, Level 16, State 1, Line 1Table error: Object ID 12, index ID 1. Parent node for page (1:511) was not encountered.Clustered index successfully restored for object 'sysdepends' in database 'dbIntegrated_BNI_WOEn'.DBCC results for 'dbIntegrated_BNI_WOEn'.DBCC results for 'sysobjects'.There are 800 rows in 14 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 348 rows in 12 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 2382 rows in 33 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'. Could not repair this error. There are 645 rows in 133 pages for object 'syscomments'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'syscomments' (object ID 6).DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 18 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 12 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'. The error has been repaired. The error has been repaired. The error has been repaired.Clustered index successfully restored for object 'dbo.sysdepends' in database 'dbIntegrated_BNI_WOEn'.There are 7713 rows in 39 pages for object 'sysdepends'.CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysdepends' (object ID 12).CHECKDB fixed 0 allocation errors and 3 consistency errors in table 'sysdepends' (object ID 12).DBCC results for 'sysreferences'.There are 96 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'BCASH'.There are 2 rows in 1 pages for object 'BCASH'.DBCC results for 'Cmpy'.There are 1 rows in 1 pages for object 'Cmpy'.DBCC results for 'TrPOBeliRet_R'.There are 2 rows in 1 pages for object 'TrPOBeliRet_R'.DBCC results for 'COA_R'.There are 88 rows in 1 pages for object 'COA_R'.DBCC results for 'Merk'.There are 1 rows in 1 pages for object 'Merk'.DBCC results for 'TrPOBeliRet_Terima'.There are 2 rows in 1 pages for object 'TrPOBeliRet_Terima'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'FByr'.There are 2 rows in 1 pages for object 'FByr'.DBCC results for 'TrPOBeliRet_Biaya'.There are 0 rows in 1 pages for object 'TrPOBeliRet_Biaya'.DBCC results for 'TrPO_Biaya'.There are 1 rows in 1 pages for object 'TrPO_Biaya'.DBCC results for 'SALESMAN'.There are 2 rows in 1 pages for object 'SALESMAN'.DBCC results for 'TrSOJualRet_H'.There are 1 rows in 1 pages for object 'TrSOJualRet_H'.DBCC results for 'PARAMETER'.There are 41 rows in 1 pages for object 'PARAMETER'.DBCC results for 'TrSO_R'.There are 1 rows in 1 pages for object 'TrSO_R'.DBCC results for 'PELANGGAN'.There are 3 rows in 1 pages for object 'PELANGGAN'.DBCC results for 'TrProd_H'.There are 1 rows in 1 pages for object 'TrProd_H'.DBCC results for 'UserList'.There are 0 rows in 0 pages for object 'UserList'.DBCC results for 'TrProd_Msk'.There are 1 rows in 1 pages for object 'TrProd_Msk'.DBCC results for 'VENDOR'.There are 2 rows in 1 pages for object 'VENDOR'.DBCC results for 'TrSOJual_R'.There are 3 rows in 1 pages for object 'TrSOJual_R'.DBCC results for 'ALR'.There are 5 rows in 1 pages for object 'ALR'.DBCC results for 'TrSOJualRet_Byr'.There are 1 rows in 1 pages for object 'TrSOJualRet_Byr'.DBCC results for 'TrPOBatal_H'.There are 0 rows in 1 pages for object 'TrPOBatal_H'.DBCC results for 'TrSOJualRet_Biaya'.There are 0 rows in 0 pages for object 'TrSOJualRet_Biaya'.DBCC results for 'TrProd_Klr'.There are 1 rows in 1 pages for object 'TrProd_Klr'.DBCC results for 'MtdHPP'.There are 2 rows in 1 pages for object 'MtdHPP'.DBCC results for 'TrPOBatal_R'.There are 0 rows in 1 pages for object 'TrPOBatal_R'.DBCC results for 'Gdg'.There are 2 rows in 1 pages for object 'Gdg'.DBCC results for 'Htg_H'.There are 3 rows in 1 pages for object 'Htg_H'.DBCC results for 'TrProd_Biaya'.There are 1 rows in 1 pages for object 'TrProd_Biaya'.DBCC results for 'MtdPenyFA'.There are 1 rows in 1 pages for object 'MtdPenyFA'.DBCC results for 'Htg_KasMsk'.There are 0 rows in 0 pages for object 'Htg_KasMsk'.DBCC results for 'TrSO_Biaya'.There are 0 rows in 1 pages for object 'TrSO_Biaya'.DBCC results for 'Ktgr'.There are 2 rows in 1 pages for object 'Ktgr'.DBCC results for 'Htg_R'.There are 3 rows in 1 pages for object 'Htg_R'.DBCC results for 'TrSOJualRet_R'.There are 1 rows in 1 pages for object 'TrSOJualRet_R'.DBCC results for 'Stck'.There are 3 rows in 1 pages for object 'Stck'.DBCC results for 'HtgByr_H'.There are 0 rows in 1 pages for object 'HtgByr_H'.DBCC results for 'HtgByr_KasKlr'.There are 0 rows in 1 pages for object 'HtgByr_KasKlr'.DBCC results for 'HtgByr_R'.There are 0 rows in 1 pages for object 'HtgByr_R'.DBCC results for 'Stck_R'.There are 1 rows in 1 pages for object 'Stck_R'.DBCC results for 'J_H'.There are 29 rows in 1 pages for object 'J_H'.DBCC results for 'J_R'.There are 134 rows in 2 pages for object 'J_R'.DBCC results for 'PAJAK'.There are 2 rows in 1 pages for object 'PAJAK'.DBCC results for 'KasKlr'.There are 7 rows in 1 pages for object 'KasKlr'.DBCC results for 'TrPOBeli_R'.There are 2 rows in 1 pages for object 'TrPOBeli_R'.DBCC results for 'FKrm'.There are 1 rows in 1 pages for object 'FKrm'.DBCC results for 'KasKlrCair'.There are 0 rows in 0 pages for object 'KasKlrCair'.DBCC results for 'KasKlrDebet'.There are 1 rows in 1 pages for object 'KasKlrDebet'.DBCC results for 'KasKlrKredit'.There are 7 rows in 1 pages for object 'KasKlrKredit'.DBCC results for 'TrSOBatal_R'.There are 0 rows in 1 pages for object 'TrSOBatal_R'.DBCC results for 'KasMsk'.There are 9 rows in 1 pages for object 'KasMsk'.DBCC results for 'KasMskCair'.There are 0 rows in 0 pages for object 'KasMskCair'.DBCC results for 'TrStckMsk_H'.There are 0 rows in 1 pages for object 'TrStckMsk_H'.DBCC results for 'KasMskDebet'.There are 9 rows in 1 pages for object 'KasMskDebet'.DBCC results for 'TrStckPdh_R'.There are 1 rows in 1 pages for object 'TrStckPdh_R'.DBCC results for 'KasMskKredit'.There are 11 rows in 1 pages for object 'KasMskKredit'.DBCC results for 'TrPOBeli_H'.There are 2 rows in 1 pages for object 'TrPOBeli_H'.DBCC results for 'PdhBuku_H'.There are 2 rows in 1 pages for object 'PdhBuku_H'.DBCC results for 'StckKlr_Temp'.There are 0 rows in 1 pages for object 'StckKlr_Temp'.DBCC results for 'PdhBuku_R'.There are 2 rows in 1 pages for object 'PdhBuku_R'.DBCC results for 'StckMsk_Temp'.There are 0 rows in 1 pages for object 'StckMsk_Temp'.DBCC results for 'TrStckKlr_H'.There are 0 rows in 1 pages for object 'TrStckKlr_H'.DBCC results for 'TrStckAdj_R'.There are 1 rows in 1 pages for object 'TrStckAdj_R'.DBCC results for 'TrStckKlr_R'.There are 0 rows in 1 pages for object 'TrStckKlr_R'.DBCC results for 'Penerimaan'.There are 2 rows in 1 pages for object 'Penerimaan'.DBCC results for 'PenerimaanDetail'.There are 2 rows in 1 pages for object 'PenerimaanDetail'.DBCC results for 'TrStckPdh_H'.There are 1 rows in 1 pages for object 'TrStckPdh_H'.DBCC results for 'Pengeluaran'.There are 1 rows in 1 pages for object 'Pengeluaran'.DBCC results for 'TrPOBeli_Byr'.There are 2 rows in 1 pages for object 'TrPOBeli_Byr'.DBCC results for 'PengeluaranDetail'.There are 1 rows in 1 pages for object 'PengeluaranDetail'.DBCC results for 'TrStckAdj_H'.There are 1 rows in 1 pages for object 'TrStckAdj_H'.DBCC results for 'TrPOBeli_Biaya'.There are 1 rows in 1 pages for object 'TrPOBeli_Biaya'.DBCC results for 'TrSOJual_H'.There are 3 rows in 1 pages for object 'TrSOJual_H'.DBCC results for 'Piutg_H'.There are 10 rows in 1 pages for object 'Piutg_H'.DBCC results for 'Pinjaman_H'.There are 4 rows in 1 pages for object 'Pinjaman_H'.DBCC results for 'Piutg_KasKlr'.There are 0 rows in 0 pages for object 'Piutg_KasKlr'.DBCC results for 'Piutg_R'.There are 59 rows in 2 pages for object 'Piutg_R'.DBCC results for 'TrPO_H'.There are 1 rows in 1 pages for object 'TrPO_H'.DBCC results for 'Pinjaman_KasKlr'.There are 3 rows in 1 pages for object 'Pinjaman_KasKlr'.DBCC results for 'PiutgHtg_R'.There are 62 rows in 2 pages for object 'PiutgHtg_R'.DBCC results for 'Pinjaman_R'.There are 53 rows in 2 pages for object 'Pinjaman_R'.DBCC results for 'PiutgTerima_H'.There are 5 rows in 1 pages for object 'PiutgTerima_H'.DBCC results for 'PiutgTerima_KasMsk'.There are 5 rows in 1 pages for object 'PiutgTerima_KasMsk'.DBCC results for 'PiutgTerima_R'.There are 10 rows in 1 pages for object 'PiutgTerima_R'.DBCC results for 'Dept'.There are 6 rows in 1 pages for object 'Dept'.DBCC results for 'TrSO_H'.There are 1 rows in 1 pages for object 'TrSO_H'.DBCC results for 'WILYH'.There are 1 rows in 1 pages for object 'WILYH'.DBCC results for 'TrSOJual_Biaya'.There are 0 rows in 1 pages for object 'TrSOJual_Biaya'.DBCC results for 'StckKlr'.There are 7 rows in 1 pages for object 'StckKlr'.DBCC results for 'TrSOJual_Terima'.There are 3 rows in 1 pages for object 'TrSOJual_Terima'.DBCC results for 'AType'.There are 30 rows in 1 pages for object 'AType'.DBCC results for 'StckMsk'.There are 6 rows in 1 pages for object 'StckMsk'.DBCC results for 'COA'.There are 128 rows in 3 pages for object 'COA'.DBCC results for 'TrPOBeliRet_H'.There are 2 rows in 1 pages for object 'TrPOBeliRet_H'.DBCC results for 'TrSOBatal_H'.There are 0 rows in 1 pages for object 'TrSOBatal_H'.DBCC results for 'FA'.There are 1 rows in 1 pages for object 'FA'.DBCC results for 'TrStckMsk_R'.There are 0 rows in 0 pages for object 'TrStckMsk_R'.DBCC results for 'TrPO_R'.There are 1 rows in 1 pages for object 'TrPO_R'.DBCC results for 'BCASHType'.There are 2 rows in 1 pages for object 'BCASHType'.DBCC results for 'FA_R'.There are 120 rows in 2 pages for object 'FA_R'.CHECKDB found 0 allocation errors and 4 consistency errors in database 'dbIntegrated_BNI_WOEn'.CHECKDB fixed 0 allocation errors and 3 consistency errors in database 'dbIntegrated_BNI_WOEn'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (dbIntegrated_BNI_WOEn repair_rebuild).DBCC execution completed. If DBCC printed error messages, contact your system administrator.I'm nothing just gonna being |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-15 : 02:27:10
|
| do you have a backup?how big (in MB or GB) is the database? |
|
|
|
|
|
|
|
|
Connection Broken