Using SQL Server 2005 & SSMS.

Hello all,

I have 2 tables that I want to set the "Description" property for each
column with a query. I have 2 other tables that contain all the
column names and the descriptions to be used for each column.

Is there a system table/view that I can use to set column
descriptions?

Thanks for any help anyone can provide,

CTB

CTB (CTBarbarin (AT) msn (DOT) com) writes:
You asked the same question yesterday. My answer is the same: take a look
at sp_addextendedproperty in Books Online. No, I cannot supply any examples
myself, as I've used extended properties.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx