SQL Server Error Msg 8306 – Use of level0type with value ‘TYPE’ in procedure sp_addextendedproperty, sp_updateextendedproperty and sp_dropextendedproperty and in table-valued function fn_listextendedproperty has been deprecated and will be removed in a future version of SQL Server. Types are now schema scoped and hence use level0type with value ‘SCHEMA’ and level1type with value ‘TYPE’ for extended properties on TYPE.

In this blog post, let’s learn about the error message “8306 – Use of level0type with value ‘TYPE’ in procedure sp_addextendedproperty, sp_updateextendedproperty and sp_dropextendedproperty and in table-valued function fn_listextendedproperty has been deprecated and will be removed in a future version of SQL Server. Types are now schema scoped and hence use level0type with value ‘SCHEMA’ and level1type with value ‘TYPE’ for extended properties on TYPE.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8306 – Use of level0type with value ‘TYPE’ in procedure sp_addextendedproperty, sp_updateextendedproperty and sp_dropextendedproperty and in table-valued function fn_listextendedproperty has been deprecated and will be removed in a future version of SQL Server. Types are now schema scoped and hence use level0type with value ‘SCHEMA’ and level1type with value ‘TYPE’ for extended properties on TYPE.

Reason for the Error

To be update soon…

Solution

To be update soon…