>>>>>>Hi,
>>>>>>
>>>>>>I am looking for practical suggestion to whether it is worthwhile to create an external document (e.g. Word) for documenting SQL Server database? Or creating a script of the DB should be sufficient for someone to review (if necessary) what is in the database? If you are using an approach of external file documentation, what specific parts of the database do you document?
>>>>>>
>>>>>>TIA.
>>>>>
>>>>>The most useful document for me is the database diagram. SQL Server produces a pretty good one in the Database Diagram node.
>>>>
>>>>Thank you. I will see how it works on my database.
>>>
>>>I second the recommendation. (You know how Bill and I always agree <g>). It does exactly what you would expect -- one box per table, with the fields listed and relations between tables indicated. AFAIK it does not show rules, triggers, and that kind of thing.
>>
>>Thank you for your input. Documenting rules and constraints is important to me.
>
>I am looking at SQL Server 2008, which is what we use at work. Database Diagrams offer the ability to add text annotations anywhere you like. That would be manual, of course, but you could do it. I don't see any way to have rules and constraints shown automatically by the tool.

I am reading reviews of a couple of documenting tools. So far, solely based on the review and screen shots, I like DB Documentor from Elzaris Technologies but their site is under construction now and I can't get the eval version.