Hi,
I have tryed to get sp_addextendedproperty to work on a number of different servers and databases, but while it does not error it does nothing either. It should show the description in the design description area; but again I ma not getting it like the instructions show on Books Online says.
Any ideas what I could be doing wrong?
Thanks
Preformatted text
EXEC sp_addextendedproperty @name = N'Ms Diceriotion2', @value = 'This is the Miser Account number.', @level0type = N'Schema', @level0name = 'dbo', @level1type = N'Table', @level1name = 'Not In VPData', @level2type = N'Column', @level2name = 'acct_nbr';
GO Preformatted text
I think the only thing different in your version is the @name parameter - could that be it? (capitalisation of some of the other parameters will be an issue if your database is case sensitive)