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?
@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';