Posted by David Portas on 06/20/06 18:33

mark.szretter@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/sitehome.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/ms130214(en-US,SQL.90).aspx
--

• Next in forum: SQL 2005: creating "correct" and "incorrect" versions of a database
• Prev in forum: encryption in sql server 2005
• Thread view: Re: SQL 2005 - Disappearing Relationships in DB Diagram

[Reply to this message]