Lesson Learned #308:Extended properties are not permitted on 'dbo.xyz', or the object does not exist
Published Jan 27 2023 05:18 PM 815 Views

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!

Version history
Last update:
‎Jan 27 2023 05:18 PM
Updated by: