table column comments SQL Server 2000

[TStradli]

How do I create or add them with/to a table in SQL Server 2000?

[MAK]

If you are in EM, go to design table and when you click on a column you can add description at the bottom.

If you like to view all the descriptions execute the following command.
select object_name(id), name from sysproperties

[rmiao]

Or add column comments with sp_addextendedproperty, and view them with fn_listextendedproperty.