I actually found your post while searching the archives for the same material. What I came up with is the following information that I'll be using to document the many databases I have to take responsibility over. Believe me, I'm no happy camper for having to do this kind of stuff and would rather pistol-whip those before me, but hey, what a learning experience it will be!
Tools:
http://www.winnershtriangle.com
MS Best Practices Analyzer for 2000, 2005, 2008
MS Visio using reverse engineering process
SQLServerCentral Topic/Article Titles:
- Documenting SQL Server 2000
- Document Your Database
- Documenting Stored Procedures
- Documenting Several SQL Server DBs
- How to Document SQL Server
All the above gave me a good start and the tools I found here and other places do soooo much of the work for me that I know I'll be up and running with documentation in no time. Hope I've helped!