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 |
|
suba anand
Starting Member
5 Posts |
 Posted - 2010-07-12 : 04:26:21
|
| Hello,I see that few of the indexes in my database are not having an corresponding entry in sysobjects. can i know the reason why?thankssuba |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-12 : 04:39:56
|
SQL 2000? Typically means that someone's been messing around with the system tables, making direct updates without understanding the consequences of what they're doing.Please run the following and post the full and complete results.DBCC CheckDB (<Database Name>) WITH No_INFOMSGS, ALL_ERRORMSGSDBCC CheckCatalog (<Database Name>) WITH No_INFOMSGS --Gail ShawSQL Server MVP |
 |
|
|
|
|
|
index not found in sysobjects