SQL Server Errors or Failures from Error: 4901 to Error: 4921

SQLServerF1

 

Error: 4901, Severity: 16, ALTR TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be e
Error: 4902, Severity: 16, Cannot find the object “%.*ls” because it does not exist or you do not have permissions.
Error: 4903, Severity: 10, Warning: The specified partition %d for the table ‘%.*ls’ was ignored in ALTR TABLE SWITCH statement because the table is not partitioned.
Error: 4904, Severity: 16, ALTR TABLE SWITCH statement failed. The specified partition %d of target table ‘%.*ls’ must be empty.

Error: 4905, Severity: 16, ALTR TABLE SWITCH statement failed. The target table ‘%.*ls’ must be empty.
Error: 4906, Severity: 16, ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ is %S_MSG partitioned while index ‘%.*ls’ is %S_MSG partitioned.
Error: 4907, Severity: 16, ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ has %d partitions while index ‘%.*ls’ has %d partitions.
Error: 4908, Severity: 16, ‘%ls’ statement failed. The range boundary values used to partition the %S_MSG ‘%.*ls’ are different from the range boundary values used for index ‘%.*ls’.
Error: 4909, Severity: 16, Cannot alter ‘%.*ls’ because it is not a table.
Error: 4911, Severity: 16, Cannot specify a partitioned table without partition number in ALTR TABLE SWITCH statement. The table ‘%.*ls’ is partitioned.

Error: 4912, Severity: 16, ‘%ls’ statement failed. The columns set used to partition the %S_MSG ‘%.*ls’ is different from the column set used to partition index ‘%.*ls’.
Error: 4913, Severity: 16, ALTR TABLE SWITCH statement failed. The table ‘%.*ls’ has clustered index ‘%.*ls’ while the table ‘%.*ls’ does not have clustered index.
Error: 4914, Severity: 16, The ALTR TABLE SWITCH statement failed. The table “%.*ls” has a disabled clustered index.
Error: 4915, Severity: 16, ‘%ls’ statement failed. The parameter type of the partition function used to partition the %S_MSG ‘%.*ls’ is different from the parameter type of the partition function used to partition index ‘%.*ls’.
Error: 4916, Severity: 16, Could not enable or disable the constraint. See previous errors.
Error: 4917, Severity: 16, Constraint ‘%.*ls’ does not exist.
Error: 4918, Severity: 16, ALTR TABLE SWITCH statement failed because the table ‘%.*ls’ has fulltext index on it.
Error: 4919, Severity: 16, PERSISTED attribute cannot be altered on column ‘%.*ls’ because this column is not computed.
Error: 4920, Severity: 16, ALTR TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.
Error: 4921, Severity: 16, ALTR TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’.

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 *