Diagram Editor in SQL Server Management Studio

Hi,

I was playing with the diagram editor and I was wondering if that was a component available for other developers to use. We're using a similar control for our product, but that control is pretty slow and a little dumb, it displays overlapped tables and doesn't have the "arrange tables" feature that I really like in the Sql Server Management Studio.

So my question is, how could we get this control, is it available for purchase? Any suggestions to similar available controls? Basically, we need a diagram editor in which the objects and the relations are selectable.

Any help would be highly appreciated.

Thanks, Florin

That is a part of client tools to be installed and cannot be seperated as a component.

Diagram Editor doesn't work in SQLServer 2000

Hi,
All of a sudden the other day my diagram editor stopped working. I really rely on and can't figure out what happened. Everything else works fine. Since the problem started, I installed SP3 and it didn't help. I'm using a 60 day eval version of SQLS
erver which may have something to do with it (I have one licensed copy that I will install on another machine and am ordering another copy at the moment). Anyways, any ideas?
tdk
tdk,
Did you install VB6 SP6? If so you overwrote the working version of
mdt2df.dll. You will need to restore this dll and register it from before
the update. If you didn't you can try installing an older version of
mdt2df.dll.
-Sam Matzen
"tdk" <tdk@.discussions.microsoft.com> wrote in message
news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> Hi,
> All of a sudden the other day my diagram editor stopped working. I
really rely on and can't figure out what happened. Everything else works
fine. Since the problem started, I installed SP3 and it didn't help. I'm
using a 60 day eval version of SQLServer which may have something to do with
it (I have one licensed copy that I will install on another machine and am
ordering another copy at the moment). Anyways, any ideas?
> tdk
|||I have a similar problem that this causing me all kinds annoyance, in my
case diagrams created in Enterprise Manager are only viewable in EM and
diagrams created though Access (through Access Data Projects) are only
viewable in Access. If I try to view a diagram in one tool that was created
in the other the viewing program crashes. I do have VB6 installed so I
wonder if this is related...any links, additional documentation on this
problem? How would you even know which version of the dll is the proper one
to be compatible with everything?
|||Jon,
All I know is that when I installed VB6 Service Pack 6 it overrode the .dll
and my Enterprise Manager diagrams no longer worked.
I don't think there is any way to view Access diagrams in Enterprise
Manager.
-Sam Matzen
"Jon" <jonremovemewest@.msn.com> wrote in message
news:uL$xg6lcEHA.2384@.TK2MSFTNGP09.phx.gbl...
> I have a similar problem that this causing me all kinds annoyance, in my
> case diagrams created in Enterprise Manager are only viewable in EM and
> diagrams created though Access (through Access Data Projects) are only
> viewable in Access. If I try to view a diagram in one tool that was
created
> in the other the viewing program crashes. I do have VB6 installed so I
> wonder if this is related...any links, additional documentation on this
> problem? How would you even know which version of the dll is the proper
one
> to be compatible with everything?
>
|||Ah ha. I found an older version where I unpacked the SQLServer eval version onto my drive (\dir mdt2df.dll /s
Thanks a bunch for the help Samuel.
Tyson
"Samuel L Matzen" wrote:

> tdk,
> Did you install VB6 SP6? If so you overwrote the working version of
> mdt2df.dll. You will need to restore this dll and register it from before
> the update. If you didn't you can try installing an older version of
> mdt2df.dll.
> -Sam Matzen
>
> "tdk" <tdk@.discussions.microsoft.com> wrote in message
> news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> really rely on and can't figure out what happened. Everything else works
> fine. Since the problem started, I installed SP3 and it didn't help. I'm
> using a 60 day eval version of SQLServer which may have something to do with
> it (I have one licensed copy that I will install on another machine and am
> ordering another copy at the moment). Anyways, any ideas?
>
>
|||Thanks Samuel, I definitely do have VB SP6 on my machine. I am fairly certain it was installed later than SQLServer. The version of MDT2DF.DLL that I have is 2.0.0.9586, which from what I can gather about version updates on the msdn site is a fairly ne
w version. The question is, how do I get an old version of just that dll? Once I have it, I know how to register it (asusming it's a COM dll, regsvr32).
Tyson
"Samuel L Matzen" wrote:

> tdk,
> Did you install VB6 SP6? If so you overwrote the working version of
> mdt2df.dll. You will need to restore this dll and register it from before
> the update. If you didn't you can try installing an older version of
> mdt2df.dll.
> -Sam Matzen
>
> "tdk" <tdk@.discussions.microsoft.com> wrote in message
> news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> really rely on and can't figure out what happened. Everything else works
> fine. Since the problem started, I installed SP3 and it didn't help. I'm
> using a 60 day eval version of SQLServer which may have something to do with
> it (I have one licensed copy that I will install on another machine and am
> ordering another copy at the moment). Anyways, any ideas?
>
>

Diagram Editor doesn't work in SQLServer 2000

Hi,
All of a sudden the other day my diagram editor stopped working. I really rely on and can't figure out what happened. Everything else works fine. Since the problem started, I installed SP3 and it didn't help. I'm using a 60 day eval version of SQLServer which may have something to do with it (I have one licensed copy that I will install on another machine and am ordering another copy at the moment). Anyways, any ideas?
tdktdk,
Did you install VB6 SP6? If so you overwrote the working version of
mdt2df.dll. You will need to restore this dll and register it from before
the update. If you didn't you can try installing an older version of
mdt2df.dll.
-Sam Matzen
"tdk" <tdk@.discussions.microsoft.com> wrote in message
news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> Hi,
> All of a sudden the other day my diagram editor stopped working. I
really rely on and can't figure out what happened. Everything else works
fine. Since the problem started, I installed SP3 and it didn't help. I'm
using a 60 day eval version of SQLServer which may have something to do with
it (I have one licensed copy that I will install on another machine and am
ordering another copy at the moment). Anyways, any ideas?
> tdk|||I have a similar problem that this causing me all kinds annoyance, in my
case diagrams created in Enterprise Manager are only viewable in EM and
diagrams created though Access (through Access Data Projects) are only
viewable in Access. If I try to view a diagram in one tool that was created
in the other the viewing program crashes. I do have VB6 installed so I
wonder if this is related...any links, additional documentation on this
problem? How would you even know which version of the dll is the proper one
to be compatible with everything?|||Jon,
All I know is that when I installed VB6 Service Pack 6 it overrode the .dll
and my Enterprise Manager diagrams no longer worked.
I don't think there is any way to view Access diagrams in Enterprise
Manager.
-Sam Matzen
"Jon" <jonremovemewest@.msn.com> wrote in message
news:uL$xg6lcEHA.2384@.TK2MSFTNGP09.phx.gbl...
> I have a similar problem that this causing me all kinds annoyance, in my
> case diagrams created in Enterprise Manager are only viewable in EM and
> diagrams created though Access (through Access Data Projects) are only
> viewable in Access. If I try to view a diagram in one tool that was
created
> in the other the viewing program crashes. I do have VB6 installed so I
> wonder if this is related...any links, additional documentation on this
> problem? How would you even know which version of the dll is the proper
one
> to be compatible with everything?
>

Diagram Editor doesn't work in SQLServer 2000

Hi,
All of a sudden the other day my diagram editor stopped working. I really r
ely on and can't figure out what happened. Everything else works fine. Sin
ce the problem started, I installed SP3 and it didn't help. I'm using a 60
day eval version of SQLS
erver which may have something to do with it (I have one licensed copy that
I will install on another machine and am ordering another copy at the moment
). Anyways, any ideas?
tdktdk,
Did you install VB6 SP6? If so you overwrote the working version of
mdt2df.dll. You will need to restore this dll and register it from before
the update. If you didn't you can try installing an older version of
mdt2df.dll.
-Sam Matzen
"tdk" <tdk@.discussions.microsoft.com> wrote in message
news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> Hi,
> All of a sudden the other day my diagram editor stopped working. I
really rely on and can't figure out what happened. Everything else works
fine. Since the problem started, I installed SP3 and it didn't help. I'm
using a 60 day eval version of SQLServer which may have something to do with
it (I have one licensed copy that I will install on another machine and am
ordering another copy at the moment). Anyways, any ideas?
> tdk|||I have a similar problem that this causing me all kinds annoyance, in my
case diagrams created in Enterprise Manager are only viewable in EM and
diagrams created though Access (through Access Data Projects) are only
viewable in Access. If I try to view a diagram in one tool that was created
in the other the viewing program crashes. I do have VB6 installed so I
wonder if this is related...any links, additional documentation on this
problem? How would you even know which version of the dll is the proper one
to be compatible with everything?|||Jon,
All I know is that when I installed VB6 Service Pack 6 it overrode the .dll
and my Enterprise Manager diagrams no longer worked.
I don't think there is any way to view Access diagrams in Enterprise
Manager.
-Sam Matzen
"Jon" <jonremovemewest@.msn.com> wrote in message
news:uL$xg6lcEHA.2384@.TK2MSFTNGP09.phx.gbl...
> I have a similar problem that this causing me all kinds annoyance, in my
> case diagrams created in Enterprise Manager are only viewable in EM and
> diagrams created though Access (through Access Data Projects) are only
> viewable in Access. If I try to view a diagram in one tool that was
created
> in the other the viewing program crashes. I do have VB6 installed so I
> wonder if this is related...any links, additional documentation on this
> problem? How would you even know which version of the dll is the proper
one
> to be compatible with everything?
>|||Ah ha. I found an older version where I unpacked the SQLServer eval version
onto my drive (\dir mdt2df.dll /s
Thanks a bunch for the help Samuel.
Tyson
"Samuel L Matzen" wrote:

> tdk,
> Did you install VB6 SP6? If so you overwrote the working version of
> mdt2df.dll. You will need to restore this dll and register it from before
> the update. If you didn't you can try installing an older version of
> mdt2df.dll.
> -Sam Matzen
>
> "tdk" <tdk@.discussions.microsoft.com> wrote in message
> news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> really rely on and can't figure out what happened. Everything else works
> fine. Since the problem started, I installed SP3 and it didn't help. I'm
> using a 60 day eval version of SQLServer which may have something to do wi
th
> it (I have one licensed copy that I will install on another machine and am
> ordering another copy at the moment). Anyways, any ideas?
>
>|||Thanks Samuel, I definitely do have VB SP6 on my machine. I am fairly cert
ain it was installed later than SQLServer. The version of MDT2DF.DLL that I
have is 2.0.0.9586, which from what I can gather about version updates on t
he msdn site is a fairly ne
w version. The question is, how do I get an old version of just that dll?
Once I have it, I know how to register it (asusming it's a COM dll, regsvr32
).
Tyson
"Samuel L Matzen" wrote:

> tdk,
> Did you install VB6 SP6? If so you overwrote the working version of
> mdt2df.dll. You will need to restore this dll and register it from before
> the update. If you didn't you can try installing an older version of
> mdt2df.dll.
> -Sam Matzen
>
> "tdk" <tdk@.discussions.microsoft.com> wrote in message
> news:9340199E-172E-436A-84CA-275B77CDD642@.microsoft.com...
> really rely on and can't figure out what happened. Everything else works
> fine. Since the problem started, I installed SP3 and it didn't help. I'm
> using a 60 day eval version of SQLServer which may have something to do wi
th
> it (I have one licensed copy that I will install on another machine and am
> ordering another copy at the moment). Anyways, any ideas?
>
>

Diagram Editor

Hello,

i just moved over from MS Access to MSSQL.

when trying to save a relation in the Diagram editor
between 2 tables i get this error:

'abbrev' table saved successfully
'companies' table
- Unable to create relationship 'FK_companies_abbrev'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_companies_abbrev'. The conflict occurred in database 'intranet', table 'abbrev', column 'id'.

relation is between companies.id <-> abbrev.company

both are 4 byte INTs.

it works fine with the other 4 tables but not for this last one.

any ideas/clues about what could be wrong?
and is it usefull to use that diagram or should i redo all the relations just in the query editor everytime it's needed?

thanks in advance.

SorexAre they also both "identity" columns?

Make sure that you have set the following properties for these columns in their respective tables...

Identity: YES
Identity Seed: 1
Identity Increment: 1

Also, I would set both of these columns as PRIMARY KEYS in their respective tables, so that they can be relate to each other as FKs.|||>Are they also both "identity" columns?

no, the link is between companies.id & abbrev.company (not abbrev.id)

>Make sure that you have set the following properties for these
> columns in their respective tables...
>Identity: YES
>Identity Seed: 1
>Identity Increment: 1

done this for both ID's of the tables.

i've put a screenshot online to look at what it actually is

should be on http://users.skynet.be/sky81117/sql.gif|||what's the use of the diagram anyway?

when i reopen the things i did yesterday i see the relations but they dissapear when the table content appears.

so it's a waste of time to use this feature or not?|||Originally posted by sorex
what's the use of the diagram anyway?

when i reopen the things i did yesterday i see the relations but they dissapear when the table content appears.

so it's a waste of time to use this feature or not?

The major purpose of the Diagram Editor is providing a visual tool to identify referential integrity within your database. It is the exact same tool as "Relationships" in Access. Yes, you can identify FK constraints by using the "Manage Index" tool for each table, however, I find the Diagram Editor to be quite useful and easy to establish FK constraints and show referential integrity between tables within my database systems.

The major problem with what you have done so far is within your database schema design. When I said that you should have primary key IDs in your tables, I meant that you needed to specify a current column within the tables and make that the PK, not necessary adding another field. Also, your columns are not normalized across the two tables.

Why do you have duplicate Company and contact information columns within each table?

What is the purpose of the abbrev and company tables? How are they supposed to relate to one another?

Diagram Editor

This is a rather weird one if anyone can help.
I create a new diagram on my machine through Enterprise Manager ver 8 then
go to another machine modify the diagram with EM ver 8 and save it. When I
re-open the diagram on my machine there are no tables in it.
Anyone know of any issues relating to this or anything.
Regards
Ian Frawley
Similar issues have been reported by people who have
applied Visual Studio Service Pack 6 - that's a known
issue.
I don't know if there is a knowledge base article or
supported fix for the issue. Others have reported working
around the issue by installing an older version of
mdt2df.dll
-Sue
On Wed, 4 Jan 2006 10:26:00 -0000, "Ian Frawley"
<yeah@.yeah.com> wrote:

>This is a rather weird one if anyone can help.
>I create a new diagram on my machine through Enterprise Manager ver 8 then
>go to another machine modify the diagram with EM ver 8 and save it. When I
>re-open the diagram on my machine there are no tables in it.
>Anyone know of any issues relating to this or anything.

Diagram Editor

This is a rather weird one if anyone can help.
I create a new diagram on my machine through Enterprise Manager ver 8 then
go to another machine modify the diagram with EM ver 8 and save it. When I
re-open the diagram on my machine there are no tables in it.
Anyone know of any issues relating to this or anything.
Regards
Ian Frawley
Hi
I can't say I use the diagramming feature in EM that much as (IMO) it has
always been a bit functionally challenged!
Have you checked that the version of EM is the same on each machine i.e. the
tools have been patched to the same level? You may also want to try and see
that it has not been re-arranged so the tables are still there but off
screen.
John
"Ian Frawley" <yeah@.yeah.com> wrote in message
news:eJMrOlREGHA.3820@.TK2MSFTNGP12.phx.gbl...
> This is a rather weird one if anyone can help.
> I create a new diagram on my machine through Enterprise Manager ver 8 then
> go to another machine modify the diagram with EM ver 8 and save it. When I
> re-open the diagram on my machine there are no tables in it.
> Anyone know of any issues relating to this or anything.
> --
> Regards
> Ian Frawley
>
|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
Thanks for your response, I mainly use the diagram editor as a lazy way of
setting up relationships it has always worked well for me.
I checked EM and they all apear to be the same version (8) but I am unaware
if they have been patched in any way. In addition I tried zooming out, which
makes no difference and I even tried to re add tables and it doesn't allow
me to do this. Its all a bit odd TBH.

> Hi
> I can't say I use the diagramming feature in EM that much as (IMO) it has
> always been a bit functionally challenged!
> Have you checked that the version of EM is the same on each machine i.e.
> the tools have been patched to the same level? You may also want to try
> and see that it has not been re-arranged so the tables are still there but
> off screen.
> John
> "Ian Frawley" <yeah@.yeah.com> wrote in message
> news:eJMrOlREGHA.3820@.TK2MSFTNGP12.phx.gbl...
>
|||Hi
As EM is a MMC there is no version number but you could check one of the exe
such as sqlmangr.exe, right click and check the version number. It does
sounds like the tables are still there if you can't re-add them.
With a bit of practice you may find it quicker to use Query Analyser and the
ALTER TABLE command than go through the process of adding tables and
creating FK constraints.
John
"Ian Frawley" <yeah@.yeah.com> wrote in message
news:%23lqLS6SEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> Thanks for your response, I mainly use the diagram editor as a lazy way of
> setting up relationships it has always worked well for me.
> I checked EM and they all apear to be the same version (8) but I am
> unaware if they have been patched in any way. In addition I tried zooming
> out, which makes no difference and I even tried to re add tables and it
> doesn't allow me to do this. Its all a bit odd TBH.
>
>