Take a look at these SQL Server tools and you will find Documenter. It automatically generates documentation of an entire SQL Server database in a few clicks. Pretty handy and easy-to-use.