SQL Server Errors or Failures from Error: 11303 to Error: 11407

SQLServerF1

You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 11303 to Error: 11407

Error: 11303, Severity: 10,
Error releasing reserved log space: %ls space %I64d, code %d, state %d.

Error: 11304, Severity: 10,
Failed to record outcome of a local two-phase commit transaction. Taking database offline.

Error: 11306, Severity: 16,
Forward progress on this transaction is disallowed. Transaction has been rolled back.

Error: 11313, Severity: 16,
This operation must be executed within a parallel nested transaction.

Error: 11314, Severity: 16,
The stored procedure %.*ls must be executed within a user transaction.

Error: 11315, Severity: 16,
The isolation level specified for the PNT child transaction does not match the current isolation level for the parent.

Error: 11316, Severity: 16,
%ls statement cannot be used inside a parallel nested transaction.

Error: 11317, Severity: 16,
Parallel plan with updates is not supported inside a parallel nested transaction.

Error: 11318, Severity: 16,
The stored procedure ‘%.*ls’ cannot be executed through MARS connection.

Error: 11319, Severity: 16,
Bound sessions and user parallel nested transactions cannot be used in the same transaction.

Error: 11320, Severity: 16,
Cannot create a User Parallel Nested Transaction, the maximum number of parallel nested transactions is reached.

Error: 11321, Severity: 16,
This operation cannot be executed within an active transaction.

Error: 11400, Severity: 16,
ALTR TABLE SWITCH statement failed. Index ‘%.*ls’ on indexed view ‘%.*ls’ uses partition function ‘%.*ls’, but table ‘%.*ls’ uses non-equivalent partition function ‘%.*ls’. Index on indexed view ‘%.*ls’ and table ‘%.*ls’ must use an equivalent partition

Error: 11401, Severity: 16,
ALTR TABLE SWITCH statement failed. Table ‘%.*ls’ is %S_MSG, but index ‘%.*ls’ on indexed view ‘%.*ls’ is %S_MSG.

Error: 11402, Severity: 16,
ALTR TABLE SWITCH statement failed. Target table ‘%.*ls’ is referenced by %d indexed view(s), but source table ‘%.*ls’ is only referenced by %d indexed view(s). Every indexed view on the target table must have at least one matching indexed view on the so

Error: 11403, Severity: 16,
ALTR TABLE SWITCH statement failed. Indexed view ‘%.*ls’ is not aligned with table ‘%.*ls’. The partitioning column ‘%.*ls’ from the indexed view calculates its value from one or more columns or an expression, rather than directly selecting from the tabl

Error: 11404, Severity: 16,
ALTR TABLE SWITCH statement failed. Target table ‘%.*ls’ is referenced by %d indexed view(s), but source table ‘%.*ls’ is only referenced by %d matching indexed view(s). Every indexed view on the target table must have at least one matching indexed view

Error: 11405, Severity: 16,
ALTR TABLE SWITCH statement failed. Table ‘%.*ls’ is not aligned with the index ‘%.*ls’ on indexed view ‘%.*ls’. The table is partitioned on column ‘%.*ls’, but the index on the indexed view is partitioned on column ‘%.*ls’, which is selected from a diff

Error: 11406, Severity: 16,
ALTR TABLE SWITCH statement failed. Source and target partitions have different values for the DATA_COMPRESSION option.

Error: 11407, Severity: 16,
Vardecimal storage format can not be enabled for ‘%.*ls’. Only Enterprise edition of SQL Server supports vardecimal.

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 *