FIX: Existing Fill Factor Changed w/ Rebuild of Clustered Index (165560)
The information in this article applies to:
This article was previously published under Q165560
BUG #: 16418 (6.5)
SYMPTOMS
After rebuilding the clustered index, Sysindexes.OrigFillFactor for all the
existing non-clustered indexes on a table gets overwritten to that of the
clustered index OrigFillFactor value.
This happens only when the index is rebuilt using the "DBCC DBREINDEX"
routine.
WORKAROUND
When rebuilding the clustered index, avoid using DBCC DBREINDEX, and
instead use the ANSI SQL commands DROP INDEX and CREATE INDEX.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 3 for
Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix KB165560 |
|---|
|