Lesson Learned #308:Extended properties are not permitted on 'dbo.xyz', or the object does not exist

[Guest Jose_Manuel_Jurado]

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!

 

Continue reading...