Lost My Diagrams

[Tom Loach]

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

[David Portas]

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
--

[Tom Loach]

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

[Dimitri Furman]

On Apr 20 2005, 02:10 pm, Tom Loach <tc***@virginia.edu> wrote in
news:rk********************************@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

[Tom Loach]

Dimitri,
Your the Man! Thanks for the help.

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

On Apr 20 2005, 02:10 pm, Tom Loach <tc***@virginia.edu> wrote in
news:rk********************************@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.