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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-04-22 : 12:02:34
|
| Hi, when I run DBCC CHECKDB then I got the error"CHECKDB found 10189 allocation errors and 1 consistency errors in database 'Company' and also Table error: Extent (1:413416) object ID 1, index ID 2 is beyond the range of this database.BUT then when I run DBCC CHECKTABLE for specific table to find out what table but then I don't see any errors, then what could happend here?Thanks |
|
|
MuadDBA
628 Posts |
Posted - 2002-04-22 : 12:56:31
|
| Are you by any chance rnning checkdb with no_imfomsgs turned on? If so, you won't see a description of which table is having the problems. If not, it should tell you after each table what is wrong with that table.The other possibility is that you are running CHECKDB when the server is not in single-user mode, so as it says in the maunal "Spurious results could occur" |
 |
|
|
vicki
Posting Yak Master
117 Posts |
Posted - 2002-04-22 : 13:05:18
|
| Thanks for your reply,Here the error"Server: Msg 2579, Level 16, State 1, Line 1Table error: Extent (1:412584) object ID 1, index ID 2 is beyond the range of this database."I don't understand what the error mean and what table?Thanks |
|
|
|
|
|
|
DBCC CHECKTABLE