Please make sure that you do DBCC checkdb , and make sure there is no
corruption.
Regards,
Rashmi Dave
Microsoft Partner Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
--------------------
| Content-Class: urn:content-classes:message
| Subject: plan rebuild index on SQL 7.0.699
| Date: Sat, 18 May 2002 08:05:08 -0700
| Lines: 14
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcH+fWY5uDLCt3LUSkmV2Fa2yGTqdA==
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TKMSFTNGXA04 10.201.232.163
| Path: cpmsftngxa08!cpmsftngxa07
| Xref: cpmsftngxa08 microsoft.public.sqlserver.server:210594
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| We ran a maintenance plan to rebuild indexes last night
| and now it appears that two indexes did not get rebuilt,
| even though they do show up as existing according to EM.
|
| I checked the rebuild log and it ran fine in 5.5 minutes.
| Our application log says it couldn't find the index in
| sysindexes. Looking at it, I didn't find them either in
| sysindexes. So, I dropped them and rebuilt those two in
| EM. The application started working fine. Now when I
| look at sysindexes. I don't see the two indexes.
|
| Any ideas?
|
| Scott
|
by