Snapping to Grid in SQL Server 2000 diagrams

2 Mar 2007 7:03 AM

Andrew Hilton

Somehow, somewhere, at some point I managed to changed the 'snapping to
grid' behaviour of SQL server 2000 diagrams. When a relationship is moved
the line often splits and I can not align it back up perfectly again.

All my old diagrams look nice and neet, all the new ones look misaligned.
What have I done?

2 Mar 2007 4:43 PM

Ed Murphy

Andrew Hilton wrote:

> Somehow, somewhere, at some point I managed to changed the 'snapping to
> grid' behaviour of SQL server 2000 diagrams. When a relationship is moved
> the line often splits and I can not align it back up perfectly again.
>
> All my old diagrams look nice and neet, all the new ones look misaligned.
> What have I done?

What does "Arrange Tables" do?

6 Mar 2007 3:40 AM

Aaron Bertrand [SQL Server MVP]

> Somehow, somewhere, at some point I managed to changed the 'snapping to
> grid' behaviour of SQL server 2000 diagrams. When a relationship is moved
> the line often splits and I can not align it back up perfectly again.

Do you have Visio? It has some annoying quirks too but I find it a little
more powerful than database diagrams. Plus, I can save a Visio diagram from
a live connection and then open it offline, and I don't have to worry about
changes I make affecting the live database. With diagrams you have to be
very careful to not forget what you have changed... $0.02.

--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006