Difference between Database Diagrams and Foreign keys creation

Hello!

Which is the difference between Database Diagrams creation and the Foreign keys creation in "New Foreign key" option, in keys folder (inside of any table) pop-up menu?

Both create relations only (in ways different, let us say)?

Thanks! Bye!what do you mean, "in different ways"?|||

Denis Bittencourt Muniz wrote:

Hello!

Which is the difference between Database Diagrams creation and the Foreign keys creation in "New Foreign key" option, in keys folder (inside of any table) pop-up menu?

Both create relations only (in ways different, let us say)?

Thanks! Bye!

hi dennis,

When you create a foreign key in the database diagram. It is also reflected in the database

there's no difference between the two except that you can easily create multiple FK's in the diagram all at the same time

and in the later however you can create more complex FKs such as those which involve two or three keys

regards,

joey

|||Yeah! Thanks Joey!

"what do you mean, "in different ways"? "

"Different ways", normally, in my country (Brazil), it means different modes that realize the same job. You understood?

Hahah I am an brazilian.. and.. my english grammar is not good... xD
-
Bye!

Diagrams SQL Server 2005

Hello,
I am working with the 2005er version.
I am missing the diagrams where I can show the tables and there relation
ships (th old daVinci tools).
Can somebody tell me where they are gone?
Thanks
Michael
Michael Zdarsky
www.zac-it.com
ZAC-IT GmbH
09190-9271010
You should be discussing this in the beta groups for SQL Server 2005. But
since SQL 2005 B2 isn't covered under beta I can say that they diagrams are
not in the version of the beta you are working with. New features, such as
this one, may or may not be added to the final release.
Brian
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:02A8C7FB-11DE-46DF-B592-49A3F1FB6FCE@.microsoft.com...
> Hello,
> I am working with the 2005er version.
> I am missing the diagrams where I can show the tables and there relation
> ships (th old daVinci tools).
> Can somebody tell me where they are gone?
> Thanks
> Michael
> --
> Michael Zdarsky
> www.zac-it.com
> ZAC-IT GmbH
> 09190-9271010
|||http://www.aspfaq.com/sql2005/show.asp?id=6
Please use the SQL Server 2005 newsgroups to discuss SQL Server 2005.
That's what the groups were created for.
http://www.aspfaq.com/sql2005/show.asp?id=1
http://www.aspfaq.com/
(Reverse address to reply.)
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:02A8C7FB-11DE-46DF-B592-49A3F1FB6FCE@.microsoft.com...
> Hello,
> I am working with the 2005er version.
> I am missing the diagrams where I can show the tables and there relation
> ships (th old daVinci tools).
> Can somebody tell me where they are gone?
> Thanks
> Michael
> --
> Michael Zdarsky
> www.zac-it.com
> ZAC-IT GmbH
> 09190-9271010

Diagrams SQL Server 2005

Hello,
I am working with the 2005er version.
I am missing the diagrams where I can show the tables and there relation
ships (th old daVinci tools).
Can somebody tell me where they are gone?
Thanks
Michael
--
Michael Zdarsky
www.zac-it.com
ZAC-IT GmbH
09190-9271010You should be discussing this in the beta groups for SQL Server 2005. But
since SQL 2005 B2 isn't covered under beta I can say that they diagrams are
not in the version of the beta you are working with. New features, such as
this one, may or may not be added to the final release.
--
Brian
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:02A8C7FB-11DE-46DF-B592-49A3F1FB6FCE@.microsoft.com...
> Hello,
> I am working with the 2005er version.
> I am missing the diagrams where I can show the tables and there relation
> ships (th old daVinci tools).
> Can somebody tell me where they are gone?
> Thanks
> Michael
> --
> Michael Zdarsky
> www.zac-it.com
> ZAC-IT GmbH
> 09190-9271010|||http://www.aspfaq.com/sql2005/show.asp?id=6
Please use the SQL Server 2005 newsgroups to discuss SQL Server 2005.
That's what the groups were created for.
http://www.aspfaq.com/sql2005/show.asp?id=1
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Michael Zdarsky" <zdarsky@.zac-it.com.(nospamplease)> wrote in message
news:02A8C7FB-11DE-46DF-B592-49A3F1FB6FCE@.microsoft.com...
> Hello,
> I am working with the 2005er version.
> I am missing the diagrams where I can show the tables and there relation
> ships (th old daVinci tools).
> Can somebody tell me where they are gone?
> Thanks
> Michael
> --
> Michael Zdarsky
> www.zac-it.com
> ZAC-IT GmbH
> 09190-9271010

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows[vbcol=seagreen]
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > HI
> > i have installed VisualStudio Sp6 after this installation when open my
Sql
> > 2000 server Sp3 i can't visualize Diagrams. Any operation on this
windows
> > don't work.
> > I reinstalled Sql Sp3 but don't work.
> > Can help me?
> > Tia Pupo
> >
> >
>

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I can
however create new diagrams which remain visible after closing an re-opening.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert Meiss
I just tried the same thing, and the diagrams opened fine for me.
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I can
however create new diagrams which remain visible after closing an re-opening.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert MeissI just tried the same thing, and the diagrams opened fine for me.
--
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I ca
n
however create new diagrams which remain visible after closing an re-opening
.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert MeissI just tried the same thing, and the diagrams opened fine for me.
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagrams not showing relationships

I am trying to create a picture of my DB and a few tables
and how they relate. I have picked them, and gone through
the Diagram wizard, but am not able to see the
relationship labels. I am clicking 'Show relationship
labels', but nothing is displaying. Any help would be
appreciated. Thanks!!
Hi,
Does the underlying tables have primary key-foreign key relationships?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"BMS" <anonymous@.discussions.microsoft.com> wrote in message
news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
> I am trying to create a picture of my DB and a few tables
> and how they relate. I have picked them, and gone through
> the Diagram wizard, but am not able to see the
> relationship labels. I am clicking 'Show relationship
> labels', but nothing is displaying. Any help would be
> appreciated. Thanks!!
|||They should, I know of 2 tables that relate by
order_number, but they don't show the relationship.
>--Original Message--
>Hi,
>Does the underlying tables have primary key-foreign key
relationships?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"BMS" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
tables[vbcol=seagreen]
through
>
>.
>

Diagrams not showing relationships

I am trying to create a picture of my DB and a few tables
and how they relate. I have picked them, and gone through
the Diagram wizard, but am not able to see the
relationship labels. I am clicking 'Show relationship
labels', but nothing is displaying. Any help would be
appreciated. Thanks!!Hi,
Does the underlying tables have primary key-foreign key relationships?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"BMS" <anonymous@.discussions.microsoft.com> wrote in message
news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
> I am trying to create a picture of my DB and a few tables
> and how they relate. I have picked them, and gone through
> the Diagram wizard, but am not able to see the
> relationship labels. I am clicking 'Show relationship
> labels', but nothing is displaying. Any help would be
> appreciated. Thanks!!|||They should, I know of 2 tables that relate by
order_number, but they don't show the relationship.
>--Original Message--
>Hi,
>Does the underlying tables have primary key-foreign key
relationships?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"BMS" <anonymous@.discussions.microsoft.com> wrote in
message
>news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
tables[vbcol=seagreen]
through[vbcol=seagreen]
>
>.
>

Diagrams not showing relationships

I am trying to create a picture of my DB and a few tables
and how they relate. I have picked them, and gone through
the Diagram wizard, but am not able to see the
relationship labels. I am clicking 'Show relationship
labels', but nothing is displaying. Any help would be
appreciated. Thanks!!Hi,
Does the underlying tables have primary key-foreign key relationships?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"BMS" <anonymous@.discussions.microsoft.com> wrote in message
news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
> I am trying to create a picture of my DB and a few tables
> and how they relate. I have picked them, and gone through
> the Diagram wizard, but am not able to see the
> relationship labels. I am clicking 'Show relationship
> labels', but nothing is displaying. Any help would be
> appreciated. Thanks!!|||They should, I know of 2 tables that relate by
order_number, but they don't show the relationship.
>--Original Message--
>Hi,
>Does the underlying tables have primary key-foreign key
relationships?
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"BMS" <anonymous@.discussions.microsoft.com> wrote in
message
>news:494f01c42bd7$dba05f60$a101280a@.phx.gbl...
>> I am trying to create a picture of my DB and a few
tables
>> and how they relate. I have picked them, and gone
through
>> the Diagram wizard, but am not able to see the
>> relationship labels. I am clicking 'Show relationship
>> labels', but nothing is displaying. Any help would be
>> appreciated. Thanks!!
>
>.
>

Diagrams not appearing in Enterprise Manager

Hi
I can create new diagrams and view them but cannot open exesting diagrams.
Anon

Quote:

Originally posted by ANON
Hi
I can create new diagrams and view them but cannot open exesting diagrams.
Anon

I found an answer. I had the same problem and uninstalled and re-installed SQL serveral times.
Apparently my issue was related to Visual Studio SP6. I didn't make the connection, but I saw others discussing this on another site.
The issue is with a file called mdt2df.dll. Replace this file with another version. The one that is in the C:\Program Files\Common Files\Microsoft Shared\MSDesigners98 was the one that my system was using. I found an older version in C:\Program Files\Microsoft Office2K\ODETools\V9\Runtime\FULL\PFILES\COMMON\MS SHARED\MSDESIGN. The older version worked.
Good luck!
Jeff|||Thank you for sharing! It saved my day!
/Bard

Diagrams NOT appearing in Enterprise Manager

Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON

Quote:

Originally posted by ANON
Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON

Were you able to figure this out? I am having the EXACT same problem.
Any help would be greatly appreciated.
Thanks,
Jeff

Diagrams manipulation

Hello, working on SQL2000.
I want to know if the diagrams can be exported to a format that can be
later imported to another database.
I also want to know if importing a diagram to a database, changes the
indexes, FK, etc or has nothing to do with it.
Thanks in advanceYou can certainly move the diagrams to another server
HOW TO: Move a Database Diagram
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Guillermo Casta?o A" <guillermoc74@.hotmail.com> wrote in message
news:9350d78d.0401070611.ce11d86@.posting.google.com...
> Hello, working on SQL2000.
> I want to know if the diagrams can be exported to a format that can be
> later imported to another database.
> I also want to know if importing a diagram to a database, changes the
> indexes, FK, etc or has nothing to do with it.
> Thanks in advance

diagrams in sql server 2005

is there a tool to make diagrams in sql server 2005?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You should discuss SQL2005 in the appropriate newsgroups for the beta...
That feature is currently not in B2.
(P.S. features in B2 are not considered NDA at this time)
Brian
"alex" <anonymous@.devdex.com> wrote in message
news:%23MziLZQgEHA.236@.tk2msftngp13.phx.gbl...
> is there a tool to make diagrams in sql server 2005?
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

diagrams in sql server 2005

is there a tool to make diagrams in sql server 2005?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!You should discuss SQL2005 in the appropriate newsgroups for the beta...
That feature is currently not in B2.
(P.S. features in B2 are not considered NDA at this time)
--
Brian
"alex" <anonymous@.devdex.com> wrote in message
news:%23MziLZQgEHA.236@.tk2msftngp13.phx.gbl...
> is there a tool to make diagrams in sql server 2005?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Diagrams disappearing in SQL 2000

We appear to have a problem with our diagrams in SQL 2000 Enterprise
manager - The diagrams either disappear so that when you click them there is
nothing to view or alternatively the tables show with no fields. This
problem doesn't affect all diagrams, but a large proportion of them.
Any ideas ?
Hi
Have you installed SP3a on the server AND the client machines that have
Enterprise Manager Installed.
I have seen this when the 2 are out of sync.
Regards
Mike
"Andy Reilly" wrote:

> We appear to have a problem with our diagrams in SQL 2000 Enterprise
> manager - The diagrams either disappear so that when you click them there is
> nothing to view or alternatively the tables show with no fields. This
> problem doesn't affect all diagrams, but a large proportion of them.
> Any ideas ?
>
>