Error message:
Server: Message 15135, level 16, status 1, process sp_validatepropertyinputs, row 100
The object is invalid. Extension attributes cannot be used on '. my_score_type.mst_typeid', or the object does not exist.
Run the following command (for storing data)
Execute sp_addextendedproperty
'Ms _ description', -- system type (description)
'Category id', -- write Value
'User', -- Object Type
'', -- Object owner
'Table', -- Object Type
'My _ score_type ', -- Object Name
'Column ', -- attribute type
'Mst _ typeid' -- attribute name
the error is the object owner. For example, if you specify the owner (DBO) when designing the powerdesigner11.0 table, the generated SQL object owner is not empty, but DBO.
normal SQL:
execute sp_addextendedproperty 'Ms _ description',
'category id',
'user', 'dbo ', 'table', 'My _ score_type ', 'column', 'mst _ typeid'