FIX: Index Tuning Fails on Unicode Named Tables and Workfile

ID: Q203777

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 53157 (SQLBUG_70)

SYMPTOMS

The Index Tuning Wizard does not work on a table that has a table name defined using Unicode characters (such as Russian characters). Database names and column names defined using Unicode characters do not affect Index Tuning Wizard behavior.

Using a workfile with Unicode named tables to analyze a select statement from the SQL Server Profiler's "Index Tuning Wizard" generates the following error message:

There are no events in the workload. Either the trace file contained no SQL batch or RPC events or the SQL script contained no SQL queries.

When you run "Perform Index Analysis" on a Unicode named table using the SQL Server Query Analyzer you get the following message in the results window:

The query was unparseable for one of the following reasons:
1. The user has selected the wrong database or text of the query selected for analysis is not parseable.
2. The keyword GO was selected for tuning.

WORKAROUND

Use non-Unicode characters to name your tables.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: code page, index tuning wizard

Keywords : SSrvEntMan kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug