You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/relational-databases/errors-events/includes/sql-server-2016-database-engine-events-and-errors-0-999.md
Copy file name to clipboardExpand all lines: docs/relational-databases/errors-events/includes/sql-server-2016-database-engine-events-and-errors-1000-1999.md
Copy file name to clipboardExpand all lines: docs/relational-databases/errors-events/includes/sql-server-2016-database-engine-events-and-errors-10000-10999.md
Copy file name to clipboardExpand all lines: docs/relational-databases/errors-events/includes/sql-server-2016-database-engine-events-and-errors-11000-12999.md
+12-12Lines changed: 12 additions & 12 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -2,10 +2,10 @@
2
2
author: MashaMSFT
3
3
ms.author: mathoma
4
4
ms.reviewer: randolphwest
5
-
ms.date: 02/17/2023
5
+
ms.date: 07/06/2023
6
6
ms.topic: include
7
7
---
8
-
| Error| Severity | Event logged | Description|
8
+
| Error| Severity | Event logged | Description|
9
9
| :--- | :--- | :--- | :--- |
10
10
| 11000 | 16 | No | Unknown status code for this column. |
11
11
|[11001](../mssqlserver-11001-database-engine-error.md)| 16 | No | Non-NULL value successfully returned. |
@@ -141,16 +141,16 @@ ms.topic: include
141
141
| 11292 | 16 | No | The forwarded message has been dropped because a transport send error occurred when sending the message. Check previous events for the error. |
142
142
| 11293 | 16 | No | This forwarded message has been dropped because a transport is shutdown. |
143
143
| 11294 | 16 | No | This forwarded message has been dropped because the destination route is not valid. |
144
-
| 11295 | 10 | No | Endpoint configuration change detected. Service Broker manager and transport will now restart. |
145
-
| 11296 | 10 | No | Certificate change detected. Service Broker manager and transport will now restart. |
144
+
| 11295 | 10 | No | Endpoint configuration change detected. Service Broker manager and transport will now restart. |
145
+
| 11296 | 10 | No | Certificate change detected. Service Broker manager and transport will now restart. |
146
146
| 11297 | 16 | No | A corrupted message has been received. The private variable data segment offset is incorrect. |
147
147
| 11298 | 16 | No | A corrupted message has been received. The public variable data segment offset is incorrect. |
148
148
| 11299 | 10 | No | A corrupted message has been received. An unsequenced message had a non-zero sequence number. This occurred in the message with Conversation ID '%.\*ls', Initiator: %d, and Message sequence number: %I64d. |
149
149
| 11300 | 10 | Yes | Error wile committing a readonly or a TEMPDB XDES, Shutting down the server. |
150
150
| 11301 | 10 | Yes | Error while performing transaction notification for object %p event %d. |
151
151
| 11302 | 10 | Yes | Error during rollback. shutting down database (location: %d). |
152
152
| 11303 | 10 | Yes | Error releasing reserved log space: %ls space %I64d, code %d, state %d. |
153
-
| 11304 | 10 | Yes | Failed to record outcome of a local two-phase commit transaction. Taking database offline. |
153
+
| 11304 | 10 | Yes | Failed to record outcome of a local two-phase commit transaction. Taking database offline. |
154
154
| 11306 | 16 | No | Forward progress on this transaction is disallowed. Transaction has been rolled back. |
155
155
| 11313 | 16 | No | This operation must be executed within a parallel nested transaction. |
156
156
| 11314 | 16 | No | The stored procedure %.\*ls must be executed within a user transaction. |
@@ -174,7 +174,7 @@ ms.topic: include
174
174
| 11406 | 16 | No | ALTER TABLE SWITCH statement failed. Source and target partitions have different values for the DATA_COMPRESSION option. |
175
175
| 11407 | 16 | No | Vardecimal storage format can not be enabled for '%.\*ls'. Only Enterprise edition of SQL Server supports vardecimal. |
176
176
| 11408 | 16 | No | Cannot modify the column '%.\*ls' in the table '%.\*ls' to add or remove the COLUMN_SET attribute. To change a COLUMN_SET attribute of a column, either modify the table to remove the column and then add the column again, or drop and re-create the table. |
177
-
|[11409](../mssqlserver-11409-database-engine-error.md)| 16 | No | Cannot remove the column set '%.\*ls' in the table '%.\*ls' because the table contains more than 1025 columns. Reduce the number of columns in the table to less than 1025. |
177
+
|[11409](../mssqlserver-11409-database-engine-error.md)| 16 | No | Cannot remove the column set '%.\*ls' in the table '%.\*ls' because the table contains more than 1025 columns. Reduce the number of columns in the table to less than 1025. |
178
178
| 11410 | 16 | No | Cannot modify the column '%.\*ls' in the table '%.\*ls' to a sparse column because the column has a default or rule bound to it. Unbind the rule or default from the column before designating the column as sparse. |
179
179
| 11411 | 16 | No | Cannot add the sparse column '%.\*ls' to the table '%.\*ls' because the data type of the column has a default or rule bound to it. Unbind the rule or default from the data type before adding the sparse column to the table. |
180
180
| 11412 | 16 | No | ALTER TABLE SWITCH statement failed because column '%.\*ls' does not have the same sparse storage attribute in tables '%.\*ls' and '%.\*ls'. |
@@ -272,14 +272,14 @@ ms.topic: include
272
272
| 12006 | 16 | No | Duplicate parameters were passed to the create index statement. Validate the statement against the index-creation syntax. |
273
273
| 12007 | 16 | No | The CREATE %S_MSG statement is missing the required parameter '%.\*ls'. Validate the statement against the index-creation syntax. |
274
274
| 12008 | 16 | No | Table '%.\*ls' does not have a clustered primary key as required by the %S_MSG index. Make sure that the primary key column exists on the table before creating a %S_MSG index. |
275
-
| 12009 | 16 | No | Could not find the %S_MSG index '%.\*ls' on table '%.\*ls'. Either no %S_MSG index with this name exists, or a non-%S_MSG index might be using the same name. Fix the index name, avoiding duplicates. If a relational index has the same name, drop the regular relational index. |
275
+
| 12009 | 16 | No | Could not find the %S_MSG index '%.\*ls' on table '%.\*ls'. Either no %S_MSG index with this name exists, or a non-%S_MSG index might be using the same name. Fix the index name, avoiding duplicates. If a relational index has the same name, drop the regular relational index. |
276
276
| 12010 | 16 | No | Only one spatial index hint may appear per table, either as the first or the last hinted index. |
277
277
| 12011 | 16 | No | The value of parameter '%.\*ls' of CREATE %S_MSG must be less than %d. |
278
278
| 12012 | 16 | No | The value of parameter '%.\*ls' of CREATE %S_MSG must be greater than %d. |
279
279
| 12013 | 16 | No | The value of parameter '%.\*ls' of CREATE %S_MSG must be greater than the value of parameter '%.\*ls'. |
280
280
| 12014 | 16 | No | The '%.\*ls' parameter of CREATE %S_MSG is incompletely defined. If the parameter has more than one part, all the parts must be defined. |
281
281
| 12015 | 16 | No | The index option %.\*ls in the CREATE %S_MSG statement has to appear before the general index options. |
282
-
| 12016 | 16 | No | Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d. The maximum combined per-row size of the primary-key columns is %d bytes. The primary key on the base table '%.\*ls' has %d columns, and contains %d bytes. Alter the base table to satisfy the primary-key restrictions imposed by the %S_MSG index. |
282
+
| 12016 | 16 | No | Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d. The maximum combined per-row size of the primary-key columns is %d bytes. The primary key on the base table '%.\*ls' has %d columns, and contains %d bytes. Alter the base table to satisfy the primary-key restrictions imposed by the %S_MSG index. |
283
283
| 12017 | 10 | No | The spatial index is disabled or offline |
284
284
| 12018 | 10 | No | The spatial object is not defined in the scope of the predicate |
285
285
| 12019 | 10 | No | Spatial indexes do not support the comparand supplied in the predicate |
@@ -290,8 +290,8 @@ ms.topic: include
290
290
| 12024 | 10 | No | The spatial parameter references a column that is defined below the predicate |
291
291
| 12025 | 10 | No | Could not find required binary spatial method in a condition |
292
292
| 12026 | 10 | No | Could not find required comparison predicate |
293
-
| 12100 | 16 | No | ALTER DATABASE failed because FILESTREAM filegroups cannot be added to a database that has either the READ_COMMITTED_SNAPSHOT or the ALLOW_SNAPSHOT_ISOLATION option set to ON. To add FILESTREAM filegroups, you must set READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to OFF. |
294
-
| 12101 | 16 | No | Cannot disable change tracking on database '%.\*ls' while client connections are waiting on change notification. Please close those connections before disabling change tracking. |
293
+
| 12100 | 16 | No | ALTER DATABASE failed because FILESTREAM filegroups cannot be added to a database that has either the READ_COMMITTED_SNAPSHOT or the ALLOW_SNAPSHOT_ISOLATION option set to ON. To add FILESTREAM filegroups, you must set READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to OFF. |
294
+
| 12101 | 16 | No | Cannot disable change tracking on database '%.\*ls' while client connections are waiting on change notification. Please close those connections before disabling change tracking. |
295
295
| 12102 | 16 | No | ALTER DATABASE failed because the distribution policy of system databases cannot be changed. |
296
296
| 12103 | 16 | No | ALTER DATABASE failed because the distribution policy is invalid. The database distribution policy must be set to either NONE or HASH. For the distribution policy NONE, the number of leading hash columns cannot be specified. For the distribution policy HASH, the number of leading hash columns is optional but cannot be more than 16 columns. |
297
297
| 12104 | 15 | No | ALTER DATABASE CURRENT failed because '%.\*ls' is a system database. System databases cannot be altered by using the CURRENT keyword. Use the database name to alter a system database. |
@@ -446,14 +446,14 @@ ms.topic: include
446
446
| 12821 | 16 | No | sp_migrate_user_to_contained cannot be used on a user used in the EXECUTE AS clause of a signed module. |
447
447
| 12822 | 16 | No | sp_migrate_user_to_contained cannot be used to copy a password to an old hash algorithm. |
448
448
| 12823 | 16 | No | sp_migrate_user_to_contained can not find the login for user '%.\*ls'. |
449
-
| 12824 | 16 | No | The sp_configure value 'contained database authentication' must be set to 1 in order to %S_MSG a contained database. You may need to use RECONFIGURE to set the value_in_use. |
449
+
| 12824 | 16 | No | The sp_configure value 'contained database authentication' must be set to 1 in order to %S_MSG a contained database. You may need to use RECONFIGURE to set the value_in_use. |
450
450
| 12825 | 16 | No | The database cannot be contained; this functionality is not available in the current edition of SQL Server. |
451
451
| 12826 | 16 | Yes | RECONFIGURE WITH OVERRIDE set the 'contained database authentication' to 0 while there are contained databases in use. This will disrupt authentication for contained users and will not allow new contained databases to be created. |
452
452
| 12827 | 16 | No | User-named %ls constraint '%.\*ls' is not allowed on temp table '%.\*ls' because it is being created in a contained database. Please consult the Books Online topic Understanding Contained Databases for more information on contained databases. |
453
453
| 12828 | 16 | No | User-defined %S_MSG '%.\*ls' in tempdb cannot be referenced from local temp table '%.\*ls' because the temp table is being created in a contained database. Please consult the Books Online topic Understanding Contained Databases for more information on contained databases. |
454
454
| 12829 | 16 | No | The stored procedure '%.\*ls' refers to a group of numbered stored procedures. Numbered stored procedures are not available in contained databases. Please consult the Books Online topic Understanding Contained Databases for more information on contained databases. |
455
455
| 12830 | 16 | No | The sp_configure 'user options' setting must be zero if the Database Engine has contained databases. |
456
-
| 12831 | 16 | No | Database '%.\*ls' is a contained database. The option 'contained database authentication' setting is 0. Users with passwords will not be able to login to contained databases. |
456
+
| 12831 | 16 | No | Database '%.\*ls' is a contained database. The option 'contained database authentication' setting is 0. Users with passwords will not be able to login to contained databases. |
457
457
| 12832 | 16 | Yes | The database '%.\*ls' could not be created or altered to a contained database, because the schema bound %S_MSG '%.\*ls' depends on builtin function '%s'. In a contained database, the output collation of this builtin function has changed to '%.\*ls', which differs from the collation used in a non-contained database. |
458
458
| 12833 | 16 | Yes | The database '%.\*ls' could not be created or altered to a contained database, because the check constraint '%.\*ls' on table '%.\*ls' depends on builtin function '%s'. In a contained database, the output collation of this builtin function has changed to '%.\*ls', which differs from the collation used in a non-contained database. |
459
459
| 12834 | 16 | Yes | The database '%.\*ls' could not be created or altered to a contained database, because the computed column '%.\*ls' on %S_MSG '%.\*ls' depends on builtin function '%s'. In a contained database, the output collation of this builtin function has changed to '%.\*ls', which differs from the collation used in a non-contained database. |
Copy file name to clipboardExpand all lines: docs/relational-databases/errors-events/includes/sql-server-2016-database-engine-events-and-errors-13000-13999.md
0 commit comments