We use SQL Server 6.5 (7 in a few weeks). I'm looking for a good tool to generate ERDs and overviews of my database tables. Which software can you recommend me for this purpose?
I found Erwin to be a good tool. Someone else in my company uses XCASE and swears by it; however, I've tried it and it seems to be a bit buggy. Some of these tools can also be expensive. If you just have a couple of tables, you might look to do it yourself using Visio or plain old Word.
The version 7 GUI has some simple diagramming tools.