SQL Server Errors or Failures from Error: 4946 to Error: 4967

SQLServerF1

 

Error: 4946, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same persistent attribute in tables ‘%.*ls’ and ‘%.*ls’.
Error: 4947, Severity: 16, ALTR TABLE SWITCH statement failed. There is no identical index in source table ‘%.*ls’ for the index ‘%.*ls’ in target table ‘%.*ls’ .
Error: 4948, Severity: 16, ALTR TABLE SWITCH statement failed. The source table ‘%.*ls’ is in database ‘%.*ls’ while the target table ‘%.*ls’ is in database ‘%.*ls’.
Error: 4949, Severity: 16, ALTR TABLE SWITCH statement failed because the object ‘%.*ls’ is not a user defined table.
Error: 4950, Severity: 16, ALTR TABLE SWITCH statement failed because partition number %d does not exist in table ‘%.*ls’.

Error: 4951, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same FILESTREAM storage attribute in tables ‘%.*ls’ and ‘%.*ls’.
Error: 4952, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same ANSI trimming semantics in tables ‘%.*ls’ and ‘%.*ls’.
Error: 4953, Severity: 16, ALTR TABLE SWITCH statement failed. The columns set used to partition the table ‘%.*ls’ is different from the column set used to partition the table ‘%.*ls’.
Error: 4954, Severity: 16, ALTR TABLE SWITCH statement failed. The table ‘%.*ls’ has inline limit of %d for text in row data which is different from value %d used by table ‘%.*ls’.
Error: 4955, Severity: 16, ALTR TABLE SWITCH statement failed. The source table ‘%.*ls’ and target table ‘%.*ls’ are same.
Error: 4957, Severity: 16, ‘%ls’ statement failed because the expression identifying partition number for the %S_MSG ‘%.*ls’ is not of integer type.
Error: 4958, Severity: 16, ALTR TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same ROWGUIDCOL property in tables ‘%.*ls’ and ‘%.*ls’.

Error: 4959, Severity: 16, ALTR TABLE SWITCH statement failed. Partition %d of %S_MSG ‘%.*ls’ has TEXT filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ has TEXT filegroup ‘%.*ls’.
Error: 4960, Severity: 16, ALTR TABLE SWITCH statement failed. Check constraint ‘%.*ls’ in source table ‘%.*ls’ is NOCHECK constraint but the matching check constraint ‘%.*ls’ in target table ‘%.*ls’ is CHECK.
Error: 4961, Severity: 16, ALTR TABLE SWITCH statement failed. Column ‘%.*ls’ in table ‘%.*ls’ is nullable and it is not nullable in ‘%.*ls’.
Error: 4963, Severity: 16, ALTR TABLE SWITCH statement failed. Partition %d is not valid for table ‘%.*ls’.
Error: 4964, Severity: 16, ALTR TABLE SWITCH statement failed. Table ‘%.*ls’ has RULE constraint ‘%.*ls’. SWITCH is not allowed on tables with RULE constraints.
Error: 4965, Severity: 16, ALTR TABLE SWITCH statement failed. Column ‘%.*ls’ in table ‘%.*ls’ is computed column but the same column in ‘%.*ls’ is not computed.
Error: 4966, Severity: 16, ALTR TABLE SWITCH statement failed. Computed column ‘%.*ls’ defined as ‘%.*ls’ in table ‘%.*ls’ is different from the same column in table ‘%.*ls’ defined as ‘%.*ls’.
Error: 4967, Severity: 16, ALTR TABLE SWITCH statement failed. SWITCH is not allowed because source table ‘%.*ls’ contains primary key for constraint ‘%.*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 *