SQL Server Error Msg 11424 – Cannot alter the identity column ‘%.*ls’ in the table ‘%.*ls’ because this operation requires data modification and the table contains a persisted computed column. Remove the persisted computed column before modifying the identity column.

In this blog post, let’s learn about the error message “11424 – Cannot alter the identity column ‘%.*ls’ in the table ‘%.*ls’ because this operation requires data modification and the table contains a persisted computed column. Remove the persisted computed column before modifying the identity column.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

11424 – Cannot alter the identity column ‘%.*ls’ in the table ‘%.*ls’ because this operation requires data modification and the table contains a persisted computed column. Remove the persisted computed column before modifying the identity column.

Reason for the Error

To be update soon…

Solution

To be update soon…