FIX: Scripts for Indexes on 16 Cols Contain Extra Characters

ID: Q142455


The information in this article applies to:
  • Microsoft SQL Server version 6.0

BUG# NT: 11337 (6.00)

SYMPTOMS

SQL Enterprise Manager adds extraneous characters at the end of the create index statement when the scripts are generated on tables with more than one index and one of the indexes being created on 16 columns.


WORKAROUND

Generate scripts for indexes and manually remove the extraneous characters.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server Version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.


MORE INFORMATION

Generating SQL Scripts on a table with more than one index and one index having 16 columns adds extraneous characters to the create index statement generated. Typically, an index name is added, followed by a few non- printable characters. Sometimes, the non-printable characters are not present. This problem occurs even if there is only one user-defined index and there are Primary Key constraints, which are enforced using indexes.

Additional query words: sql6 sem winnt

Keywords : kbtool SSrvEntMan kbbug6.00 kbfix6.00.sp3
Version : 6.0
Platform : WINDOWS
Issue type :


Last Reviewed: March 24, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.