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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
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 (".").

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.

MORE INFORMATION

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 (".").
  5. Expand the new database.
  6. Expand the Tables folder.
  7. Right-click a table name, click Open Table, and then click Query.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbpending KB317009
©2003 Microsoft Corporation. All rights reserved.