Today, we worked on a service request that our customer is implementing DATA SYNC and they got the following error message: "Database re-provisioning failed with the exception 'SqlException Error Code: -2146232060 - SqlError Number:15135, Message: Object is invalid. Extended properties are not permitted on 'dbo.schema_info_dss', or the object does not exist.
This error occurs when the application is calling sys.sp_addextendedproperty and you specify an incorrect schema of the table, for example, dbo (the table schema_info_dss is based on another schema) or simply the table doesn't exist.
Example:
EXEC sys.sp_addextendedproperty
@name = N'Description' , @value = N'', @level0type = N'schema', @level0name = 'dbo', @level1type = N'table', @level1name ='schema_info_dss';
Enjoy!
