PRB: SQL Server Enterprise Manager Inserts Extra Spaces in a View's Column Names (327056)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
This article was previously published under Q327056

SYMPTOMS

When you open a view from the SQL Server Enterprise Manager (SEM) Design View tool, some column names in the SELECT statement of your view may contain spaces before and after certain characters. If this occurs, the column names prevent Enterprise Manager from retrieving the details of your view.

This behavior is known to occur under the following conditions:

  1. Enterprise Manager is running on a computer that is running Microsoft Windows XP. -and-

  2. The column names of your view contain one of the following Japanese characters:
    • 0x815B (or UNICODE 0xFC30)
    • 0xB0 (or UNICODE 0x70FF)
    • 0xDE (or UNICODE 0x9EFF)
    • 0xDF (or UNICODE 0x9FFF)

WORKAROUND

To work around this behavior, after you open your view in SEM, manually modify the SELECT statement of your view. To manually modify the SELECT statement, follow these steps:
  1. Find the column names that contain the spaces in the name.
  2. Manually remove the extra spaces in the column names.
  3. Enclose these column names in square brackets.
  4. Click Run to retrieve the details of the view.
Modification Type:MajorLast Reviewed:10/30/2003
Keywords:kbpending kbprb KB327056
©2003 Microsoft Corporation. All rights reserved.