SQL 2005 - Disappearing Relationships in DB Diagram

[mark.szretter]

Relationships between tables disappear without explanation in the
database diagram using SQL Server 2005.

Many thanks for any thoughts/questions on the topic!

[David Portas]

ma***********@gmail.com wrote:

Relationships between tables disappear without explanation in the
database diagram using SQL Server 2005.

Many thanks for any thoughts/questions on the topic!

More significantly, are the foreign key constraints really disappearing
or are you just seeing a bug with the UI? Check the constraints.

Can you describe any steps to reproduce the error? You can report a bug
at the feedback centre:
http://connect.microsoft.com/site/si...aspx?SiteID=68

Personally I wouldn't touch the diagram tool for anything. It's
certainly no good place to make changes to tables and keys.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

[Erland Sommarskog]

(ma***********@gmail.com) writes:

Relationships between tables disappear without explanation in the
database diagram using SQL Server 2005.

Many thanks for any thoughts/questions on the topic!

If you press save for some table changes that fails half way, you can
indeed lose constraints and foreign keys. There are several severe bugs
with the Table Designer in Mgmt Studio. If you ever use it to develop
changes, never press Save, but always generate change scripts and
review these carefully.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[wtijsma]

If you press save for some table changes that fails half way, you can
indeed lose constraints and foreign keys. There are several severe bugs
with the Table Designer in Mgmt Studio. If you ever use it to develop
changes, never press Save, but always generate change scripts and
review these carefully.

Hi Erland,

Is there a MSDN KB article for this as far as you are concerned? I couln'd find it...

Thanks for the confirmation...

Wiebe Tijsma / MCSD
http://www.e-office.com