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

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


Show quoteHide quote

DBCC CHECKIDENT call never returns
Problem with Maintenance Plan to delete files older than 2 days
Activity Monitor: SQL 2005
SQL Server Management Studio - mscorlib.tlb could not be loaded
SQL Management Studio keeps giving errors