MSSQLSERVER_11409
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Details
Attribute | Value |
---|---|
Product Name | SQL Server |
Event ID | 11409 |
Event Source | MSSQLSERVER |
Component | SQLEngine |
Symbolic Name | ALTERCOL_COLSET_DROP |
Message Text | Cannot remove column set '%.*ls' in table '%.*ls' because the table contains more than 1025 columns. |
Explanation
Tables can contain a maximum of 1024 columns that are not designated as sparse, or computed. When sparse columns cause the table to exceed 1024 columns, a column set must be defined for the table. The table referenced has more than 1024 columns and you have attempted to remove the column set.
User Action
With the current columns in the table, you must retain the column set.
To remove the column set, first remove columns from the table, until you have no more than 1024 columns. Then, you can remove the column set.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om