Microsoft SQL Server database ranks third in the relational database, second only to Oracle and MySQL database. when using it, it is inevitable to encounter various problems and warnnings. You may be dba or a developer, I hope this content can help you solve SQL Server error number 12016.

Error number: 12016

Severity level: 16

Event logged: 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.