 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / December 2005CHECKDB finds consistency errors in table 'sysdepends'
I've tried to follow any kind of tips for the solution og this problem, but I cannot use the repair tools because of the system table "sysdepends". What can I do? The regular integrity check, database and transaction log backups fail every single day! The error, according to CHECKDB is: "CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysdepends' (object ID 12)." Any suggestions? /Angelo Hi Angelo, Open Query Analyzer and try this. ---- USE master GO ALTER DATABASE YourDatabase SET SINGLE_USER GO USE YourDatabase GO DBCC CHECKTABLE('sysdepends',REPAIR_REBUILD ) USE master GO ALTER DATABASE YourDatabase SET MULTI_USER ---- If you don't resolve, ask your question in news:microsoft.public.sqlserver.server ( visto che il tuo nome sembra Italiano puoi chiedere su news:microsoft.public.it.sql ) bye  SignatureGiorgio Rancati [Office Access MVP] > I've tried to follow any kind of tips for the solution og this problem, but > I cannot use the repair tools because of the system table "sysdepends". [quoted text clipped - 9 lines] > > /Angelo Hi Giorgio Grazie per la risposta/Thanks for your reply. Unfortunately I get this as result: Server: Msg 2594, Level 16, State 1, Line 2 Invalid index ID (0) specified. Server: Msg 2511, Level 16, State 1, Line 2 Table error: Object ID 12, Index ID 0. Keys out of order on page (1:304413), slots 27 and 28. DBCC results for 'sysdepends'. Could not repair this error. There are 1158194 rows in 5365 pages for object 'sysdepends'. CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sysdepends' (object ID 12). repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (is4.dbo.sysdepends repair_rebuild). The main problem is "Could not repair this error" anf it worries me a lot. I don't want to try with more "destructive" methods because I'm afraid to lose the 21 Gbyte database. In this case I have to rely on you for the possible solution... Ciao Angelo > Hi Angelo, > [quoted text clipped - 37 lines] >> >> /Angelo The problem is apparently an index on sysdepends (there are two og them: custered and non-clustered). Unfortunately, I cannot drop the indexes because they're system indexes. Some other suggestions? Thanks again /Angelo > Hi Giorgio > [quoted text clipped - 63 lines] >>> >>> /Angelo Hi Angelo, view this Kb ---- HOW TO: Use the sp_fixindex Stored Procedure http://support.microsoft.com/kb/106122/en-us ---- bye SignatureGiorgio Rancati [Office Access MVP] > The problem is apparently an index on sysdepends (there are two og them: > custered and non-clustered). [quoted text clipped - 5 lines] > > /Angelo Giorgio, Great, you're the man! Undocumented Stored Procedure... typical... It actually solved the problem. Grazie infinite, senza il tuo tip non sarei riuscito a trovare quell'articolo da solo! /Angelo > Hi Angelo, > [quoted text clipped - 14 lines] >> >> /Angelo Hi, joel-ange sitbon has invited you to join GreenZap and get $50 WebCash to spend online. Sign up for a FREE GreenZap account and get $50 to spend at hundreds of the world's premier merchants, many of whom are offering incredible upfront discounts. Click on the link below to go to GreenZap and signup! All thanks to joel-ange sitbon. It's Zappening in the GreenZap Storez. http://www.greenzap.com/joel1962 If you do not want to receive these emails in the future click the link below: http://www.greenzap.com/optout_invite.asp > Hi Giorgio > [quoted text clipped - 63 lines] >>> >>> /Angelo Friend, joel-ange sitbon has invited you to join GreenZap and get $50 WebCash to spend online. Sign up for a FREE GreenZap account and get $50 to spend at hundreds of the world's premier merchants, many of whom are offering incredible upfront discounts. Click on the link below to go to GreenZap and signup! All thanks to joel-ange sitbon. It's Zappening in the GreenZap Storez. http://www.greenzap.com/joel1962 If you do not want to receive these emails in the future click the link below: http://www.greenzap.com/optout_invite.asp > Hi Giorgio > [quoted text clipped - 63 lines] >>> >>> /Angelo |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.