>Is there an easy way to print or export a data structure/dictionary from a SQL Server 2000 database? I can create a data diagram, but I have 41 tables and just laying everything out is a pain. Does anyone know of a simple routine to create list of tables, fields, descriptions, etc.?
>
>Thanks,
>Doug

Visio has a tool called the "Map Database Wizard" that is very good at creating a database diagram given an ODBC DSN to your SQL Server database. Other than a third-party tool the built-in database diagram designer is the simplest.