|
Home > Archive > Microsoft SQL Server forum > April 2005 > Lost My Diagrams
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]
|
|
| Tom Loach 2005-04-20, 9:23 am |
| 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 2005-04-20, 9:23 am |
| 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 2005-04-20, 1:23 pm |
| 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 2005-04-20, 8:23 pm |
| 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
| |
| Tom Loach 2005-04-21, 7:23 am |
| 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.
|
|
|
|
|