Diagram Pane in SQL Server Enterprise manager doesn't show column names -- sql server clients

raca NO[at]SPAM rogers.com
7/25/2003 7:45:50 PM

Hi all,

When right-clicking on a table in Enterprise Manager 2000 and
selecting Open Table...Return all rows I initially get a Results pane
(which is normal) and when I press toolbar button for Show Diagram
Pane all that I see in that pane is:
* (All Columns) - just one option for that table.

Where are other columns? I checked other databases. They always show
all the columns along with the option I mentioned above. Please help.
I also cannot use the Grid pane (It doesn't let me choose columns).

Thanks

Andrew J. Kelly
7/26/2003 9:02:24 AM

Rad,

I don't know why EM is doing this but why not use Query Analyzer instead?
Since you have SQL 2000 the features in QA are quite nice and with the
object browser you can do lots of things that you only used to be able to do
in EM.

--

Andrew J. Kelly
SQL Server MVP

[quoted text, click to view]

sql server clients : Diagram Pane in SQL Server Enterprise manager doesn't show column names