Microsoft KB Archive/317009

= BUG: SQL Enterprise Manager Query Designer Table Columns Do Not Display If Database Name Contains a Period =

Article ID: 317009

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q317009



BUG #: 356575 (SHILOH_BUGS)



SYMPTOMS
When you use the Query Designer in SQL Server Enterprise Manager (SEM), the column names from the selected table do not display if the database name contains a period (&quot;.&quot;).



WORKAROUND
Rename the database so that the name does not contain a period.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior

 * 1) Open SQL Server Enterprise Manager.
 * 2) Click to expand your server.
 * 3) Click to expand the Databases folder.
 * 4) Create a new database with a name that contains a period (&quot;.&quot;).
 * 5) Expand the new database.
 * 6) Expand the Tables folder.
 * 7) Right-click a table name, click Open Table, and then click Query.

Additional query words: period dot empty display

Keywords: kbbug kbpending KB317009

-

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

© Microsoft Corporation. All rights reserved.