I'm having a very annoying problem with diagrams in SQL Server 2000. I've never seen this before and it's only occuring on my machine. I have a diagram of tables with a bunch of relationships. The problem is the alignment seems to be slightly off with the relationship lines. If i drag the relationship to an adjacent edge of a table, i can never get the relationship to snap together so that i eliminate a bend in the line. it LOOKS like it is in alignment, but when i move the line, it's still 2 sections. Also, when I view the diagram on another machine, there is a gap between the key end of the relationship lines and the edge of the table.
I've tried editing in all zooming levels and all resolutions on my machine. I'm confident that it has nothing to do with that. I am running windows server 2003, using sql server 2000, .net 2.0, i have sql server 2005 express installed with .net 2.0 but i don't use it for anything. the database server that i am connecting to is running sql server 2000 only and i'm connecting to it through enterprise manager obviously.
I'm curious if anyone has seen this issue and has any insight. Thanks.
Have you tried removing the relationship line, and then recreating it anew?
Personally, I prefer Visio Pro for database diagrams.
|||yeah i tried that. no luck. However i think i may have resolved this issue. I killed the diagram and re-created it and all seems well right now. not sure what caused this, but it's fixed for now.
No comments:
Post a Comment