Microsoft KB Archive/142455

{|
 * width="100%"|

FIX: Scripts for Indexes on 16 Cols Contain Extra Characters

 * }

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

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600