Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_11409

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.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft