Hi,

Does anyone know how to print database and table information from the SQL 2000 system tables?

I have had a Fun time learning about the systems tables and can now query sysobjets, syscolumns and systypes to get basic info on tables. I have also used sp_help. However I am trying to find where the table column and database descriptions are stored.

No doubt, someone has written a stored procedure that will gather basic DB info suitable for documentation reporting!

Thank for any help,

Terry Carroll