Lost My Diagrams

I'm using SQL Server 2000 and yesterday I seem to have lost my
diagrams.  Not the diagram icons themselves, but the data diagrams you
see when you double click the icon.
I tried reinstallling Enterprise manager, unregistereing and
registering the database without success.
Any help appreciated.

Thanks,
Tom

Diagrams are stored in the DTPROPERTIES table in your database so it
should be possible to recover them by restoring from a backup. If you
don't want to overwrite your database then restore it elsewhere and
copy the contents of DTPROPERTIES:
http://support.microsoft.com/kb/320125/EN-US/

--
David Portas
SQL Server MVP
--

David,
Thank you for your response.  I'm sorry I didn't mention it, but
my DBA can see all the data  diagrams, which to me means it has to be
something local.  He gave me SA privlidges and still nothing.
Like I said, I uninstalled and reinstalled Enterprise manager
without success.
Any other idea appreciated.

Regards,
Tom

On Apr 20 2005, 02:10 pm, Tom Loach <tcl4p@virginia.edu> wrote in
 news:rk6d615gfqif3sq
 2ia655vkt35jeiled0q@
4ax.com:

> David,
>     Thank you for your response.  I'm sorry I didn't mention it, but
> my DBA can see all the data  diagrams, which to me means it has to be
> something local.  He gave me SA privlidges and still nothing.
>    Like I said, I uninstalled and reinstalled Enterprise manager
> without success.
>    Any other idea appreciated.

I've seen this happen after installing Visual Studio 6.0 SP3 on the same
machine where Enterprise Manager was installed. It was caused by a newer
version of a certain DLL. I don't remember all details now, but either on
MS support site, or in newsgroup archives, there are some pointers on how
to fix this. If you can't find anything, post back and I'll try to look it
up.

--
remove a 9 to reply by email

Dimitri,
Your the Man!  Thanks for the help.

Tom
On Thu, 21 Apr 2005 00:43:32 -0000, Dimitri Furman
<dfurman@cloud99.net> wrote:

>On Apr 20 2005, 02:10 pm, Tom Loach <tcl4p@virginia.edu> wrote in
> news:rk6d615gfqif3sq
 2ia655vkt35jeiled0q@
4ax.com:
> 
>
>I've seen this happen after installing Visual Studio 6.0 SP3 on the same
>machine where Enterprise Manager was installed. It was caused by a newer
>version of a certain DLL. I don't remember all details now, but either on
>MS support site, or in newsgroup archives, there are some pointers on how
>to fix this. If you can't find anything, post back and I'll try to look it
>up.