I would recommend using a tool such as ERWin, Visible Analyst or XCase. These are CASE tools that allow you to design a database graphically by creating an entity (table), defining its attributes (columns and keys) and then defining relationships between tables. You can then generate the create scripts for all of the objects of the DB from this design. I have used ERWin and Visible Analyst for MS SQL Server and XCase for Visual FoxPro. I do know that XCase has a SQL Server version.

These tools also have reverse engineer capabilities. So if you give it a database name on a server, it should be able to load the entities, attributes, etc. into its data repository, thereby allowing you to document your database. You can also create data diagrams from this repository, thereby giving yourself even better documentation since it is graphical (a picture is worth a thousand words).

HTH