SQL Server Error Msg 8301 – Use of level0type with value ‘USER’ 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. Users are now schema scoped and hence use level0type with value ‘SCHEMA’ and level1type with value ‘USER’ for extended properties on USER.

In this blog post, let’s learn about the error message “8301 – Use of level0type with value ‘USER’ 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. Users are now schema scoped and hence use level0type with value ‘SCHEMA’ and level1type with value ‘USER’ for extended properties on USER.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8301 – Use of level0type with value ‘USER’ 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. Users are now schema scoped and hence use level0type with value ‘SCHEMA’ and level1type with value ‘USER’ for extended properties on USER.

Reason for the Error

To be update soon…

Solution

To be update soon…