SQL Server Errors or Failures from Error: 10603 to Error: 10633

SQLServerF1

 

Error: 10603, Severity: 16, Cannot rebuild clustered index ‘%.*ls’ on view ‘%.*ls’ because the view is dependent on base table ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled.
Error: 10604, Severity: 16, Cannot convert a statistic to an index using DROP_EXISTING index option when ONLINE index option is also specified.
Error: 10605, Severity: 16, Cannot disable primary key index “%.*ls” on table “%.*ls” because the table is published for replication.
Error: 10606, Severity: 16, Cannot disable the clustered index “%.*ls” on view “%.*ls”

because the indexed view is published for replication.
Error: 10607, Severity: 16, The clustered index ‘%.*ls’ on table ‘%.*ls’ cannot be disabled because the table has change tracking enabled. Disable change tracking on the table before disabling the clustered index.
Error: 10608, Severity: 16, The index ‘%.*ls’ on table ‘%.*ls’ cannot be disabled because the table has change tracking enabled. Change tracking requires a primary key constraint on the table, and disabling the index will drop the constraint. Disable change tracking on the table bef
Error: 10609, Severity: 16, Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is a computed column. Rewrite the filter expression so that it does not include this column.

Error: 10610, Severity: 16, Filtered index ‘%.*ls’ cannot be created on object ‘%.*ls’ because it is not a user table. Filtered indexes are only supported on tables. If you are trying to create a filtered index on a view, consider creating an indexed view with the filter expression
Error: 10611, Severity: 16, Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is compared with a constant of higher data type precedence or of a different collation. Converting a column to the data type of a constant is no
Error: 10612, Severity: 16, Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is compared with a constant that cannot be converted to the data type of the column. Rewrite the filter expression so that it does not include t
Error: 10617, Severity: 16, Index ‘%.*ls’ could not be created or rebuilt. The key length for this index (%d bytes) exceeds the maximum allowed length of ‘%d’ bytes when using the vardecimal storage format.
Error: 10618, Severity: 16, Cannot %S_MSG filtered index ‘%.*ls’ on table ‘%.*ls’ because the statement sets the IGNORE_DUP_KEY option to ON. Rewrite the statement so that it does not use the IGNORE_DUP_KEY option.
Error: 10619, Severity: 16, Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is of a CLR data type. Rewrite the filter expression so that it does not include this column.
Error: 10620, Severity: 16, Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the filter expression contains a comparison with a literal NULL value. Rewrite the comparison to use the IS [NOT] NULL comparison operator to test for NULL values.
Error: 10621, Severity: 16, The index ‘%.*ls’ on table ‘%.*ls’ could not be created because the column ‘%.*ls’ in the filter expression of the index is a column set.
Error: 10622, Severity: 16, The %S_MSG ‘%.*ls’ could not be created or rebuilt. A compressed index is not supported on table that contains sparse columns or a column set column.
Error: 10623, Severity: 16, Filtered statistics ‘%.*ls’ cannot be created on object ‘%.*ls’ because it is not a user table. Filtered statistics are only supported on user tables.
Error: 10631, Severity: 16, Index ‘%.*ls’ could not be created or rebuilt. A unique or clustered index on a federated table must contain the federated column.
Error: 10632, Severity: 16, Index ‘%.*ls’ could not be created. Views cannot be indexed in a federated database.
Error: 10633, Severity: 16, Invalid online index creation operation

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *