SQL Server Error Msg 12016 – Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d.  The maximum combined per-row size of the primary-key columns is %d bytes. The primary key on the base table ‘%.*ls’ has %d columns, and contains %d bytes. Alter the base table to satisfy the primary-key restrictions imposed by the %S_MSG index.

In this blog post, let’s learn about the error message “12016 – Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d.  The maximum combined per-row size of the primary-key columns is %d bytes. The primary key on the base table ‘%.*ls’ has %d columns, and contains %d bytes. Alter the base table to satisfy the primary-key restrictions imposed by the %S_MSG index.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

12016 – Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d.  The maximum combined per-row size of the primary-key columns is %d bytes. The primary key on the base table ‘%.*ls’ has %d columns, and contains %d bytes. Alter the base table to satisfy the primary-key restrictions imposed by the %S_MSG index.

Reason for the Error

To be update soon…

Solution

To be update soon…