SQL Server Error Msg 33544 – Cannot alter column ‘%.*ls’. The statement attempts to change the encryption scheme of the column and one or more of the following column properties: collation (to a different code page), data type. Such changes cannot be combined in a single statement. Try using multiple statements.

In this blog post, let’s learn about the error message “33544 – Cannot alter column ‘%.*ls’. The statement attempts to change the encryption scheme of the column and one or more of the following column properties: collation (to a different code page), data type. Such changes cannot be combined in a single statement. Try using multiple statements.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

33544 – Cannot alter column ‘%.*ls’. The statement attempts to change the encryption scheme of the column and one or more of the following column properties: collation (to a different code page), data type. Such changes cannot be combined in a single statement. Try using multiple statements.

Reason for the Error

To be update soon…

Solution

To be update soon…