Reverse engineering database schema into ERD tool

N2IT

Anyone know of a tool set that connects to SQL server that can display the graphical representation of the indexes, relationships, views, etc. I know Visio can do this through an ODBC connection but I hear it's pretty weak. I am going to build a concept database in Access and try to link it to Visio, but with all that said........ Are there tools that can provide this? I am sure there are just like to bounce this off of the forum.