Microsoft KB Archive/327056

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

Article ID: 327056

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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-


 * 1) The column names of your view contain one of the following Japanese characters:
 * 2) * 0x815B (or UNICODE 0xFC30)
 * 3) * 0xB0 (or UNICODE 0x70FF)
 * 4) * 0xDE (or UNICODE 0x9EFF)
 * 5) * 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.

Keywords: kbprb kbpending KB327056

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.