Red Gate recently published SQL Doc Beta on their forum. This is nice and simple tool for documenting SQL 2000 and 2005 databases can be downloaded here. According to the forum announcement, this beta release includes:

• Document one or many databases;
• Produce documentation in HTML, with or without frames;
• Includes all cross-database dependencies;
• Live preview pane;
• Command line access version.

There are sample results for the Northwind database:

General view: 

Table: 

 View:

Stored procedure: 

If you have any comments or feature request just go to the forum and drop the line.