How can I document tables and fields in SQL Server 2005

Question

I've missed this somehow in my SQL Server learning process.

I'd like to be able to document tables/fields/procedures in our SQL Server 2005 environment, and I can't find a way to do this. Is this possible, or would I need a third party app of some kind?

This sounds like a no-brainer feature, so I'm probably overlooking it.

Thanks!

JH

EDIT: Specifially, I'm talking about documenting SQL objects ('this table is used for blah, and is referenced by foo, and bar.'). Thanks for all the help - you guys nailed it.

Answer 1

SQL Server has Extended Properties that you can use for this purpose.

Answer 2

One of the best documenting tools is called SQL Doc by RedGate software.