Microsoft KB Archive/165560

= FIX: Existing Fill Factor Changed w/ Rebuild of Clustered Index =

Article ID: 165560

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Keywords: kbbug kbfix KB165560

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.