creating documentation

Hi:

When I used SQL 2000 (long time ago) I remember that in the Tools menu, it has an option to create a Full Documentation of all the tables, views, etc used in the database. Know I'm doing a project in SQL 2005 and I want to print that information, but I don't know how. Anyone that can help me?

Thanks,

Johajones

There are several ways to do this, based on what you want to do. You can create a database diagram, you can script items out (one of the best ways) or you could run sp_help against the objects. There are other methods of documenting a database, such as in this set of articles:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=108