Re: SQL 2005 - Disappearing Relationships in DB Diagram

mark.szretter@xxxxxxxxx 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
--

.

Relevant Pages

  • Re: Creating relationships between different databases
    ... integrity is not supported in SQL Server. ... "FOREIGN KEY constraints can reference only tables within the same database on the same ... See following topic in bol. ...
    (microsoft.public.sqlserver.msde)
  • SQL Server Update in place
    ... We are experiencing a replication problem and it appears to be stemming from ... SQL Server turning updates into deletes and then inserts. ... there are any foreign key constraints against the data this will surely fail. ...
    (microsoft.public.sqlserver.replication)
  • RE: Architecture SQL,Datasets and relationships
    ... Now, if you are inserting a new customer it works fine, but if you are deleting a customer you need to invert the order of the update method calls. ... I had similar problem about a week ago and I had to disable the foreign key constraints in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: foreign key constraints between tables in different databases
    ... SQL Server MVP ... Columnist, SQL Server Professional ... "Bob" wrote in message ... Is is possible to have foreign key constraints between tables in different ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Adaptor - Timeout
    ... I have changed the host 'Max. number of message engine threads per CPU. ... to be 3 instead of 20 and I have the same error messages. ... Server stored procedures using SQL Server Adaptor. ...
    (microsoft.public.biztalk.general)