FIX: Scripts for Indexes on 16 Cols Contain Extra Characters

• Microsoft SQL Server, version 6.0

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.