Posted by Erland Sommarskog on 06/20/06 22:30

(mark.szretter@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: encryption in sql server 2005
• Prev in forum: Re: Error: 16954, Severity: 10, State: 1 and Timeout problem
• Thread view: Re: SQL 2005 - Disappearing Relationships in DB Diagram

[Reply to this message]