469,106 Members | 2,289 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

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
Jul 23 '05 #1
4 1233
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
--

Jul 23 '05 #2
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
Jul 23 '05 #3
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
Jul 23 '05 #4
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.


Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by sams | last post: by
2 posts views Thread by Irlan agous | last post: by
14 posts views Thread by santosh | last post: by
2 posts views Thread by Someonekicked | last post: by
5 posts views Thread by Maulin Vasavada | last post: by
6 posts views Thread by Paul McGuire | last post: by
4 posts views Thread by Ole Nielsby | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.