Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  SQL 2008 Diagram Error

Author  Topic  olimpia Starting Member 1 Post Posted - 2011-04-22 : 04:53:34 Hello, need some help in here. For a job project i need to design a relationship diagram of a data base, this data base has like 50 tables. I started creating the diagram without problems (making the foreign key relationship without problems). I have like 75% of the diagram done, but then something weird started to happen, when i continue adding tables to the diagram and makeing realtionships between them an error started to trigger when i try to save the diagram, the error is "Unable to modify table - Timeout expired. The tiemout period elapsed prior to completetion of the operation or the server is not responding", but once i delete the relationship between the new added tables and click save, the diagram was saved without problems. This only occurs when i try to save new tables with relationship between them. I tried with different tables and still got the same error. This is stopping me from finishing the diagram. Can someone tell me what is going on and how can i fix this problem.