SQL Server error messages list 11000 to 14000

SQL Server error messages list 11000 to 14000.

Following is the list of error messages for sql server (11000 to 14000):

error severity description
10001 16 The provider reported an unexpected catastrophic failure.
10002 16 The provider did not implement the functionality.
10003 16 The provider ran out of memory.
10004 16 One or more arguments were reported invalid by the provider.
10005 16 The provider did not support an interface.
10006 16 The provider indicated an invalid pointer was used.
10007 16 The provider indicated an invalid handle was used.
10008 16 The provider terminated the operation.
10009 16 The provider did not give any information about the error.
10010 16 The data necessary to complete this operation was not yet available to the provider.
10011 16 Access denied.
10021 16 Execution terminated by the provider because a resource limit was reached.
10022 16 The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.
10023 16 The provider does not support the necessary method.
10024 16 The provider indicates that the user did not have the permission to perform the operation.
10025 16 Provider caused a server fault in an external process.
10026 16 No command text was set.
10027 16 Command was not prepared.
10028 16 Authentication failed.
10032 16 Cannot return multiple result sets (not supported by the provider).
10033 16 The specified index does not exist or the provider does not support an index scan on this data source.
10034 16 The specified table or view does not exist or contains errors.
10035 16 No value was given for one or more of the required parameters.
10042 16 Cannot set any properties while there is an open rowset.
10052 16 The insertion was canceled by the provider during notification.
10053 16 Could not convert the data value due to reasons other than sign mismatch or overflow.
10054 16 The data value for one or more columns overflowed the type used by the provider.
10055 16 The data violated the integrity constraints for one or more columns.
10056 16 The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10057 16 Cannot create the row. Would exceed the total number of active rows supported by the rowset.
10058 16 The consumer cannot insert a new row before releasing previously-retrieved row handles.
10062 16 The change was canceled by the provider during notification.
10063 16 Could not convert the data value due to reasons other than sign mismatch or overflow.
10064 16 The data value for one or more columns overflowed the type used by the provider.
10065 16 The data violated the integrity constraints for one or more columns.
10066 16 The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10067 16 The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
10068 16 The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.
10069 16 The consumer could not delete the row. The insertion has been transmitted to the data source.
10081 16 The rowset uses integrated indexes and there is no current index.
10085 16 RestartPosition on the table was canceled during notification.
10086 16 The table was built over a live data stream and the position cannot be restarted.
10087 16 The provider did not release some of the existing rows.
10088 16 The order of the columns was not specified in the object that created the rowset. The provider had to reexecute the command to reposition the next fetch position to its initial position, and the order of the columns changed.
10100 16 Cannot create %S_MSG on view “%.*ls” because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or not indexing the view. Alternatively, consider replacing DISTINCT with GROUP BY or COUNT_BIG(*) to simulate DISTINCT on grouping col
10101 16 Cannot create %S_MSG on view “%.*ls” because it contains the TOP keyword. Consider removing TOP or not indexing the view.
10102 16 Cannot create %S_MSG on view “%.*ls” because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing the view.
10103 16 Cannot create %S_MSG on view “%.*ls” because it uses OPENROWSET, OPENQUERY, or OPENDATASOURCE. Consider not indexing the view, or eliminating OPENQUERY, OPENROWSET, and OPENDATASOURCE.
10104 16 Cannot create %S_MSG on view “%.*ls” because it references a table using a CONTAINSTABLE or FREETEXTTABLE full-text function. Consider removing use of these functions or not indexing the view.
10105 16 Cannot create %S_MSG on view “%.*ls” because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
10106 16 Cannot create %S_MSG on view “%.*ls” because it references an internal system rowset provider. Consider not indexing this view.
10107 16 Cannot create %S_MSG on view “%.*ls” because it uses table variable “%.*ls”. Consider not indexing this view or removing the reference to the table variable.
10108 16 Cannot create %S_MSG on view “%.*ls” because it references a SQL Server internal table.
10109 16 Cannot create %S_MSG on view “%.*ls” because it references derived table “%.*ls” (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.
10110 16 Cannot create %S_MSG on view “%.*ls” because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
10111 16 Cannot create %S_MSG on view “%.*ls” because it contains a join using an ODBC standard escape syntax. Consider using an ANSI join syntax instead.
10112 16 Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint.
10113 16 Cannot create %S_MSG on view “%.*ls” because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead.
10114 16 Cannot create %S_MSG on view “%.*ls” because it uses the PIVOT operator. Consider not indexing this view.
10115 16 Cannot create %S_MSG on view “%.*ls” because it uses the UNPIVOT operator. Consider not indexing this view.
10116 16 Cannot create %S_MSG on view ‘%.*ls’ because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view.
10117 16 Cannot create %S_MSG on view “%.*ls” because the view uses the “*” operator to select columns. Consider referencing columns by name instead.
10118 16 Cannot create %S_MSG on view “%.*ls” because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
10119 16 Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
10121 16 Cannot create %S_MSG on view “%.*ls” because it contains a HAVING clause. Consider removing the HAVING clause.
10122 16 Cannot create %S_MSG on view “%.*ls” because it contains a COMPUTE clause. Consider not indexing this view, or using a GROUP BY or aggregate view instead to replace the COMPUTE calculation of aggregate results.
10123 16 Cannot create %S_MSG on view “%.*ls” because it contains a join that uses deprecated Transact-SQL join syntax ( *= and =* ). Consider using = operator (non-outer-join) instead.
10124 16 Cannot create %S_MSG on view “%.*ls” because it references an internal SQL Server column.
10125 16 Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls”. Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG.
10126 16 Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.
10127 16 Cannot create %S_MSG on view “%.*ls” because it contains one or more subqueries. Consider changing the view to use only joins instead of subqueries. Alternatively, consider not indexing this view.
10128 16 Cannot create %S_MSG on view “%.*ls” because it uses a CONTAINS or FREETEXT full-text predicate. Consider eliminating CONTAINS or FREETEXT, or not indexing the view.
10129 16 Cannot create %S_MSG on view “%.*ls” because it references the inline or multistatement table-valued function “%.*ls”. Consider expanding the function definition by hand in the view definition, or not indexing the view.
10130 16 Cannot create %S_MSG on view “%.*ls” because it uses non-deterministic common language runtime (CLR) table-valued function “%.*ls”. Consider not indexing the view or changing it to not use this function.
10131 16 Cannot create %S_MSG on view “%.*ls” because it references imprecise common language runtime (CLR) table-valued function “%.*ls”. Consider not indexing the view.
10132 16 Cannot create %S_MSG on view “%.*ls” because it references table valued common language runtime (CLR) function “%.*ls”. Consider removing reference to the function or not indexing the view.
10133 16 Cannot create %S_MSG on view “%.*ls” because function “%.*ls” referenced by the view performs user or system data access.
10134 16 Cannot create %S_MSG on view “%.*ls” because it contains more than one APPLY. Consider not indexing the view, or using only one APPLY.
10136 16 Cannot create %S_MSG on view “%.*ls” because it uses the aggregate COUNT. Use COUNT_BIG instead.
10137 16 Cannot create %S_MSG on view “%.*ls” because it references common table expression “%.*ls”. Views referencing common table expressions cannot be indexed. Consider not indexing the view, or removing the common table expression from the view definition.
10138 16 Cannot create %S_MSG on view ‘%.*ls’ because its select list does not include a proper use of COUNT_BIG. Consider adding COUNT_BIG(*) to select list.
10139 16 Cannot create %S_MSG on view ‘%.*ls’ because the view uses an implicit conversion from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style value.
10140 16 Cannot create %S_MSG on view ‘%.*ls’ because the view contains a table hint. Consider removing the hint.
10141 16 Cannot create %S_MSG on view ‘%.*ls’ because it references CLR routine (function or method) ‘%.*ls’ outside non-key columns of SELECT list. Recreate or alter view so it does not reference CLR routines except in non-key columns of SELECT list, and then cre
10142 16 Cannot create %S_MSG on view “%.*ls” because it contains an APPLY. Consider not indexing the view, or removing APPLY.
10143 16 Cannot create %S_MSG on view “%.*ls” because it contains a ranking or aggregate window function. Remove the function from the view definition or, alternatively, do not index the view.
10144 16 Cannot create %S_MSG on view ‘%.*ls’ because it uses the CHANGETABLE function.
10145 16 Cannot create %S_MSG on the view ‘%.*ls’ because it references a sparse column set. Views that contain a sparse column set cannot be indexed. Consider removing the sparse column set from the view or not indexing the view.
10211 16 Cannot invoke mutator on a null CLR type value.
10227 16 Field “%.*ls” of type “%.*ls.%.*ls” cannot be updated because the field is “%.*ls”.
10240 16 Could not find UdtExtensions.dll. Please check your installation.
10300 16 Assembly ‘%.*ls’ references assembly ‘%.*ls’, which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has fai
10301 16 Assembly ‘%.*ls’ references assembly ‘%.*ls’, which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has fai
10302 16 Could not get path for SQL Server: ‘%ls’.
10303 16 Could not create AppDomain manager: ‘%.*ls’.
10304 16 Failed to enter Common Language Runtime (CLR) with HRESULT 0x%x. This may due to low resource conditions.
10305 16 The Init method for a CLR table-valued function must be annotated with SqlFunctionAttribute.
10306 16 The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.
10307 16 The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.
10308 10 Warning: The Microsoft .NET Framework assembly ‘%.*ls’ you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration ro
10309 10 Warning: The SQL Server client assembly ‘%.*ls’ you are registering is not fully tested in SQL Server hosted environment.
10310 10 AppDomain %i (%.*ls) is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.
10311 10 AppDomain %i (%.*ls) is marked for unload due to memory pressure.
10312 16 .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.
10313 16 An error occurred while using the .NET Framework during %S_MSG. The server may be running out of resources. Try running the query again. If the problem persist, contact a support professional. %.*ls
10314 16 An error occurred in the Microsoft .NET Framework while trying to load assembly id %d. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentat
10316 16 The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found.
10317 16 An error occurred trying to get file version info for the file ‘%s’.
10318 16 ‘%.*ls’ failed because parameter %d of method ‘%.*ls’ of type ‘%.*ls’ is annotated with unsupported attribute System.ParamArrayAttribute.
10319 16 UserDefinedType method call failed because parameter %d of method ‘%.*ls’ of type ‘%.*ls’ is annotated with unsupported attribute System.ParamArrayAttribute.
10320 16 Method name ‘%.*ls’ is invalid for ‘%.*ls’.
10321 16 Method name ‘%.*ls’ is invalid for UserDefinedType method call.
10322 16 Type %.*ls not found in database %.*ls
10323 16 Invalid user code has been identified by .Net Framework Managed Debug Assistant %.*ls
10324 16 WITH ENCRYPTION option of CREATE TRIGGER is only applicable to T-SQL triggers and not to CLR triggers.
10325 16 The server is shutting down due to stack overflow in user’s unmanaged code.
10326 16 Two versions of assembly ‘%.*ls’ cannot coexist in database ‘%.*ls’. Keep one version and drop the other.
10327 14 %ls ASSEMBLY for assembly ‘%.*ls’ failed because assembly ‘%.*ls’ is not authorized for PERMISSION_SET = %ls. The assembly is authorized when either of the following is true: the database owner (DBO) has %ls permission and the database has the TRUSTWORTH
10328 16 There is not enough stack to create appdomain ‘%.*ls’.
10329 16 .Net Framework execution was aborted. %.*ls
10330 16 ALTER ASSEMBLY failed because serialization layout of type ‘%s’ would change as a result of a change in type ‘%s’ in the updated assembly. Persisted types are not allowed to change serialization layout.
10331 16 Type ‘%ls’ in assembly ‘%.*ls’ derives from a generic type which is not supported for a CLR Type.
10501 16 Cannot create plan guide ‘%.*ls’ because type ‘%.*ls’ provided is not allowed.
10502 16 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, matches the existing plan guide ‘%.*ls’ in the database. Drop the existing plan guide before creating the new p
10503 16 Operation ‘%.*ls’ is not allowed.
10504 16 Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,…n ] )’.
10505 16 Cannot create plan guide ‘%.*ls’ because value ‘%.*ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’.
10506 16 Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.
10507 16 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch. Modify the values to match a statement in the mo
10508 16 Cannot ‘%ls’ plan guide ‘%.*ls’ because it does not exist or you do not have permission. Verify plan guide name and database of current session, and that you have needed permission.
10509 16 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide. Provide a single valid Transact-SQL statement or a valid starting position of the
10510 16 Cannot create plan guide ‘%.*ls’ because there is already a plan guide with that name in the database. Use a unique name.
10512 16 Cannot create plan guide ‘%.*ls’ because object ‘@module_or_batch’ is encrypted. Consider tuning query using other techniques such as indexes and statistics.
10513 16 Cannot %S_MSG %S_MSG ‘%.*ls’ because it is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed.
10515 16 Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission.
10516 16 Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled.
10517 16 Cannot create plan guide ‘%.*ls’ because you do not have needed permission. Alter database permission required.
10518 16 Cannot execute sp_control_plan_guide because of insufficient permissions to control plan guide ‘%.*ls’. Alter permission on object referenced by plan guide, or alter database permission required.
10519 16 Cannot create plan guide ‘%.*ls’ because the hints specified in @hints cannot be applied to the statement specified by either @stmt or @statement_start_offset. Verify that the hints can be applied to the statement.
10520 16 Cannot create plan guide ‘%.*ls’ because @type was specified as ‘%ls’ and a non-NULL value is specified for the parameter ‘%ls’. This type requires a NULL value for the parameter. Specify NULL for the parameter, or change the type to one that allows a non
10521 16 Cannot create plan guide ‘%.*ls’ because @type was specified as ‘%ls’ and the parameter ‘%ls’ is NULL. This type requires a non-NULL value for the parameter. Specify a non-NULL value for the parameter, or change the type to one that allows a NULL value fo
10522 16 Cannot create plan guide ‘%.*ls’ because @hints has illegal value. @hints must be OPTION(PARAMETERIZATION FORCED) or OPTION(PARAMETERIZATION SIMPLE) if @type is ‘template’.
10523 16 Cannot generate query template because @querytext does not contain a valid single query.
10524 16 Cannot parameterize @querytext.
10525 10 Plan guide ‘%.*ls’ matched statement after it was parameterized automatically by FORCED or SIMPLE parameterization, but the RECOMPILE hint it contains was ignored. RECOMPILE is not supported on automatically parameterized statements. Consider dropping thi
10526 16 Cannot drop %S_MSG ‘%.*ls’ because its trigger ‘%.*ls’ is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed.
10527 16 Cannot create plan guide ‘%.*ls’ because the object ‘%.*ls’ is a temporary object.
10528 16 Cannot create plan guide ‘%.*ls’ because its name is invalid. Plan guide name cannot begin with a ‘#’ character.
10529 16 Cannot create plan guide ‘%.*ls’ because there is already a planguide ‘%.*ls’ of @type ‘template’ on @stmt.
10530 16 Cannot create plan guide ‘%.*ls’ because the statement specified by @statement_start_offset does not match any statement in specified module or batch. Consider modifying @statement_start_offset to match a statement in module or batch.
10531 16 Cannot create plan guide ‘%.*ls’ from cache because the user does not have adequate permissions. Grant the VIEW SERVER STATE permission to the user creating the plan guide.
10532 16 Cannot create plan guide ‘%.*ls’ because the batch or module specified by @plan_handle does not contain a statement that is eligible for a plan guide. Specify a different value for @plan_handle.
10533 16 Cannot create plan guide ‘%.*ls’ because the plan guide name exceeds 124, the maximum number of characters allowed. Specify a name that contains fewer than 125 characters.
10534 16 Cannot create plan guide ‘%.*ls’ because the value specified for @params is invalid. Specify the value in the form , or specify NULL.
10535 16 Cannot create plan guide ‘%.*ls’ because a plan was not found in the plan cache that corresponds to the specified plan handle. Specify a cached plan handle. For a list of cached plan handles, query the sys.dm_exec_query_stats dynamic management view.
10536 16 Cannot create plan guide ‘%.*ls’ because the batch or module corresponding to the specified @plan_handle contains more than 1000 eligible statements. Create a plan guide for each statement in the batch or module by specifying a statement_start_offset valu
10537 16 Cannot enable plan guide ‘%.*ls’ because the enabled plan guide ‘%.*ls’ contains the same scope and starting offset value of the statement. Disable the existing plan guide before enabling the specified plan guide.
10538 16 Cannot find the plan guide either because the specified plan guide ID is NULL or invalid, or you do not have permission on the object referenced by the plan guide. Verify that the plan guide ID is valid, the current session is set to the correct database
10539 16 Cannot create plan guide ‘%.*ls’ from cache because a query plan is not available for the statement with start offset %d.This problem can occur if the statement depends on database objects that have not yet been created. Make sure that all necessary datab
10601 16 Cannot specify included columns for a clustered index.
10602 16 Mixing old and new syntax in CREATE/ALTER/DROP INDEX statement is not allowed.
10603 16 Cannot rebuild clustered index ‘%.*ls’ on view ‘%.*ls’ because the view is dependent on base table ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled.
10604 16 Cannot convert a statistic to an index using DROP_EXISTING index option when ONLINE index option is also specified.
10605 16 Cannot disable primary key index “%.*ls” on table “%.*ls” because the table is published for replication.
10606 16 Cannot disable the clustered index “%.*ls” on view “%.*ls” because the indexed view is published for replication.
10607 16 The clustered index ‘%.*ls’ on table ‘%.*ls’ cannot be disabled because the table has change tracking enabled. Disable change tracking on the table before disabling the clustered index.
10608 16 The index ‘%.*ls’ on table ‘%.*ls’ cannot be disabled because the table has change tracking enabled. Change tracking requires a primary key constraint on the table, and disabling the index will drop the constraint. Disable change tracking on the table bef
10609 16 Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is a computed column. Rewrite the filter expression so that it does not include this column.
10610 16 Filtered index ‘%.*ls’ cannot be created on object ‘%.*ls’ because it is not a user table. Filtered indexes are only supported on tables. If you are trying to create a filtered index on a view, consider creating an indexed view with the filter expression
10611 16 Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is compared with a constant of higher data type precedence or of a different collation. Converting a column to the data type of a constant is no
10612 16 Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is compared with a constant that cannot be converted to the data type of the column. Rewrite the filter expression so that it does not include t
10617 16 Index ‘%.*ls’ could not be created or rebuilt. The key length for this index (%d bytes) exceeds the maximum allowed length of ‘%d’ bytes when using the vardecimal storage format.
10618 16 Cannot %S_MSG filtered index ‘%.*ls’ on table ‘%.*ls’ because the statement sets the IGNORE_DUP_KEY option to ON. Rewrite the statement so that it does not use the IGNORE_DUP_KEY option.
10619 16 Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the column ‘%.*ls’ in the filter expression is of a CLR data type. Rewrite the filter expression so that it does not include this column.
10620 16 Filtered %S_MSG ‘%.*ls’ cannot be created on table ‘%.*ls’ because the filter expression contains a comparison with a literal NULL value. Rewrite the comparison to use the IS [NOT] NULL comparison operator to test for NULL values.
10621 16 The index ‘%.*ls’ on table ‘%.*ls’ could not be created because the column ‘%.*ls’ in the filter expression of the index is a column set.
10622 16 Index ‘%.*ls’ could not be created or rebuilt. A compressed index is not supported on table that contains sparse columns or a column set column.
10623 16 Filtered statistics ‘%.*ls’ cannot be created on object ‘%.*ls’ because it is not a user table. Filtered statistics are only supported on user tables.
10700 16 The table-valued parameter “%.*ls” is READONLY and cannot be modified.
10701 15 The READONLY option cannot be used in an EXECUTE or CREATE AGGREGATE statement.
10702 15 The WITH CUBE and WITH ROLLUP options are not permitted with a ROLLUP, CUBE, or GROUPING SETS specification.
10703 15 Too many grouping sets. The maximum number is %d.
10705 15 Subqueries are not allowed in the OUTPUT clause.
10706 15 Too many expressions are specified in the GROUP BY clause. The maximum number is %d when grouping sets are supplied.
10707 15 The CUBE() and ROLLUP() grouping constructs are not allowed in the current compatibility mode. They are only allowed in 100 mode or higher.
10708 15 DEFAULT is not allowed on the right hand side of “%.*ls”
10709 15 The number of columns for each row in a table value constructor must be the same.
10710 15 An action of type ‘%S_MSG’ is not allowed in the ‘WHEN NOT MATCHED’ clause of a MERGE statement.
10711 15 An action of type ‘INSERT’ is not allowed in the ‘%S_MSG’ clause of a MERGE statement.
10712 15 Non-ANSI outer join operators (“*=” or “=*”) are not allowed in a MERGE statement. Use the OUTER JOIN keywords instead.
10713 15 A MERGE statement must be terminated by a semi-colon (;).
10714 15 An action of type ‘%S_MSG’ cannot appear more than once in a ‘%S_MSG’ clause of a MERGE statement.
10716 15 A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.
10717 15 The %S_MSG clause is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10718 15 Query hints are not allowed in nested INSERT, UPDATE, DELETE, or MERGE statements.
10719 15 Non-ANSI outer join operators (“*=” or “=*”) are not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement. Use the OUTER JOIN keywords instead.
10720 15 An OUTPUT INTO clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10721 15 The WHERE CURRENT OF clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10722 15 The DISTINCT keyword is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10723 15 In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an UPDATE action. Assignments of the form ‘SET @variable = column = expression’ are not valid in the SET clause of an UPDATE action in a
10724 15 The FORCESEEK hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10725 15 Cannot use the VARYING option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
10726 15 User defined aggregates do not support default parameters.
10727 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a JOIN or APPLY operator.
10728 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed as the table source of a PIVOT or UNPIVOT operator.
10729 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in a SELECT statement that is not the immediate source of rows for an INSERT statement.
10730 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the FROM clause of an UPDATE or DELETE statement.
10731 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed inside another nested INSERT, UPDATE, DELETE, or MERGE statement.
10732 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a UNION, INTERSECT, or EXCEPT operator.
10733 15 A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the USING clause of a MERGE statement.
10734 16 Variable assignment is not allowed in a statement containing a top level UNION, INTERSECT or EXCEPT operator.
10735 15 Incorrect WHERE clause for filtered %S_MSG ‘%.*ls’ on table ‘%.*ls’.
10736 15 A full-text stoplist statement must be terminated by a semi-colon (;).
10737 15 In an ALTER TABLE REBUILD or ALTER INDEX REBUILD statement, when a partition is specified in a DATA_COMPRESSION clause, PARTITION=ALL must be specified. The PARTITION=ALL clause is used to reinforce that all partitions of the table or index will be rebuil
10738 15 The number of row value expressions in the INSERT statement exceeds the maximum allowed number of %d row values.
10739 15 The insert column list used in the MERGE statement cannot contain multi-part identifiers. Use single part identifiers instead.
10740 15 The FORCESCAN hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10741 15 The FORCESCAN hint is specified simultaneously with the FORCESEEK hint. Remove one of the hints and resubmit the query.
10742 15 The parameterized FORCESEEK hint cannot be simultaneously used with INDEX hints or a non-parameterized FORCESEEK hint on the same object. Use either INDEX hints and a non-parameterized FORCESEEK hint or use a parameterized FORCESEEK hint without INDEX hin
10743 15 There are multiple FORCESEEK hints specified on the same table or view. Remove the extra FORCESEEK hints and resubmit the query.
10744 15 The FORCESEEK hint cannot be used with index 0. Correct the index provided to the FORCESEEK hint and resubmit the query.
10745 15 The FORCESCAN hint cannot be used with more than one INDEX hint. Remove the extra INDEX hints and resubmit the query.
10900 16 Failed to configure resource governor during startup. Check SQL Server error log for specific error messages or check the consistency of master database by running DBCC CHECKCATALOG(‘master’).
10901 16 User does not have permission to alter the resource governor configuration.
10902 16 User-defined function ‘%s’ does not exist in master database, or the user does not have permission to access it.
10903 16 The specified schema name ‘%.*ls’ for classifier user-defined function either does not exist, or the user does not have permission to use it.
10904 16 Resource governor configuration failed. There are active sessions in workload groups being dropped or moved to different resource pools. Disconnect all active sessions in the affected workload groups and try again.
10905 16 Could not complete resource governor configuration because there is not enough memory. Reduce the server load or try the operation on a dedicated administrator connection.
10906 16 The object ‘%.*ls’.’%.*ls’ is not a valid resource governor classifier user-defined function. A valid classifier user-defined function must be schema-bound, return sysname, and have no parameters.
10907 16 Attribute ‘%.*ls’ with value of %u is greater than attribute ‘%.*ls’ with value of %u.
10908 16 Attribute ‘%.*ls’ with value of %u is less than attribute ‘%.*ls’ with value of %u.
10909 16 The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools.
10910 16 The operation could not be completed. The specified ‘%.*ls’ value, %u, causes the sum of minimums on all resource pools to exceed 100 percent. Reduce the value or modify other resource pools so that the sum is less than 100.
10911 16 Requested operation cannot be performed because the resource pool ‘%.*ls’ does not exist.
10912 16 The operation could not be completed. Dropping predefined %S_MSG is not allowed.
10913 16 Users are not allowed to %S_MSG the workload group ‘%.*ls’ in the ‘%.*ls’ resource pool.
10914 16 The name of the %S_MSG ‘%.*ls’ cannot begin with # of ##.
10915 16 The operation could not be completed. Altering ‘%.*ls’ %S_MSG is not allowed.
10916 16 Cannot drop resource pool ‘%.*ls’ because it contains workload group ‘%.*ls’. Drop or remove all workload groups using this resource pool before dropping it.
10917 16 ALTER WORKLOAD GROUP failed. Either a ‘WITH’ or ‘USING’ clause must be specified.
10918 16 Cannot create %S_MSG ‘%.*ls’ because it already exists.
10919 16 An error occurred while reading the resource governor configuration from master database. Check the integrity of master database or contact the system administrator.
10920 16 Cannot %S_MSG user-defined function ‘%.*ls’. It is being used as a resource governor classifier.
10921 16 The ‘%.*ls’ %S_MSG cannot be moved out of ‘%.*ls’ %S_MSG.
10922 16 %ls failed. Rerun the statement.
10923 16 %ls failed. The resource governor is not available in this edition of SQL Server. You can manipulate resource governor metadata but you will not be able to apply resource governor configuration. Only Enterprise edition of SQL Server supports resource gov
10981 10 Resource governor reconfiguration succeeded.
10982 16 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID %ld for details. Classifier elapsed time: %I64u ms.
10983 16 Resource governor ‘%ls’ operation was canceled by user.
10984 16 Resource governor reconfiguration failed.
11000 16 Unknown status code for this column.
11001 16 Non-NULL value successfully returned.
11002 16 Deferred accessor validation occurred. Invalid binding for this column.
11003 16 Could not convert the data value due to reasons other than sign mismatch or overflow.
11004 16 Successfully returned a NULL value.
11005 16 Successfully returned a truncated value.
11006 16 Could not convert the data type because of a sign mismatch.
11007 16 Conversion failed because the data value overflowed the data type used by the provider.
11008 16 The provider cannot allocate memory or open another storage object on this column.
11009 16 The provider cannot determine the value for this column.
11010 16 The user did not have permission to write to the column.
11011 16 The data value violated the integrity constraints for the column.
11012 16 The data value violated the schema for the column.
11013 16 The column had a bad status.
11014 16 The column used the default value.
11015 16 The column was skipped when setting data.
11031 16 The row was successfully deleted.
11032 16 The table was in immediate-update mode, and deleting a single row caused more than one row to be deleted in the data source.
11033 16 The row was released even though it had a pending change.
11034 16 Deletion of the row was canceled during notification.
11036 16 The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
11037 16 The row has a pending delete or the deletion had been transmitted to the data source.
11038 16 The row is a pending insert row.
11039 16 DBPROP_CHANGEINSERTEDROWS was VARIANT_FALSE and the insertion for the row has been transmitted to the data source.
11040 16 Deleting the row violated the integrity constraints for the column or table.
11041 16 The row handle was invalid or was a row handle to which the current thread does not have access rights.
11042 16 Deleting the row would exceed the limit for pending changes specified by the rowset property DBPROP_MAXPENDINGROWS.
11043 16 The row has a storage object open.
11044 16 The provider ran out of memory and could not fetch the row.
11045 16 User did not have sufficient permission to delete the row.
11046 16 The table was in immediate-update mode and the row was not deleted due to reaching a limit on the server, such as query execution timing out.
11047 16 Updating did not meet the schema requirements.
11048 16 There was a recoverable, provider-specific error, such as an RPC failure.
11100 16 The provider indicates that conflicts occurred with other properties or requirements.
11101 16 Could not obtain an interface required for text, ntext, or image access.
11102 16 The provider could not support a required row lookup interface.
11103 16 The provider could not support an interface required for the UPDATE/DELETE/INSERT statements.
11104 16 The provider could not support insertion on this table.
11105 16 The provider could not support updates on this table.
11106 16 The provider could not support deletion on this table.
11107 16 The provider could not support a row lookup position.
11108 16 The provider could not support a required property.
11109 16 The provider does not support an index scan on this data source.
11201 16 This message could not be delivered because the FROM service name is missing. The message origin is: ‘%ls’.
11202 16 This message has been dropped because the FROM service name exceeds the maximum size of %d bytes. Service name: “%.*ls”. Message origin: “%ls”.
11203 16 This message has been dropped because the FROM broker instance is missing. The message origin is ‘%ls’.
11204 16 This message has been dropped because the FROM broker instance exceeds the maximum size of %d bytes. Broker instance: “%.*ls”. Message origin: “%ls”.
11205 16 This message has been dropped because the TO service name is missing. The message origin is “%ls”.
11206 16 This message has been dropped because the TO service name exceeds the maximum size of %d bytes. Service name: “%.*ls”. Message origin: “%ls”.
11207 16 This message has been dropped because the service contract name is missing. The message origin is “%ls”.
11208 16 This message has been dropped because the service contract name exceeds the maximum size of %d bytes. Contract name “%.*ls”. Message origin: “%ls”.
11209 16 This message could not be delivered because the conversation ID could not be associated with an active conversation. The message origin is: ‘%ls’.
11210 16 This message has been dropped because the TO service could not be found. Service name: “%.*ls”. Message origin: “%ls”.
11211 16 This message has been dropped because the user does not have permission to access the target database. Database ID: %d. Message origin: "%ls".
11212 16 This message could not be delivered because the conversation endpoint has already been closed.
11213 16 This message could not be delivered because this is not the first message in the conversation.
11214 16 This message could not be delivered because the ‘%.*ls’ contract could not be found or the service does not accept conversations for the contract.
11215 16 This message could not be delivered because the user with ID %i in database ID %i does not have permission to send to the service. Service name: ‘%.*ls’.
11216 16 This message could not be delivered because there is already another task processing this message.
11217 16 This message could not be delivered because it is out of sequence with respect to the conversation. Conversation receive sequence number: %I64d, Message sequence number: %I64d.
11218 16 This message could not be delivered because it is a duplicate.
11219 16 This message could not be delivered because the destination queue has been disabled. Queue ID: %d.
11220 16 This message could not be delivered because the TO broker instance is missing.
11221 16 This message could not be delivered because there is an inconsistency in the message header.
11222 16 This message could not be delivered because the TO service name in the message does not match the name in the conversation endpoint. Message TO Service Name: ‘%.*ls’. Conversation Endpoint TO Service Name: ‘%.*ls’.
11223 16 This message could not be delivered because the service contract name in the message does not match the name in the conversation endpoint. Message service contract name: ‘%.*ls’. Conversation endpoint service contract name: ‘%.*ls’.
11224 16 This message could not be delivered because another instance of this service program has already started conversing with this endpoint.
11225 16 This message could not be delivered because the message type name could not be found. Message type name: ‘%.*ls’.
11226 16 This message could not be delivered because the message type is not part of the service contract. Message type name: ‘%.*ls’. Service contract name: ‘%.*ls’.
11227 16 This message could not be delivered because the initiator service has sent a message with a message type that can only be sent by the target. Message type name: ‘%.*ls’. Service contract name: ‘%.*ls’.
11228 16 This message could not be delivered because the target service has sent a message with a message type that can only be sent by the initiator. Message type name: ‘%.*ls’. Service contract name: ‘%.*ls’.
11229 16 This message could not be delivered because the security context could not be retrieved.
11230 16 This message could not be delivered because the message could not be decrypted and validated.
11231 16 This message could not be delivered because the conversation endpoint is not secured, however the message is secured.
11232 16 This message could not be delivered because the conversation endpoint is secured, however the message is not secured.
11233 16 This message has been dropped because the session key of the conversation endpoint does not match that of the message.
11234 16 This message could not be delivered because an internal error was encountered while processing it. Error code %d, state %d: %.*ls.
11235 16 Received a malformed message. The binary message class (%d:%d) is not defined. This may indicate network problems or that another application is connected to the Service Broker endpoint.
11236 16 A corrupted message has been received. The binary header size of %d is expected, however the header size received was %d.
11237 16 A %S_MSG message could not be processed due to insufficient memory. The message was dropped.
11238 16 A corrupted message has been received. The private variable data segment is malformed.
11239 16 A corrupted message has been received. The private variable data segment extends beyond the length of the message.
11240 16 A corrupted message has been received. The binary message preamble is malformed.
11241 16 A corrupted message has been received. The conversation security version number is not %d.%d.
11242 16 A corrupted message has been received. The maximum number of public variable data elements (%d) has been exceeded. Public variable data elements found: %d.
11243 16 A corrupted message has been received. The public variable data element (%d) has been duplicated in this message.
11244 16 A corrupted message has been received. The handshake validation header is malformed.
11245 16 A corrupted message has been received. The maximum number of private variable data elements (%d) has been exceeded. Private variable data elements found: %d.
11246 16 A corrupted message has been received. The private variable data element (%d) has been duplicated in this message.
11247 16 A corrupted message has been received. The login negotiate header is invalid.
11248 16 A corrupted message has been received. The SSPI login header is invalid.
11249 16 A corrupted message has been received. The pre-master-secret is invalid.
11250 16 A corrupted message has been received. The security certificate key fields must both be present or both be absent. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11251 16 A corrupted message has been received. The service pair security header source certificate and the signature must both be present or both be absent. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I6
11252 16 A corrupted message has been received. The destination certificate serial number is missing. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11253 16 A corrupted message has been received. The service pair security header destination certificate, the key exchange key, the key exchange key ID, and the session key must all be present or all be absent. This occurred in the message with Conversation ID ‘%.
11254 16 A corrupted message has been received. The session key ID is missing. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11255 16 A corrupted message has been received. The encryption flag is set, however the message body, MIC or salt is missing. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11256 16 A corrupted message has been received. The MIC is present, however the message body or encryption flag is missing. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11257 16 A corrupted message has been received. The MIC and session key ID are in an invalid state. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11258 16 A corrupted message has been received. The MIC size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11259 16 A corrupted message has been received. The certificate serial number size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11260 16 A corrupted message has been received. The certificate issuer name size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11261 16 A corrupted message has been received. The destination certificate serial number size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64
11262 16 A corrupted message has been received. The destination certificate issuer name size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11263 16 A corrupted message has been received. The service pair security header size is %d, however it must be between %d and %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11264 16 A corrupted message has been received. The key exchange key size is %d, however it must be between %d and %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11265 16 A corrupted message has been received. The key exchange key ID is invalid. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11266 16 A corrupted message has been received. The encrypted session key size is %d, however it must be %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11267 16 A corrupted message has been received. The session key ID size is %d, however it must be %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11268 16 A corrupted message has been received. The salt size is %d, however it must be %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11269 16 A corrupted message has been received. A UNICODE string is not two byte aligned within the message. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11270 16 A corrupted message has been received. A UNICODE string is greater than the maximum allowed size of %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11271 16 A corrupted message has been received. The conversation ID must not be NULL. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11272 16 A corrupted message has been received. The message ID must not be NULL.
11273 16 A corrupted message has been received. The message body is not properly padded for encryption. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11274 16 A corrupted message has been received. A sequence number is larger than allowed. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11275 16 A corrupted message has been received. The End of Conversation and Error flags are both set. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11276 16 A corrupted message has been received. The End of Conversation flag has been set on an unsequenced message. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11277 16 A corrupted message has been received. The End of Conversation and Error flags may not be set in the first sequenced message. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11278 16 A corrupted message has been received. The message type is missing for this message. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11279 16 A corrupted message has been received. The message type must not be set in this message. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.
11280 16 A packet of size %lu bytes could not be processed because it exceeds the receive buffer count.
11281 16 A corrupted message has been received. The private portion of the message header is malformed.
11282 16 This message has been dropped due to licensing restrictions. See the documentation for further details.
11285 16 This forwarded message has been dropped because the hops remaining count has reached 0.
11286 16 Dropped this forwarded message because this SQL Server instance is out of memory.
11288 16 This forwarded message has been dropped because a duplicate message is already being forwarded.
11289 16 This forwarded message has been dropped because its memory usage would exceed the configured memory limit of %d bytes for forwarded messages.
11290 16 This forwarded message was dropped because the message could not be delivered within the message time to live. This may indicate that the forwarding route is incorrectly configured or that the destination is unavailable.
11291 16 This forwarded message has been dropped because the time consumed has exceeded the message’s time to live of %u seconds (the message arrived with %u seconds consumed and used %u seconds in this broker).
11292 16 The forwarded message has been dropped because a transport send error occurred when sending the message. Check previous events for the error.
11293 16 This forwarded message has been dropped because a transport is shutdown.
11294 16 This forwarded message has been dropped because the destination route is not valid.
11295 10 Endpoint configuration change detected. Service Broker manager and transport will now restart.
11296 10 Certificate change detected. Service Broker manager and transport will now restart.
11297 16 A corrupted message has been received. The private variable data segment offset is incorrect.
11298 16 A corrupted message has been received. The public variable data segment offset is incorrect.
11299 10 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.
11300 10 Error wile committing a readonly or a TEMPDB XDES, Shutting down the server.
11301 10 Error while performing transaction notification for object %p event %d.
11302 10 Error during rollback. shutting down database (location: %d).
11303 10 Error releasing reserved log space: %ls space %I64d, code %d, state %d.
11304 10 Failed to record outcome of a local two-phase commit transaction. Taking database offline.
11400 16 ALTER 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
11401 16 ALTER TABLE SWITCH statement failed. Table ‘%.*ls’ is %S_MSG, but index ‘%.*ls’ on indexed view ‘%.*ls’ is %S_MSG.
11402 16 ALTER 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
11403 16 ALTER 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
11404 16 ALTER 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
11405 16 ALTER 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
11406 16 ALTER TABLE SWITCH statement failed. Source and target partitions have different values for the DATA_COMPRESSION option.
11407 16 Vardecimal storage format can not be enabled for ‘%.*ls’. Only Enterprise edition of SQL Server supports vardecimal.
11408 16 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.
11409 16 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.
11410 16 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.
11411 16 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.
11412 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same sparse storage attribute in tables ‘%.*ls’ and ‘%.*ls’.
11413 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same column set property in tables ‘%.*ls’ and ‘%.*ls’.
11414 10 Warning: Option %ls is not applicable to table %.*ls because it does not have a clustered index. This option will be applied only to the table’s nonclustered indexes, if it has any.
11415 16 Object ‘%.*ls’ cannot be disabled or enabled. This action applies only to foreign key and check constraints.
11418 16 Cannot %S_MSG table ‘%.*ls’ because the table either contains sparse columns or a column set column which are incompatible with compression.
11551 10 ABR – Operation is aborted; error ‘0x%x’
11552 10 ABR – Insufficient disk space to write backup’
11553 10 ABR – Cannot create temporary backup file ‘%.*ls’; error ‘0x%x’
11554 10 ABR – Cannot create the virtual device set interface; error ‘0x%x’
11555 10 ABR – Database ‘%ls’ is corrupt
11556 10 ABR – Database backup for ‘%ls’ is corrupt
11557 10 ABR – The backup file ‘%.*ls’ does not exist; error ‘0x%x’
11558 10 ABR – Cannot open the backup file ‘%.*ls’; error ‘0x%x’
11559 10 ABR – Cannot create the backupset metadata; error ‘0x%x’
11560 10 ABR – Cannot delete the backupset metadata; error ‘0x%x’
11561 10 ABR – Cannot delete a backup file
11562 10 ABR – Can not acquire a lock on database ‘%ls’
11563 10 ABR – Transaction log for database ‘%ls’ is corrupt
11564 10 ABR – Cannot find the IO throttler for drive ‘%.*ls’
11565 10 ABR – Cannot open device ‘%.*ls’; error ‘0x%x’
11566 10 ABR – Cannot query device ‘%.*ls’; error ‘0x%x’
11567 10 ABR – Database ‘%ls’ is offline.
11599 10 ABR – Unknown ABR error
12002 16 The requested %S_MSG index on column ‘%.*ls’ of table ‘%.*ls’ could not be created because the column type is not %S_MSG . Specify a column name that refers to a column with a %S_MSG data type.
12003 16 Could not find spatial tessellation scheme ‘%.*ls’. Specify a valid tessellation scheme name in your USING clause.
12004 16 Could not find the default spatial tessellation scheme for the column ‘%.*ls’ on table ‘%.*ls’. Make sure that the column reference is correct, or specify the extension scheme in a USING clause.
12005 16 Incorrect parameters were passed to the CREATE %S_MSG statement near ‘%.*ls’. Validate the statement against the index-creation syntax.
12006 16 Duplicate parameters were passed to the create index statement. Validate the statement against the index-creation syntax.
12007 16 The CREATE %S_MSG statement is missing the required parameter ‘%.*ls’. Validate the statement against the index-creation syntax.
12008 16 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.
12009 16 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
12010 16 Only one spatial index hint may appear per table, either as the first or the last hinted index.
12011 16 The value of parameter ‘%.*ls’ of CREATE %S_MSG must be less than %d.
12012 16 The value of parameter ‘%.*ls’ of CREATE %S_MSG must be greater than %d.
12013 16 The value of parameter ‘%.*ls’ of CREATE %S_MSG must be greater than the value of parameter ‘%.*ls’.
12014 16 The ‘%.*ls’ parameter of CREATE %S_MSG is incompletely defined. If the parameter has more than one part, all the parts must be defined.
12015 16 The index option %.*ls in the CREATE %S_MSG statement has to appear before the general index options.
12016 16 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
12017 10 The spatial index is disabled or offline
12018 10 The spatial object is not defined in the scope of the predicate
12019 10 Spatial indexes do not support the comparand supplied in the predicate
12020 10 Spatial indexes do not support the comparator supplied in the predicate
12021 10 Spatial indexes do not support the method name supplied in the predicate
12022 10 The comparand references a column that is defined below the predicate
12023 10 The comparand in the comparison predicate is not deterministic
12024 10 The spatial parameter references a column that is defined below the predicate
12025 10 Could not find required binary spatial method in a condition
12026 10 Could not find required comparison predicate
12101 16 Cannot disable change tracking on database ‘%.*ls’ while client connections are waiting on change notification. Please close those connections before disabling change tracking.
12980 16 Supply either %s or %s to identify the log entries.
12981 16 You must specify %s when creating a subplan.
12982 16 Supply either %s or %s to identify the plan or sub-plan to be run.
13001 16 file name
13002 16 audit
13003 16 audit specification
13004 16 audit name
13008 0 receive
13010 0 read
13012 0 a USE database statement
13013 0 a procedure, function or trigger
13014 0 indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations
13015 0 spatial index operations
13016 0 an INTO clause
13018 0 a COMPUTE clause
13019 0 a SELECT INTO statement
13020 0 option
13021 0 offset option
13022 0 statistics option
13024 0 function name
13025 0 varbinary (128) NOT NULL
13026 0 parameter
13027 0 convert specification
13028 0 index
13029 0 table
13030 0 database
13031 0 procedure
13032 0 trigger
13033 0 view
13034 0 default
13035 0 rule
13036 0 system table
13037 0 unknown type
13038 0 SET option
13039 0 column
13040 0 type
13041 0 character string
13042 0 integer
13043 0 identifier
13044 0 number
13045 0 indexes
13047 0 object
13049 0 built-in function name
13050 0 aggregate function
13051 0 XML INDEX
13052 0 CLR type
13053 0 xml schema collection
13054 0 EXTENDED INDEX
13055 0 SPATIAL INDEX
13056 0 spatial
13057 0 a planguide batch
13058 0 geometry
13059 0 conversation priority
13076 0 an assignment
13077 0 a cursor declaration
13078 0 replication filter
13079 0 variable assignment
13080 0 statistics
13081 0 file
13082 0 filegroup
13083 0 server
13084 0 write
13085 0 function
13086 0 database collation
13087 0 drop
13088 0 alter
13089 0 message type
13090 0 contract
13092 0 service
13093 0 queue
13094 0 table valued function
13095 0 event notification
13096 0 synonym
13097 0 lock
13098 0 thread
13099 0 communication buffer
13100 0 Common Language Runtime critical section
13101 0 partition scheme
13102 10 DETACH
13103 0 HASH
13104 0 RANGE
13105 0 create
13106 0 route
13107 0 remote service binding
13108 0 Initiator
13109 0 Target
13110 0 host synchronization object
13111 0 generic waitable object
13112 0 application role
13113 0 schema
13114 0 user
13115 0 login
13116 0 certificate
13117 0 role
13118 0 find
13119 0 endpoint
13120 0 sql:variable
13121 0 sql:column
13122 0 XML namespace
13123 0 assembly
13124 0 fulltext catalog
13125 16 execute as
13126 16 symmetric key
13127 16 principal
13128 16 security descriptor
13129 16 hypothetical index
13130 16 nonclustered index
13131 16 credential
13132 0 transfer
13133 0 Cumulative wait time (ms) per second
13134 0 Waits started per second
13135 0 Waits in progress
13136 0 Average wait time (ms)
13137 0 Cumulative execution time (ms) per second
13138 0 Execs started per second
13139 0 Execs in progress
13140 0 Average execution time (ms)
13141 16 asymmetric key
13142 0 an INSERT SELECT statement
13143 16 partition function
13144 16 partition scheme
13145 16 encryption
13146 16 signature
13147 16 password
13148 16 rename
13149 16 end dialog
13150 16 END CONVERSATION WITH ERROR
13151 16 MOVE CONVERSATION
13152 16 receive sequenced message
13153 16 receive end conversation
13154 16 receive end conversation with error
13155 16 receive broker error
13156 16 receive message acknowledgement
13157 16 terminate conversation
13158 16 broker error
13159 16 countersignature
13160 16 BEGIN CONVERSATION TIMER
13161 16 fire conversation timer
13162 16 END CONVERSATION WITH CLEANUP
13163 16 BEGIN DIALOG CONVERSATION
13164 16 SEND
13165 16 conversation
13166 16 conversation group
13167 16 system
13168 16 Service Broker
13169 16 Database Mirroring
13170 0 table or indexed view
13171 16 conversation handle
13172 16 GET CONVERSATION GROUP
13173 16 master key
13174 16 another assembly with same SQL name is already present in the current database
13175 16 version, culture or public key mismatch
13176 0 component
13177 16 IL compilation
13178 16 Inproc data access
13179 16 DDL operations
13180 16 execution cache cleanup
13181 16 unspecified operation
13182 16 dialog
13183 10 The certificate’s private key cannot be found
13184 10 The certificate’s private key size is incompatible with the crypto provider
13185 10 The certificate’s public key size is incompatible with the crypto provider
13186 10 The certificate’s private key size is incompatible with the encrypted key exchange key
13187 10 The certificate’s public key size is incompatible with the security header’s signature
13188 10 The certificate’s private key is password protected
13189 10 The key exchange key has an invalid size after being decrypted with the certificate private key
13190 10 The database principal used to lookup the cert is invalid
13191 10 The database principal has no mapping to a server principal
13192 10 The certificate is disabled for BEGIN DIALOG
13193 16 encryption algorithm
13194 16 authentication protocol
13195 10 Certificate not found
13196 10 Certificate not yet valid
13197 10 Certificate expired
13198 10 Certificate is larger than maximum allowed size
13199 10 message timestamp
13202 10 TO BROKER INSTANCE
13203 10 TO SERVICE
13204 10 FROM BROKER INSTANCE
13205 10 FROM SERVICE
13206 10 SERVICE CONTRACT
13207 10 MESSAGE TYPE
13208 10 MESSAGE INTEGRITY CHECK
13209 10 KEY SALT
13210 10 SESSION KEY
13211 10 KEY EXCHANGE KEY
13212 10 SOURCE CERTIFICATE ISSUER NAME
13213 10 SOURCE CERTIFICATE SERIAL NUMBER
13214 10 DESTINATION CERTIFICATE ISSUER NAME
13215 10 DESTINATION CERTIFICATE SERIAL NUMBER
13216 10 SECURITY HEADER SIGNATURE
13217 10 MESSAGE BODY
13218 10 STATEMENT
13219 10 clustered index
13220 10 primary xml index
13221 10 Failover
13222 10 Auto Failover
13223 10 Failover from partner
13224 10 Role Synchronization
13225 10 Force_Service_Allow_Data_Loss
13226 10 add
13227 10 to
13228 10 from
13229 10 enable
13230 10 disable
13231 10 remap
13232 10 INSERT
13233 10 UPDATE
13234 10 DELETE
13235 10 WHEN MATCHED
13236 10 WHEN NOT MATCHED
13237 10 WHEN NOT MATCHED BY SOURCE
13238 10 TOP
13239 10 GROUP BY
13240 10 HAVING
13241 10 ORDER BY
13242 10 COMPUTE
13243 10 OUTPUT INTO
13244 10 SELECT
13245 10 WHERE
13246 10 unexpected
13254 10 event
13255 10 target
13256 10 event action
13257 10 event session
13258 10 event package
13259 10 event object
13260 10 event predicate comparator
13261 10 event attribute or predicate source
13262 10 customizable attribute
13263 10 event predicate
13264 10 predicate source
13265 10 event attribute
13266 10 partitioned
13267 10 not partitioned
13268 10 resource pool
13269 10 workload group
13270 10 resource governor
13271 10 move
13272 10 UPDATETEXT
13273 10 WRITETEXT
13274 10 torn page (expected signature: 0x%08x; actual signature: 0x%08x)
13275 10 incorrect checksum (expected: 0x%08x; actual: 0x%08x)
13276 10 invalid protection option
13277 10 invalid encryption key
13278 10 unable to decrypt page
13279 10 decryption failure (expected: 0x%08x; actual: 0x%08x)
13280 10 unable to decrypt page due to missing DEK
13281 10 CREATION_DISPOSITION
13282 10 PROVIDER_KEY_NAME
13283 10 key source
13284 10 ENCRYPTION BY
13285 10 public key
13286 10 private key
13287 10 cryptographic provider
13288 10 cryptographic provider DLL path
13289 10 cryptographic provider friendly name
13290 10 version
13291 10 guid
13292 10 create credential for
13293 10 cryptographic provider key name
13294 10 key persistence
13295 10 cryptographic provider key thumbprint length
13296 10 cryptographic provider key blob length
13297 16 encryption algorithm tag
13298 16 name
13299 16 thumbprint
13301 16 IV(Initialization Vector) length
13302 16 bit length
13303 16 constraint
13304 16 database encryption key
13371 10 partition functions can only be created in Enterprise, Developer or Evaluation editions of SQL Server
13372 10 support for increased partitions cannot be changed inside a user transaction
13373 16 Anchor record
13374 16 Page dictionary
13375 16 Compression information structure
13376 10 Fulltext Query String
13377 10 Fulltext Query Language
13378 10 Fulltext Query Max Keys
13379 10 fulltext stoplist
13380 10 Success – Consult EKM Provider for details
13381 10 Failure – Consult EKM Provider for details
13382 10 Insufficient Buffer – Consult EKM Provider for details
13383 10 Not Supported – Consult EKM Provider for details
13384 10 Object Not Found – Consult EKM Provider for details
13385 10 Authentication Failure – Consult EKM Provider for details
13386 10 Invalid Argument – Consult EKM Provider for details
13387 10 Provider Error – No explanation is available, consult EKM Provider for details
13388 10 Key Flags
13389 10 Key Name
13390 10 Key Type
13391 10 there are partitioning functions with over 1000 partitions. Drop the partition functions or merge the partitions until none exceeds 1000 partitions
13392 10 it is a system database. System databases cannot be enabled for increased partitions
13393 10 it acts as a distribution database. A distribution database cannot be enabled for increased partitions
13394 10 an internal error occurred
13395 10 it is involved in a mirroring session. Turn off the mirroring session and try again
13396 10 it is not in SIMPLE recovery mode. Change the recovery model to SIMPLE and try again
13397 10 it is a database snapshot. A database snapshot cannot be enabled for increased partitions
13400 10 Extended stored procedure API will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
13401 10 Non-ANSI ‘*=’ and ‘=*’ outer join operators will be removed in the next version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. Use ANSI outer joins instead.
13402 10 The ability to INSERT NULL values into TIMESTAMP columns will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. Use DEFAULT instead.
13403 10 The ability to use string literals as column aliases will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. Use AS clause instead.
13404 10 The ability to use ‘#’ and ‘##’ as the name of temporary tables and stored procedures will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
13405 10 The ability to use ‘@’ and names that start with ‘@@’ as Transact-SQL identifiers will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
13406 10 The ability to use the DEFAULT keyword as a default value will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
13407 10 FASTFIRSTROW hint will be removed in the next version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. Use OPTION (FAST n) instead.
13408 10 %ls will be removed in the next version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
13409 10 Collation ‘%ls’ will be removed in a future version of SQL Server. Avoid using this collation in new development work, and plan to modify applications that currently use it.

sql server error list 11000 to 14000
sql server error list error codes 11000 to 14000
sql server error numbers 11000 to 14000
sql server error list 2005 11000 to 14000
sql server error list 2008 11000 to 14000
sql server 2008 error message list 11000 to 14000
sql server errors logs
sql server errors list table

(Visited 418 times, 1 visits today)