|
Home > Archive > MS SQL Server Tools > December 2005 > Unable to view diagrams in Enterprise Manager
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unable to view diagrams in Enterprise Manager
|
|
| David Carr 2005-12-26, 8:23 pm |
| I am having trouble viewing diagrams on a SQL Server through Enterprise
Manager. I created these diagrams a few weeks ago. The names of the
diagrams are visible, however opening the diagram in EM to look at it has
irregular results. The frame of the window is displayed, however none of
the tables are visible, nor are there scroll bars and right clicking doesn't
do anything (i.e. popup menu does not appear).
And yet I am able to create a new diagram and view this just fine.
Cheers,
David
| |
| David Carr 2005-12-26, 8:23 pm |
| Just wanted to post this for others to not have to chance upon the solution
themselves.
The resolution here was the SQL Server service pack level. Running 'SELECT
@@Version' through Query Analyzer on both the remote server (where the
diagrams created 2 weeks prior were not visible) and my local SQL server
(where all is fine) revealed the following differences:
REMOTE:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
LOCAL:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
The difference above being that the remote Windows 2003 Advanced Server (as
identified by NT 5.2) is running SQL Server sp4 and my local system is
running SQL Server sp3. Once I upgraded my local machine, the diagrams were
visible on the remote system as normal. @@Version then returns the same
version identifying the SQL Server version.
So perhaps the remove server was upgraded in the weeks period between
creating the diagrams and viewing them. In any case, this resolved the
problem.
Cheers,
David
"David Carr" < David_Carr@NoSpamCan
ada.Com> wrote in message
news:eMYH56mCGHA.1032@TK2MSFTNGP11.phx.gbl...
> I am having trouble viewing diagrams on a SQL Server through Enterprise
> Manager. I created these diagrams a few weeks ago. The names of the
> diagrams are visible, however opening the diagram in EM to look at it has
> irregular results. The frame of the window is displayed, however none of
> the tables are visible, nor are there scroll bars and right clicking
doesn't
> do anything (i.e. popup menu does not appear).
>
> And yet I am able to create a new diagram and view this just fine.
>
> Cheers,
> David
>
>
|
|
|
|
|