SQL Server Errors or Failures from Error: 4922 to Error: 4945

SQLServerF1

 

Error: 4922, Severity: 16, %ls %.*ls failed because one or more objects access this column.
Error: 4923, Severity: 16, ALTR TABLE DROP COLUMN failed because ‘%.*ls’ is the only data column in table ‘%.*ls’. A table must have at least one data column.
Error: 4924, Severity: 16, %ls failed because column ‘%.*ls’ does not exist in table ‘%.*ls’.
Error: 4925, Severity: 16, ALTR TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table ‘%.*ls’ with ROWGUIDCOL property.
Error: 4926, Severity: 16, ALTR TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table ‘%.*ls’ with ROWGUIDCOL property.

Error: 4927, Severity: 16, Cannot alter column ‘%.*ls’ to be data type %.*ls.
Error: 4928, Severity: 16, Cannot alter column ‘%.*ls’ because it is ‘%ls’.
Error: 4929, Severity: 16, Cannot alter the %S_MSG ‘%.*ls’ because it is being published for replication.
Error: 4933, Severity: 16, Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column depends on a non-schemabound object.
Error: 4934, Severity: 16, Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column does user or system data access.

Error: 4935, Severity: 16, ALTR TABLE ADD COLUMN cannot specify a FILESTREAM filegroup that differs from the existing one.
Error: 4936, Severity: 16, Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column is non-deterministic.
Error: 4938, Severity: 16, ALTR TABLE SWITCH statement failed. Partition %d of %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’.
Error: 4939, Severity: 16, ALTR TABLE SWITCH statement failed. %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’.
Error: 4940, Severity: 16, ALTR TABLE SWITCH statement failed. %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’ and %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’.
Error: 4941, Severity: 16, ALTR TABLE SWITCH statement failed because the table ‘%.*ls’ is marked for merge replication.
Error: 4942, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ at ordinal %d in table ‘%.*ls’ has a different name than the column ‘%.*ls’ at the same ordinal in table ‘%.*ls’.
Error: 4943, Severity: 16, ALTR TABLE SWITCH statement failed because table ‘%.*ls’ has %d columns and table ‘%.*ls’ has %d columns.
Error: 4944, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ has data type %s in source table ‘%.*ls’ which is different from its type %s in target table ‘%.*ls’.
Error: 4945, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*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 *