"Gail Erickson [MS]" <ga***@online.microsoft.com> wrote in message
news:OzmXjRbqFHA.3304@TK2MSFTNGP11.phx.gbl...
> Hi Ned,
>
> It sounds like the name value was set to something other than Description
> or MS_Description.  You can get the current value for the Name property by
> executing this statement:
>
> USE <db_name>;
> GO
> SELECT objtype, objname, name, value
> FROM fn_listextendedproperty (NULL, 'schema', 'dbo', 'table',
> 'activity_code', 'column', 'activity_code_key');
>
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Ned" <ned.radeno***@medshare.com> wrote in message
> news:umOksEbqFHA.2596@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> I am trying to update the extended property description for a column
>> using the  sp_updateextendedproperty.  However, I am not sure what to
>> pass to the @name parameter.
>>
>> I have tried 'Description' and 'MS_Description' but neither works.  The
>> schema is dbo, table name is activity_code and the column name =
>> activity_code_key.
>>
>> EXEC sp_updateextendedproperty
>> @Name = N'MS_Description', @value = 'Primary key of the activity_code
>> table.',
>> @level0type = N'Schema', @level0name = dbo,
>> @level1type = N'Table',  @level1name = activity_code,
>> @level2type = N'Column', @level2name = activity_code_key
>>
>>
>> Any help would be appeciated.
>>
>> Regards,
>>
>> Ned
>>
>
>