In SQLServer, how to query for a column's Description text?

In the SQL Server Enterprise Manager, if you open the Design editor for any
table, you can enter some text in a Description field that's saved
somewhere. If you do sp_help on a table with Descriptions on its columns,
it doesn't show them. Is there some way to get access to these field
descriptions through a query? (Nor does it show up through sp_columns.)


.

Relevant Pages

  • merge agent
    ... sql server enterprise manager could not start merge agent ... Prev by Date: ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL-DMO CreateFile error when scripting database
    ... Michael Cheng wrote: ... I understood that you would like to Generate Scripts from SQL Server Enterprise Manager and encounter the error message CreateFile error on '..PRC' in the process of generating it. ...
    (microsoft.public.sqlserver.tools)
  • RE: Refresh after import SS2K
    ... have to shut down your SQL Server Enterprise Manager when you running DTS ... I am not sure why you will have to restart SQL Server Enterprise ... Is there any error messages in Event Log or Error ...
    (microsoft.public.sqlserver.server)
  • RE: Invalid cursor state error when saving table changes
    ... by SQL Server Enterprise Manager. ... anything I misunderstood, please feel free to let me know. ... it is a known issue for us when using SQL Server Enterprise ... Mingqing Cheng ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Database Migration
    ... In the SQL Server Enterprise Manager, select the database that is causing ... Close the SQL Server Enterprise Manager. ... > backup and restore method. ...
    (microsoft.public.sqlserver.server)
Loading