MSSQLSERVER_11409

Details

Product Name	SQL Server
Product Version	10.50
Product Build Number	10.00.0000.00
Event ID	11409
Event Source	MSSQLSERVER
Component	SQLEngine
Symbolic Name	ALTERCOL_COLSET_DROP
Message Text	Cannot drop 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.