Redaguoti

Bendrinti naudojant


Database Engine events and errors (10000 to 10999)

This article contains error message numbers (between the range 10,000 and 10,999) and their description, which is the text of the error message from the sys.messages catalog view. Where applicable, the error number is a link to further information.

For the full range of error numbers, see the list on Database Engine events and errors.

You can query the Database Engine to see a full list of all errors, by running the following query against the sys.messages catalog view:

SELECT message_id AS Error,
    severity AS Severity,
    [Event Logged] = CASE is_event_logged
        WHEN 0 THEN 'No' ELSE 'Yes'
        END,
    [text] AS [Description]
FROM sys.messages
WHERE language_id = 1040 /* replace 1040 with the desired language ID, such as 1033 for US English */
ORDER BY message_id;

SQL Server version

This article shows events and errors (between the range 10,000 and 10,999) for SQL Server 2016 (13.x). If you want to view events and errors for other versions of SQL Server, see:

This article shows events and errors (between the range 10,000 and 10,999) for SQL Server 2017 (14.x). If you want to view events and errors for other versions of SQL Server, see:

This article shows events and errors (between the range 10,000 and 10,999) for SQL Server 2019 (15.x). If you want to view events and errors for other versions of SQL Server, see:

This article shows events and errors (between the range 10,000 and 10,999) for SQL Server 2022 (16.x). If you want to view events and errors for other versions of SQL Server, see:

Errors and events (10000 to 10999)

Error Severity Event logged Description
10000 16 No Unknown provider error.
10001 16 No The provider reported an unexpected catastrophic failure.
10002 16 No The provider did not implement the functionality.
10003 16 No The provider ran out of memory.
10004 16 No One or more arguments were reported invalid by the provider.
10005 16 No The provider did not support an interface.
10006 16 No The provider indicated an invalid pointer was used.
10007 16 No The provider indicated an invalid handle was used.
10008 16 No The provider terminated the operation.
10009 16 No The provider did not give any information about the error.
10010 16 No The data necessary to complete this operation was not yet available to the provider.
10011 16 No Access denied.
10021 16 No Execution terminated by the provider because a resource limit was reached.
10022 16 No The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.
10023 16 No The provider does not support the necessary method.
10024 16 No The provider indicates that the user did not have the permission to perform the operation.
10025 16 No Provider caused a server fault in an external process.
10026 16 No No command text was set.
10027 16 No Command was not prepared.
10028 16 No Authentication failed.
10032 16 No Cannot return multiple result sets (not supported by the provider).
10033 16 No The specified index does not exist or the provider does not support an index scan on this data source.
10034 16 No The specified table or view does not exist or contains errors.
10035 16 No No value was given for one or more of the required parameters.
10042 16 No Cannot set any properties while there is an open rowset.
10052 16 No The insertion was canceled by the provider during notification.
10053 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10054 16 No The data value for one or more columns overflowed the type used by the provider.
10055 16 No The data violated the integrity constraints for one or more columns.
10056 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10057 16 No Cannot create the row. Would exceed the total number of active rows supported by the rowset.
10058 16 No The consumer cannot insert a new row before releasing previously-retrieved row handles.
10062 16 No The change was canceled by the provider during notification.
10063 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10064 16 No The data value for one or more columns overflowed the type used by the provider.
10065 16 No The data violated the integrity constraints for one or more columns.
10066 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10067 16 No 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 No The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.
10069 16 No The consumer could not delete the row. The insertion has been transmitted to the data source.
10081 16 No The rowset uses integrated indexes and there is no current index.
10085 16 No RestartPosition on the table was canceled during notification.
10086 16 No The table was built over a live data stream and the position cannot be restarted.
10087 16 No The provider did not release some of the existing rows.
10088 16 No 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 No 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 columns.
10101 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TOP or OFFSET keyword. Consider removing the TOP or OFFSET or not indexing the view.
10102 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing the view.
10103 16 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
10106 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal system rowset provider. Consider not indexing this view.
10107 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it references a SQL Server internal table.
10109 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
10111 16 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the PIVOT operator. Consider not indexing this view.
10115 16 No Cannot create %S_MSG on view "%.*ls" because it uses the UNPIVOT operator. Consider not indexing this view.
10116 16 No 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 No Cannot create %S_MSG on view "%.*ls" because the view uses the "*" operator to select columns. Consider referencing columns by name instead.
10118 16 No Cannot create %S_MSG on view "%.*ls" because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
10119 16 No Cannot create %S_MSG on view "%.*ls" because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
10120 16 No Cannot create %S_MSG on view "%.*ls" because it contains the ROLLUP operator. Consider not indexing this view.
10121 16 No Cannot create %S_MSG on view "%.*ls" because it contains a HAVING clause. Consider removing the HAVING clause.
10122 16 No 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.
10124 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal SQL Server column.
10125 16 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because function "%.*ls" referenced by the view performs user or system data access.
10134 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the aggregate COUNT. Use COUNT_BIG instead.
10137 16 No 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 No 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 No 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 No Cannot create %S_MSG on view '%.*ls' because the view contains a table hint. Consider removing the hint.
10141 16 No 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 create index.
10142 16 No Cannot create %S_MSG on view "%.*ls" because it contains an APPLY. Consider not indexing the view, or removing APPLY.
10143 16 No 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 No Cannot create %S_MSG on view '%.*ls' because it uses the CHANGETABLE function.
10145 16 No 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.
10146 16 No Cannot create %S_MSG on the view '%.*ls' because it uses the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function.
10211 16 No Cannot invoke mutator on a null CLR type value.
10227 16 No Field "%.*ls" of type "%.*ls.%.*ls" cannot be updated because the field is "%.*ls".
10240 16 No Could not find UdtExtensions.dll. Please check your installation.
10300 16 No 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 failed (reason: %S_MSG). Please load the referenced assembly into the current database and retry your request.
10301 16 No 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 failed (reason: %s). Please load the referenced assembly into the current database and retry your request.
10302 16 No Could not get path for SQL Server: '%ls'.
10303 16 Yes Could not create AppDomain manager: '%.*ls'.
10304 16 No Failed to enter Common Language Runtime (CLR) with HRESULT 0x%x. This may due to low resource conditions.
10305 16 No The Init method for a CLR table-valued function must be annotated with SqlFunctionAttribute.
10306 16 No The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.
10307 16 No The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.
10308 10 No 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 routine may stop working. Please refer SQL Server Books Online for more details.
10309 10 No Warning: The SQL Server client assembly '%.*ls' you are registering is not fully tested in SQL Server hosted environment.
10310 10 Yes AppDomain %i (%.*ls) is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.
10311 10 Yes AppDomain %i (%.*ls) is marked for unload due to memory pressure.
10312 16 No .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.
10313 16 No 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 No 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 documentation to see how to solve the assembly trust issues. For more information about this error: %.*ls
10316 16 No The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found.
10317 16 No An error occurred trying to get file version info for the file '%s'.
10318 16 No '%.*ls' failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10319 16 No UserDefinedType method call failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10320 16 No Method name '%.*ls' is invalid for '%.*ls'.
10321 16 No Method name '%.*ls' is invalid for UserDefinedType method call.
10322 16 No Type %.*ls not found in database %.*ls
10323 16 Yes Invalid user code has been identified by .Net Framework Managed Debug Assistant %.*ls
10324 16 No WITH ENCRYPTION option of CREATE TRIGGER is only applicable to T-SQL triggers and not to CLR triggers.
10325 16 Yes The server is shutting down due to stack overflow in user's unmanaged code.
10326 16 Yes Two versions of assembly '%.*ls' cannot coexist in database '%.*ls'. Keep one version and drop the other.
10327 14 No %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 TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with %ls permission.
10328 16 No There is not enough stack to create appdomain '%.*ls'.
10329 16 No .Net Framework execution was aborted. %.*ls
10330 16 No 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 No Type '%ls' in assembly '%.*ls' derives from a generic type which is not supported for a CLR Type.
10332 16 No Assembly "%.*ls" was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s.
10333 16 Yes Failed to obtain ICLRAppDomainResourceMonitor interface from CLR. The error code from CLR was: 0x%x. As a result, resource monitoring won't work for AppDomain with ID %d.
10334 16 No Changing the database compatibility level has caused data to be marked as unchecked in one or more objects in database %s. Refer to the column has_unchecked_assembly_data in the sys.tables and sys.views to locate all such objects.
10335 16 No The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features.
10336 10 No Failed to enque task to start CLR during SQL server startup. Error code: %u. CLR will be started in an on-demand fashion.
10337 16 No An internal error occurred.
10338 16 No Verification of assembly failed. Could not open the physical file '%.*ls': %ls.
10339 16 No Verification of assembly failed. Could not read from the physical file "%.*ls": %ls.
10340 16 No DROP ASSEMBLY failed. Error code: 0x%x.
10341 16 No Assembly '%.*ls' cannot be loaded because the assembly is not allowed for use in Azure SQL Database. Contact Azure Technical Support if you have questions.
10501 16 No Cannot create plan guide '%.*ls' because type '%.*ls' provided is not allowed.
10502 16 No 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 plan guide.
10503 16 No Operation '%.*ls' is not allowed.
10504 16 No Cannot create plan guide '%.*ls' because parameter @hints is incorrect. Use N'OPTION ( <query_hint> [ ,...n ] )'.
10505 16 No 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 No Cannot create plan guide '%.*ls' because parameter @stmt has more than one statement.
10507 16 No 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 module or batch.
10508 16 No 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 No 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 statement within the batch. To obtain a valid starting position, query the 'statement_start_offset' column in the sys.dm_exec_query_stats dynamic management function.
10510 16 No Cannot create plan guide '%.*ls' because there is already a plan guide with that name in the database. Use a unique name.
10511 16 No Cannot create plan guide '%.*ls' because @params is not NULL. @params must be NULL if @type is 'object'.
10512 16 No 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 No 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.
10514 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be large object when @type is object.
10515 16 No Cannot create plan guide '%.*ls' because the module '%.*ls' does not exist or you do not have needed permission.
10516 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be compiled.
10517 16 No Cannot create plan guide '%.*ls' because you do not have needed permission. Alter database permission required.
10518 16 No 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 No 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 No 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-NULL value for the parameter.
10521 16 No 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 for the parameter.
10522 16 No 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 No Cannot generate query template because @querytext does not contain a valid single query.
10524 16 No Cannot parameterize @querytext.
10525 10 No 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 this plan guide or removing RECOMPILE from it.
10526 16 No 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 No Cannot create plan guide '%.*ls' because the object '%.*ls' is a temporary object.
10528 16 No Cannot create plan guide '%.*ls' because its name is invalid. Plan guide name cannot begin with a '#' character.
10529 16 No Cannot create plan guide '%.*ls' because there is already a planguide '%.*ls' of @type 'template' on @stmt.
10530 16 No 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 No 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 No 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 No 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 No Cannot create plan guide '%.*ls' because the value specified for @params is invalid. Specify the value in the form <parameter_name> <parameter_type>, or specify NULL.
10535 16 No 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 No 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 value for each statement.
10537 16 No 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 No 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 context, and you have ALTER permission on the object referenced by the plan guide or ALTER DATABASE permission.
10539 16 No 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 database objects exist, and execute the statement before creating the plan guide.
10601 16 No Cannot specify included columns for a clustered index.
10602 16 No Mixing old and new syntax in CREATE/ALTER/DROP INDEX statement is not allowed.
10603 16 No 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 No Cannot convert a statistic to an index using DROP_EXISTING index option when ONLINE index option is also specified.
10605 16 No Cannot disable primary key index "%.*ls" on table "%.*ls" because the table is published for replication.
10606 16 No Cannot disable the clustered index "%.*ls" on view "%.*ls" because the indexed view is published for replication.
10607 16 No 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 No 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 before disabling the index.
10609 16 No 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 No 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 incorporated in the view definition.
10611 16 No 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 not supported for filtered %S_MSG. To resolve this error, explicitly convert the constant to the same data type and collation as the column '%.*ls'.
10612 16 No 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 this comparison.
10617 16 No 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 No 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 No 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 No 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 No 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 No The %S_MSG '%.*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 No Filtered statistics '%.*ls' cannot be created on object '%.*ls' because it is not a user table. Filtered statistics are only supported on user tables.
10624 16 No The CREATE INDEX or REBUILD INDEX statement failed for index '%.*ls' on table '%.*ls' because a distribution policy cannot be specified for system databases.
10625 16 No A distribution key cannot be created containing more than %d columns.
10626 16 No Column name '%.*ls' appears more than one time in the list of columns in the distribution key.
10627 16 No Column '%.*ls' cannot be part of the distribution key of the index '%.*ls' because the column is not part of the unique index key. Distribution key columns for a unique index must be part of the index key.
10628 16 No Index '%.*ls' on table '%.*ls' is a hypothetical index that was created to hold column-level statistics. A distribution policy is not allowed for hypothetical indexes.
10629 16 No The data type specified for column '%.*ls' in table '%.*ls' cannot be used as a column in the distribution key of an index.
10630 16 No The index distribution policy is invalid. The policy must be set to HASH, NONE, or REPLICATE. Distribution columns cannot be specified when the distribution policy is set to NONE or REPLICATE.
10631 16 No Index '%.*ls' could not be created or rebuilt. A unique or clustered index on a federated table must contain the federated column.
10632 16 No Index '%.*ls' could not be created. Views cannot be indexed in a federated database.
10633 16 No Invalid online index creation operation
10634 10 Yes An '%.*ls' statement was executed on object '%.*ls' by hostname '%.*ls', host process ID %d using the WAIT_AT_LOW_PRIORITY options with MAX_DURATION = %d and ABORT_AFTER_WAIT = BLOCKERS. Blocking user sessions will be killed after the max duration of waiting time.
10635 16 No An online operation cannot be performed for '%.*ls' because the index contains column of large object type, and in the same transaction there are update operations before this online operation. Put the online operation outside the transaction or put it before any updates in the transaction.
10700 16 No The table-valued parameter "%.*ls" is READONLY and cannot be modified.
10701 15 No The READONLY option cannot be used in an EXECUTE or CREATE AGGREGATE statement.
10702 15 No The WITH CUBE and WITH ROLLUP options are not permitted with a ROLLUP, CUBE, or GROUPING SETS specification.
10703 15 No Too many grouping sets. The maximum number is %d.
10704 15 No To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.
10705 15 No Subqueries are not allowed in the OUTPUT clause.
10706 15 No Too many expressions are specified in the GROUP BY clause. The maximum number is %d when grouping sets are supplied.
10707 15 No 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 No DEFAULT is not allowed on the right hand side of "%.*ls"
10709 15 No The number of columns for each row in a table value constructor must be the same.
10710 15 No An action of type '%S_MSG' is not allowed in the 'WHEN NOT MATCHED' clause of a MERGE statement.
10711 15 No An action of type 'INSERT' is not allowed in the '%S_MSG' clause of a MERGE statement.
10713 15 No A MERGE statement must be terminated by a semi-colon (;).
10714 15 No An action of type '%S_MSG' cannot appear more than once in a '%S_MSG' clause of a MERGE statement.
10715 15 No '%.*ls' is not a valid hint.
10716 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.
10717 15 No The %S_MSG clause is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10718 15 No Query hints are not allowed in nested INSERT, UPDATE, DELETE, or MERGE statements.
10719 16 No Foreign key relationships from a memory optimized table with DURABILITY set to SCHEMA_AND_DATA to a memory optimized table with DURABILITY set to SCHEMA_ONLY are not supported.
10720 15 No An OUTPUT INTO clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10721 15 No The WHERE CURRENT OF clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10722 15 No The DISTINCT keyword is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10723 15 No 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 MERGE statement. Modify the SET clause to only specify assignments of the form 'SET @variable = column' or 'SET @variable = expression'.
10724 15 No The FORCESEEK hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10725 15 No Cannot use the VARYING option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
10726 15 No User defined aggregates do not support default parameters.
10727 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a JOIN or APPLY operator.
10728 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed as the table source of a PIVOT or UNPIVOT operator.
10729 15 No 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 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the FROM clause of an UPDATE or DELETE statement.
10731 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed inside another nested INSERT, UPDATE, DELETE, or MERGE statement.
10732 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a UNION, INTERSECT, or EXCEPT operator.
10733 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the USING clause of a MERGE statement.
10734 16 No Variable assignment is not allowed in a statement containing a top level UNION, INTERSECT or EXCEPT operator.
10735 15 No Incorrect WHERE clause for filtered %S_MSG '%.*ls' on table '%.*ls'.
10736 15 No A full-text stoplist statement must be terminated by a semi-colon (;).
10737 15 No 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 rebuilt, even if only a subset is specified in the DATA_COMPRESSION clause.
10738 15 No The number of row value expressions in the INSERT statement exceeds the maximum allowed number of %d row values.
10739 15 No The insert column list used in the MERGE statement cannot contain multi-part identifiers. Use single part identifiers instead.
10740 15 No A search property list statement must end with a semicolon (;).
10741 15 No A TOP can not be used in the same query or sub-query as a OFFSET.
10742 15 No The offset specified in a OFFSET clause may not be negative.
10743 15 No The number of rows provided for a OFFSET clause must be an integer.
10744 15 No The number of rows provided for a FETCH clause must be greater then zero.
10745 15 No The FORCESCAN hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10746 15 No The FORCESCAN hint is specified simultaneously with the FORCESEEK hint. Remove one of the hints and resubmit the query.
10747 15 No 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 hints for each table or view.
10748 15 No There are multiple FORCESEEK hints specified on the same table or view. Remove the extra FORCESEEK hints and resubmit the query.
10749 15 No The FORCESEEK hint cannot be used with index 0. Correct the index provided to the FORCESEEK hint and resubmit the query.
10750 15 No The FORCESCAN hint cannot be used with more than one INDEX hint. Remove the extra INDEX hints and resubmit the query.
10751 15 No The ORDER BY in WITHIN GROUP clause of '%.*ls' function must have exactly one expression.
10752 15 No The function '%.*ls' may not have a window frame.
10753 15 No The function '%.*ls' must have an OVER clause.
10754 15 No The function '%.*ls' must have a WITHIN GROUP clause.
10755 15 No The function '%.*ls' takes between %d and %d arguments.
10756 15 No Window frame with ROWS or RANGE must have an ORDER BY clause.
10757 15 No The function '%.*ls' may not have a WITHIN GROUP clause.
10758 15 No The function '%.*ls' may not have ORDER BY in OVER clause.
10759 15 No Use of DISTINCT is not allowed with the OVER clause.
10760 16 No Scale argument is not valid. Valid expressions for data type %ls scale argument are integer constants and integer constant expressions.
10761 16 No Invalid data type %.*ls in function %.*ls.
10762 16 No The %.*ls function is not allowed in the current compatibility mode. It is only allowed in 110 mode or higher.
10763 15 No GROUP BY clause can only contain one query hint. Remove the extra hints and re-run the query.
10764 15 No Number of grouping columns in the query exceeded maximum number allowed. SQL Server allows 64k grouping columns. Reduce number of grouping columns and re-run the query.
10765 15 No DISTRIBUTED_AGG and CENTRAL_AGG hints cannot be used with a CUBE or ROLLUP clause. Modify the query and re-run it.
10766 15 No CENTRAL_AGG must be specified after all columns in the GROUP BY clause. Modify the query and re-run it.
10767 15 No DISTRIBUTED_AGG hint cannot be used when the GROUP BY clause contains the same column more than once. Modify the query and re-run it.
10768 15 No LABEL hint can only be used one time in the query. Modify the query and re-run it.
10769 15 No SET options are not supported inside ATOMIC blocks.
10770 15 No The SERVER option and one of CREDENTIAL or FEDERATED_SERVICE_ACCOUNT = ON options are required for setting REMOTE_DATA_ARCHIVE on a database.
10771 15 No The CREDENTIAL option cannot be used with the FEDERATED_SERVICE_ACCOUNT = ON option.
10772 15 No There are multiple REMOTE_DATA_ARCHIVE_OVERRIDE hints specified on the same table or view reference. Remove the extra REMOTE_DATA_ARCHIVE_OVERRIDE hint(s) and resubmit the query.
10773 15 No The REMOTE_DATA_ARCHIVE_OVERRIDE hint is not applicable to object '%.*ls' because it is not a table with REMOTE_DATA_ARCHIVE enabled. Remove the REMOTE_DATA_ARCHIVE_OVERRIDE hint and resubmit the statement.
10774 15 No Incorrect WHERE clause for filtered index.
10775 16 No Object '%.*ls' is not a memory optimized table or a natively compiled inline table-valued function and cannot be accessed from a natively compiled module.
10776 16 No Triggers on non-memory optimized tables cannot use WITH NATIVE_COMPILATION.
10777 16 No Triggers on memory-optimized tables must use WITH NATIVE_COMPILATION.
10778 16 No Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported.
10779 16 No The durability option 'schema_only' is supported only with memory optimized tables.
10780 16 No There is no primary key in the referenced table '%.*ls' that matches the referencing column list in the foreign key '%.*ls'. Foreign keys in memory-optimized tables must reference primary keys.
10781 16 No Querytraceon %d and optimizer hint '%.*ls' specify conflicting behaviors. Remove one of them and rerun the query.
10782 16 No BEGIN ATOMIC is supported only in natively compiled modules.
10783 16 No The body of a natively compiled module must be an ATOMIC block.
10784 16 No The WITH clause of BEGIN ATOMIC statement must specify a value for the option '%ls'.
10785 15 No The %S_MSG '%ls' is supported only with %S_MSG.
10786 16 No The ALTER AVAILABILITY GROUP command failed because it contained multiple MODIFY REPLICA options: %ls. Enter a separate ALTER AVAILABILITY GROUP ... MODIFY REPLICA command for each replica option that you want to modify.
10787 16 No The REPEATABLEREAD and SERIALIZABLE hints are not permitted on Hekaton tables with columnstore indexes.
10788 15 No The option '%ls' is not supported with table types.
10789 15 No The option '%ls' must be specified for index '%.*ls' on table '%.*ls'. It is required for hash indexes.
10790 15 No The option '%ls' can be specified only for hash indexes.
10791 15 No Hash indexes are permitted only in memory optimized tables.
10792 15 No When used in a natively compiled module, the function '%.*ls' cannot appear outside of a catch block.
10793 16 No Both an index and a PRIMARY KEY constraint have been defined inline, with the definition of column '%.*ls', table '%.*ls'. Defining both an index and a PRIMARY KEY constraint inline with the column definition is not allowed.
10794 15 No The %S_MSG '%ls' is not supported with %S_MSG.
10795 15 No The variable '%.*ls' was declared as not null, and must be declared with an initial value.
10796 15 No The SCHEMABINDING option is supported only for natively compiled modules, and is required for those modules.
10797 15 No Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database.
10798 16 No This is not a valid data compression setting for this object. It can only be used with columnstore indexes. Please choose NONE, PAGE, or ROW compression.
10799 16 No This is not a valid data compression setting for a columnstore index. Please choose COLUMNSTORE or COLUMNSTORE_ARCHIVE compression.
10800 16 No The listener for the WSFC resource '%.*ls' failed to start, and returned error code %d, '%.*ls'. For more information about this error code, see "System Error Codes" in the Windows Development Documentation.
10801 16 No Failed to stop the listener for Windows Failover Cluster resource '%.*ls'. Error: %d. %.*ls
10802 10 No Failed to enqueue a task to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is added manually or SQL Server is restarted. SQLOS error code: %d.
10900 16 No 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 No User does not have permission to alter the resource governor configuration.
10902 16 No User-defined function '%s' does not exist in master database, or the user does not have permission to access it.
10903 16 No 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 No 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 No 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 No 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 No Attribute '%.*ls' with value of %u is greater than attribute '%.*ls' with value of %u.
10908 16 No Attribute '%.*ls' with value of %u is less than attribute '%.*ls' with value of %u.
10909 16 No The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools.
10910 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than or equal to 100.
10911 16 No Requested operation cannot be performed because the resource pool '%.*ls' does not exist.
10912 16 No The operation could not be completed. Dropping predefined %S_MSG is not allowed.
10913 16 No Users are not allowed to %S_MSG the workload group '%.*ls' in the '%.*ls' resource pool.
10914 16 No The name of the %S_MSG '%.*ls' cannot begin with # of ##.
10915 16 No The operation could not be completed. Altering '%.*ls' %S_MSG is not allowed.
10916 16 No 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 No ALTER WORKLOAD GROUP failed. Either a 'WITH' or 'USING' clause must be specified.
10918 16 No Cannot create %S_MSG '%.*ls' because it already exists.
10919 16 No 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 No Cannot %S_MSG user-defined function '%.*ls'. It is being used as a resource governor classifier.
10921 16 No The '%.*ls' %S_MSG cannot be moved out of '%.*ls' %S_MSG.
10922 16 No %ls failed. Rerun the statement.
10923 16 No %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 governor.
10924 16 No The pool affinity range is invalid. The lower bound %d must be less than the upper bound %d.
10925 16 No A %S_MSG value was specified more than one time in the pool affinity range list.
10926 16 No The %S_MSG range that specifies %S_MSG %d includes at least one %S_MSG that is not available to the current instance. The maximum %S_MSG number that is available to this instance is %d.
10927 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all workload groups using resource pool '%.*ls' to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.
10928 16 No Resource ID : %d. The %ls limit for the database is %d and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance.
10929 16 No Resource ID : %d. The %ls minimum guarantee is %d, maximum limit is %d and the current usage for the database is %d. However, the server is currently too busy to support %ls greater than %d for this database. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance. Otherwise, please try again later.
10930 16 No The service is currently too busy. Please try again later.
10931 16 No Cannot drop resource pool '%.*ls' because it is bound to a database. Remove all bindings to this resource pool before dropping it.
10932 16 No Resource governor configuration failed, because there is an active database in the resource pool being dropped. Take the database offline and try again.
10933 16 No A %S_MSG with id %d does not exist on this system. Use sys.dm_os_schedulers to locate valid %S_MSGs for this system.
10934 16 No Requested operation cannot be performed because the external resource pool '%.*ls' does not exist.
10935 16 No External resource pool does not allow more than one processor group.
10961 16 No The request has been aborted because its CPU usage exceeds the maximum configured limit for the workload group.
10981 10 No Resource governor reconfiguration succeeded.
10982 16 Yes Failed to run resource governor classifier user-defined function '%.*ls'. Last error %u, state %u. See previous errors in SQL Server error log from session ID %ld for details. Classifier elapsed time: %I64u ms.
10983 16 No Resource governor '%ls' operation was canceled by user.
10984 16 No Resource governor reconfiguration failed.
10985 10 No Resource governor reconfiguration encountered an issue (HRESULT code : 0x%lx, reason: %ls), while sending active external resource pool ids to launchpad. This will not fail reconfigure.
Error Severity Event logged Description
10000 16 No Unknown provider error.
10001 16 No The provider reported an unexpected catastrophic failure.
10002 16 No The provider did not implement the functionality.
10003 16 No The provider ran out of memory.
10004 16 No One or more arguments were reported invalid by the provider.
10005 16 No The provider did not support an interface.
10006 16 No The provider indicated an invalid pointer was used.
10007 16 No The provider indicated an invalid handle was used.
10008 16 No The provider terminated the operation.
10009 16 No The provider did not give any information about the error.
10010 16 No The data necessary to complete this operation was not yet available to the provider.
10011 16 No Access denied.
10021 16 No Execution terminated by the provider because a resource limit was reached.
10022 16 No The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.
10023 16 No The provider does not support the necessary method.
10024 16 No The provider indicates that the user did not have the permission to perform the operation.
10025 16 No Provider caused a server fault in an external process.
10026 16 No No command text was set.
10027 16 No Command was not prepared.
10028 16 No Authentication failed.
10032 16 No Cannot return multiple result sets (not supported by the provider).
10033 16 No The specified index does not exist or the provider does not support an index scan on this data source.
10034 16 No The specified table or view does not exist or contains errors.
10035 16 No No value was given for one or more of the required parameters.
10042 16 No Cannot set any properties while there is an open rowset.
10052 16 No The insertion was canceled by the provider during notification.
10053 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10054 16 No The data value for one or more columns overflowed the type used by the provider.
10055 16 No The data violated the integrity constraints for one or more columns.
10056 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10057 16 No Cannot create the row. Would exceed the total number of active rows supported by the rowset.
10058 16 No The consumer cannot insert a new row before releasing previously-retrieved row handles.
10062 16 No The change was canceled by the provider during notification.
10063 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10064 16 No The data value for one or more columns overflowed the type used by the provider.
10065 16 No The data violated the integrity constraints for one or more columns.
10066 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10067 16 No 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 No The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.
10069 16 No The consumer could not delete the row. The insertion has been transmitted to the data source.
10081 16 No The rowset uses integrated indexes and there is no current index.
10085 16 No RestartPosition on the table was canceled during notification.
10086 16 No The table was built over a live data stream and the position cannot be restarted.
10087 16 No The provider did not release some of the existing rows.
10088 16 No 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 No 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 columns.
10101 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TOP or OFFSET keyword. Consider removing the TOP or OFFSET or not indexing the view.
10102 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing the view.
10103 16 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
10106 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal system rowset provider. Consider not indexing this view.
10107 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it references a SQL Server internal table.
10109 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
10111 16 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the PIVOT operator. Consider not indexing this view.
10115 16 No Cannot create %S_MSG on view "%.*ls" because it uses the UNPIVOT operator. Consider not indexing this view.
10116 16 No 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 No Cannot create %S_MSG on view "%.*ls" because the view uses the "*" operator to select columns. Consider referencing columns by name instead.
10118 16 No Cannot create %S_MSG on view "%.*ls" because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
10119 16 No Cannot create %S_MSG on view "%.*ls" because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
10120 16 No Cannot create %S_MSG on view "%.*ls" because it contains the ROLLUP operator. Consider not indexing this view.
10121 16 No Cannot create %S_MSG on view "%.*ls" because it contains a HAVING clause. Consider removing the HAVING clause.
10122 16 No 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.
10124 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal SQL Server column.
10125 16 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because function "%.*ls" referenced by the view performs user or system data access.
10134 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the aggregate COUNT. Use COUNT_BIG instead.
10137 16 No 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 No 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 No 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 No Cannot create %S_MSG on view '%.*ls' because the view contains a table hint. Consider removing the hint.
10141 16 No 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 create index.
10142 16 No Cannot create %S_MSG on view "%.*ls" because it contains an APPLY. Consider not indexing the view, or removing APPLY.
10143 16 No 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 No Cannot create %S_MSG on view '%.*ls' because it uses the CHANGETABLE function.
10145 16 No 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.
10146 16 No Cannot create %S_MSG on the view '%.*ls' because it uses the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function.
10147 16 No Cannot create %S_MSG on the view '%.*ls' because it uses temporal FOR SYSTEM_TIME clause.
10148 16 No Cannot create %S_MSG on the view '%.*ls' because it uses OPENJSON.
10149 16 No Index that has SNAPSHOT_MATERIALIZATION cannot be created on view '%.*ls' because view definition contains memory-optimized table(s).
10211 16 No Cannot invoke mutator on a null CLR type value.
10227 16 No Field "%.*ls" of type "%.*ls.%.*ls" cannot be updated because the field is "%.*ls".
10240 16 No Could not find UdtExtensions.dll. Please check your installation.
10300 16 No 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 failed (reason: %S_MSG). Please load the referenced assembly into the current database and retry your request.
10301 16 No 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 failed (reason: %s). Please load the referenced assembly into the current database and retry your request.
10302 16 No Could not get path for SQL Server: '%ls'.
10303 16 Yes Could not create AppDomain manager: '%.*ls'.
10304 16 No Failed to enter Common Language Runtime (CLR) with HRESULT 0x%x. This may due to low resource conditions.
10305 16 No The Init method for a CLR table-valued function must be annotated with SqlFunctionAttribute.
10306 16 No The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.
10307 16 No The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.
10308 10 No 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 routine may stop working. Please refer SQL Server Books Online for more details.
10309 10 No Warning: The SQL Server client assembly '%.*ls' you are registering is not fully tested in SQL Server hosted environment.
10310 10 Yes AppDomain %i (%.*ls) is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.
10311 10 Yes AppDomain %i (%.*ls) is marked for unload due to memory pressure.
10312 16 No .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.
10313 16 No 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 No 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. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error: %.*ls
10316 16 No The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found.
10317 16 No An error occurred trying to get file version info for the file '%s'.
10318 16 No '%.*ls' failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10319 16 No UserDefinedType method call failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10320 16 No Method name '%.*ls' is invalid for '%.*ls'.
10321 16 No Method name '%.*ls' is invalid for UserDefinedType method call.
10322 16 No Type %.*ls not found in database %.*ls
10323 16 Yes Invalid user code has been identified by .Net Framework Managed Debug Assistant %.*ls
10324 16 No WITH ENCRYPTION option of CREATE TRIGGER is only applicable to T-SQL triggers and not to CLR triggers.
10325 16 Yes The server is shutting down due to stack overflow in user's unmanaged code.
10326 16 Yes Two versions of assembly '%.*ls' cannot coexist in database '%.*ls'. Keep one version and drop the other.
10327 14 No %ls ASSEMBLY for assembly '%.*ls' failed because assembly '%.*ls' is not trusted. The assembly is trusted when either of the following is true: the assembly is signed with a certificate or an asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission, or the assembly is trusted using sp_add_trusted_assembly.
10328 16 No There is not enough stack to create appdomain '%.*ls'.
10329 16 No .Net Framework execution was aborted. %.*ls
10330 16 No 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 No Type '%ls' in assembly '%.*ls' derives from a generic type which is not supported for a CLR Type.
10332 16 No Assembly "%.*ls" was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s.
10333 16 Yes Failed to obtain ICLRAppDomainResourceMonitor interface from CLR. The error code from CLR was: 0x%x. As a result, resource monitoring won't work for AppDomain with ID %d.
10334 16 No Changing the database compatibility level has caused data to be marked as unchecked in one or more objects in database %s. Refer to the column has_unchecked_assembly_data in the sys.tables and sys.views to locate all such objects.
10335 16 No The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features.
10336 10 No Failed to enque task to start CLR during SQL server startup. Error code: %u. CLR will be started in an on-demand fashion.
10337 16 No An internal error occurred.
10338 16 No Verification of assembly failed. Could not open the physical file '%.*ls': %ls.
10339 16 No Verification of assembly failed. Could not read from the physical file "%.*ls": %ls.
10340 16 No DROP ASSEMBLY failed. Error code: 0x%x.
10341 16 No Assembly '%.*ls' cannot be loaded because Azure SQL Database does not support user-defined assemblies. Contact Azure Technical Support if you have questions.
10342 16 No Assembly '%.*ls' cannot be loaded because this edition of SQL Server only supports SAFE assemblies.
10343 14 No CREATE or ALTER ASSEMBLY for assembly '%.*ls' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly.
10344 16 No Internal table access error: failed to access the Trusted Assemblies internal table with HRESULT: 0x%x. Contact Customer Support Services.
10345 16 No The assembly hash '0x%.*ls' is already trusted.
10346 16 No The assembly hash '0x%.*ls' is not currently trusted. No action was taken.
10501 16 No Cannot create plan guide '%.*ls' because type '%.*ls' provided is not allowed.
10502 16 No 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 plan guide.
10503 16 No Operation '%.*ls' is not allowed.
10504 16 No Cannot create plan guide '%.*ls' because parameter @hints is incorrect. Use N'OPTION ( <query_hint> [ ,...n ] )'.
10505 16 No 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 No Cannot create plan guide '%.*ls' because parameter @stmt has more than one statement.
10507 16 No 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 module or batch.
10508 16 No 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 No 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 statement within the batch. To obtain a valid starting position, query the 'statement_start_offset' column in the sys.dm_exec_query_stats dynamic management function.
10510 16 No Cannot create plan guide '%.*ls' because there is already a plan guide with that name in the database. Use a unique name.
10511 16 No Cannot create plan guide '%.*ls' because @params is not NULL. @params must be NULL if @type is 'object'.
10512 16 No 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 No 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.
10514 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be large object when @type is object.
10515 16 No Cannot create plan guide '%.*ls' because the module '%.*ls' does not exist or you do not have needed permission.
10516 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be compiled.
10517 16 No Cannot create plan guide '%.*ls' because you do not have needed permission. Alter database permission required.
10518 16 No 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 No 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 No 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-NULL value for the parameter.
10521 16 No 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 for the parameter.
10522 16 No 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 No Cannot generate query template because @querytext does not contain a valid single query.
10524 16 No Cannot parameterize @querytext.
10525 10 No 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 this plan guide or removing RECOMPILE from it.
10526 16 No 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 No Cannot create plan guide '%.*ls' because the object '%.*ls' is a temporary object.
10528 16 No Cannot create plan guide '%.*ls' because its name is invalid. Plan guide name cannot begin with a '#' character.
10529 16 No Cannot create plan guide '%.*ls' because there is already a planguide '%.*ls' of @type 'template' on @stmt.
10530 16 No 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 No 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 No 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 No 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 No Cannot create plan guide '%.*ls' because the value specified for @params is invalid. Specify the value in the form <parameter_name> <parameter_type>, or specify NULL.
10535 16 No 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 No 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 value for each statement.
10537 16 No 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 No 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 context, and you have ALTER permission on the object referenced by the plan guide or ALTER DATABASE permission.
10539 16 No 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 database objects exist, and execute the statement before creating the plan guide.
10601 16 No Cannot specify included columns for a clustered index.
10602 16 No Mixing old and new syntax in CREATE/ALTER/DROP INDEX statement is not allowed.
10603 16 No 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 No Cannot convert a statistic to an index using DROP_EXISTING index option when ONLINE index option is also specified.
10605 16 No Cannot disable primary key index "%.*ls" on table "%.*ls" because the table is published for replication.
10606 16 No Cannot disable the clustered index "%.*ls" on view "%.*ls" because the indexed view is published for replication.
10607 16 No 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 No 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 before disabling the index.
10609 16 No 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 No 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 incorporated in the view definition.
10611 16 No 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 not supported for filtered %S_MSG. To resolve this error, explicitly convert the constant to the same data type and collation as the column '%.*ls'.
10612 16 No 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 this comparison.
10617 16 No 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 No 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 No 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 No 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 No 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 No The %S_MSG '%.*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 No Filtered statistics '%.*ls' cannot be created on object '%.*ls' because it is not a user table. Filtered statistics are only supported on user tables.
10624 16 No The CREATE INDEX or REBUILD INDEX statement failed for index '%.*ls' on table '%.*ls' because a distribution policy cannot be specified for system databases.
10625 16 No A distribution key cannot be created containing more than %d columns.
10626 16 No Column name '%.*ls' appears more than one time in the list of columns in the distribution key.
10627 16 No Column '%.*ls' cannot be part of the distribution key of the index '%.*ls' because the column is not part of the unique index key. Distribution key columns for a unique index must be part of the index key.
10628 16 No Index '%.*ls' on table '%.*ls' is a hypothetical index that was created to hold column-level statistics. A distribution policy is not allowed for hypothetical indexes.
10629 16 No The data type specified for column '%.*ls' in table '%.*ls' cannot be used as a column in the distribution key of an index.
10630 16 No The index distribution policy is invalid. The policy must be set to HASH, NONE, or REPLICATE. Distribution columns cannot be specified when the distribution policy is set to NONE or REPLICATE.
10631 16 No Index '%.*ls' could not be created or rebuilt. A unique or clustered index on a federated table must contain the federated column.
10632 16 No Index '%.*ls' could not be created. Views cannot be indexed in a federated database.
10633 16 No Invalid online index creation operation
10634 10 Yes An '%.*ls' statement was executed on object '%.*ls' by hostname '%.*ls', host process ID %d using the WAIT_AT_LOW_PRIORITY options with MAX_DURATION = %d and ABORT_AFTER_WAIT = BLOCKERS. Blocking user sessions will be killed after the max duration of waiting time.
10635 16 No An online operation cannot be performed for '%.*ls' because the index contains column of large object type, and in the same transaction there are update operations before this online operation. Put the online operation outside the transaction or put it before any updates in the transaction.
10636 16 No Ignore in Optimization cannot be set for '%.*ls' on '%.*ls.%.*ls' because it is only applicable to non-clustered B-tree or columnstore indexes.
10637 16 No Cannot perform this operation on '%.*ls' with ID %I64d as one or more indexes are currently in resumable index rebuild state. Please refer to sys.index_resumable_operations for more details.
10638 16 No ALTER INDEX '%S_MSG' failed. There is no pending resumable index operation for the index '%.*ls' on '%.*ls'.
10639 16 No Resumable index operation for %S_MSG '%.*ls' failed because the index contains column '%.*ls' of type timestamp as a key column.
10640 16 No Ignore in Optimization cannot be set for an index on '%.*ls.%.*ls' because it is only applicable to indexes on user defined disk-based tables.
10641 16 No ALTER INDEX PAUSE failed. There is no actively running resumable index operation for the index '%.*ls' on '%.*ls'.
10642 16 No SNAPSHOT_MATERIALIZATION cannot be set for index '%.*ls' on '%.*ls' because it is only applicable to indexes on views.
10643 16 No SNAPSHOT_MATERIALIZATION cannot be set for '%.*ls' on '%.*ls' because it is only applicable to clustered indexes on views.
10644 16 No Resumable index operation for %S_MSG '%.*ls' failed because the index contains the computed column '%.*ls' as a key or partitioning column. If this is a non clustered index, the column will be implicitly included as a key column if it is part of the clustered index key.
10645 10 No Warning: An existing resumable operation with the same options was identified for the same index on '%.*ls'. The existing operation will be resumed instead.
10646 16 No Index '%.*ls' on view '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be dropped using the DROP_EXISTING option.
10647 16 No Index '%.*ls' on '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be altered.
10648 16 No SNAPSHOT_MATERIALIZATION cannot be set for partitioned index '%.*ls' on '%.*ls'.
10649 16 No Nonclustered index '%.*ls' cannot be created on '%.*ls' that has clustered index '%.*ls' with SNAPSHOT_MATERIALIZATION.
10650 16 No Refresh of snapshot view(s) requires snapshot isolation to be enabled on the database.
10651 16 No Refresh of snapshot view failed because view '%.*ls.%.*ls' does not exist.
10652 16 No Refresh of snapshot view failed because '%.*ls.%.*ls' is not a snapshot view.
10653 16 No Refresh of snapshot view failed.
10654 16 No Refresh of snapshot view failed because lock could not be obtained on the database.
10655 16 No Refresh of snapshot view failed because view is not specified in two-part name format.
10656 10 Yes The resumable index operation for index '%.*ls' on object '%.*ls' was paused.
10657 10 No The resumable index '%.*ls' on object '%.*ls' has been paused for '%.2f' hours.
10658 16 No Stored procedure '%ls' is currently disabled.
10659 10 Yes An ALTER INDEX '%S_MSG' was executed for index '%.*ls' on object '%.*ls' by hostname '%.*ls'.
10675 16 No Internal Query Processor Error: The query processor could not produce a query plan. The RESUMABLE option is not supported for this index build. Remove the RESUMABLE option and rerun the statement.
10700 16 No The table-valued parameter "%.*ls" is READONLY and cannot be modified.
10701 15 No The READONLY option cannot be used in an EXECUTE or CREATE AGGREGATE statement.
10702 15 No The WITH CUBE and WITH ROLLUP options are not permitted with a ROLLUP, CUBE, or GROUPING SETS specification.
10703 15 No Too many grouping sets. The maximum number is %d.
10704 15 No To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.
10705 15 No Subqueries are not allowed in the OUTPUT clause.
10706 15 No Too many expressions are specified in the GROUP BY clause. The maximum number is %d when grouping sets are supplied.
10707 15 No 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 No DEFAULT is not allowed on the right hand side of "%.*ls"
10709 15 No The number of columns for each row in a table value constructor must be the same.
10710 15 No An action of type '%S_MSG' is not allowed in the 'WHEN NOT MATCHED' clause of a MERGE statement.
10711 15 No An action of type 'INSERT' is not allowed in the '%S_MSG' clause of a MERGE statement.
10712 15 No The pseudocolumn '%.*ls' cannot be part of an index.
10713 15 No A MERGE statement must be terminated by a semi-colon (;).
10714 15 No An action of type '%S_MSG' cannot appear more than once in a '%S_MSG' clause of a MERGE statement.
10715 15 No '%.*ls' is not a valid hint.
10716 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.
10717 15 No The %S_MSG clause is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10718 15 No Query hints are not allowed in nested INSERT, UPDATE, DELETE, or MERGE statements.
10719 16 No Foreign key relationships from a memory optimized table with DURABILITY set to SCHEMA_AND_DATA to a memory optimized table with DURABILITY set to SCHEMA_ONLY are not supported.
10720 15 No An OUTPUT INTO clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10721 15 No The WHERE CURRENT OF clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10722 15 No The DISTINCT keyword is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10723 15 No 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 MERGE statement. Modify the SET clause to only specify assignments of the form 'SET @variable = column' or 'SET @variable = expression'.
10724 15 No The FORCESEEK hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10725 15 No Cannot use the VARYING option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
10726 15 No User defined aggregates do not support default parameters.
10727 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a JOIN or APPLY operator.
10728 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed as the table source of a PIVOT or UNPIVOT operator.
10729 15 No 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 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the FROM clause of an UPDATE or DELETE statement.
10731 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed inside another nested INSERT, UPDATE, DELETE, or MERGE statement.
10732 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a UNION, INTERSECT, or EXCEPT operator.
10733 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the USING clause of a MERGE statement.
10734 16 No Variable assignment is not allowed in a statement containing a top level UNION, INTERSECT or EXCEPT operator.
10735 15 No Incorrect WHERE clause for filtered %S_MSG '%.*ls' on table '%.*ls'.
10736 15 No A full-text stoplist statement must be terminated by a semi-colon (;).
10737 15 No 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 rebuilt, even if only a subset is specified in the DATA_COMPRESSION clause.
10738 15 No The number of row value expressions in the INSERT statement exceeds the maximum allowed number of %d row values.
10739 15 No The insert column list used in the MERGE statement cannot contain multi-part identifiers. Use single part identifiers instead.
10740 15 No A search property list statement must end with a semicolon (;).
10741 15 No A TOP can not be used in the same query or sub-query as a OFFSET.
10742 15 No The offset specified in a OFFSET clause may not be negative.
10743 15 No The number of rows provided for a OFFSET clause must be an integer.
10744 15 No The number of rows provided for a FETCH clause must be greater then zero.
10745 15 No The FORCESCAN hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10746 15 No The FORCESCAN hint is specified simultaneously with the FORCESEEK hint. Remove one of the hints and resubmit the query.
10747 15 No 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 hints for each table or view.
10748 15 No There are multiple FORCESEEK hints specified on the same table or view. Remove the extra FORCESEEK hints and resubmit the query.
10749 15 No The FORCESEEK hint cannot be used with index 0. Correct the index provided to the FORCESEEK hint and resubmit the query.
10750 15 No The FORCESCAN hint cannot be used with more than one INDEX hint. Remove the extra INDEX hints and resubmit the query.
10751 15 No The ORDER BY in WITHIN GROUP clause of '%.*ls' function must have exactly one expression.
10752 15 No The function '%.*ls' may not have a window frame.
10753 15 No The function '%.*ls' must have an OVER clause.
10754 15 No The function '%.*ls' must have a WITHIN GROUP clause.
10755 15 No The function '%.*ls' takes between %d and %d arguments.
10756 15 No Window frame with ROWS or RANGE must have an ORDER BY clause.
10757 15 No The function '%.*ls' may not have a WITHIN GROUP clause.
10758 15 No The function '%.*ls' may not have ORDER BY in OVER clause.
10759 15 No Use of DISTINCT is not allowed with the OVER clause.
10760 16 No Scale argument is not valid. Valid expressions for data type %ls scale argument are integer constants and integer constant expressions.
10761 16 No Invalid data type %.*ls in function %.*ls.
10762 16 No The %.*ls function is not allowed in the current compatibility mode. It is only allowed in 110 mode or higher.
10763 15 No GROUP BY clause can only contain one query hint. Remove the extra hints and re-run the query.
10764 15 No Number of grouping columns in the query exceeded maximum number allowed. SQL Server allows 64k grouping columns. Reduce number of grouping columns and re-run the query.
10765 15 No DISTRIBUTED_AGG and CENTRAL_AGG hints cannot be used with a CUBE or ROLLUP clause. Modify the query and re-run it.
10766 15 No CENTRAL_AGG must be specified after all columns in the GROUP BY clause. Modify the query and re-run it.
10767 15 No DISTRIBUTED_AGG hint cannot be used when the GROUP BY clause contains the same column more than once. Modify the query and re-run it.
10768 15 No LABEL hint can only be used one time in the query. Modify the query and re-run it.
10769 15 No SET options are not supported inside ATOMIC blocks.
10770 15 No The SERVER option and one of CREDENTIAL or FEDERATED_SERVICE_ACCOUNT = ON options are required for setting REMOTE_DATA_ARCHIVE on a database.
10771 15 No The CREDENTIAL option cannot be used with the FEDERATED_SERVICE_ACCOUNT = ON option.
10772 15 No There are multiple REMOTE_DATA_ARCHIVE_OVERRIDE hints specified on the same table or view reference. Remove the extra REMOTE_DATA_ARCHIVE_OVERRIDE hint(s) and resubmit the query.
10773 15 No The REMOTE_DATA_ARCHIVE_OVERRIDE hint is not applicable to object '%.*ls' because it is not a table with REMOTE_DATA_ARCHIVE enabled. Remove the REMOTE_DATA_ARCHIVE_OVERRIDE hint and resubmit the statement.
10774 15 No Incorrect WHERE clause for filtered index.
10775 16 No Object '%.*ls' is not a memory optimized table or a natively compiled inline table-valued function and cannot be accessed from a natively compiled module.
10776 16 No Triggers on non-memory optimized tables cannot use WITH NATIVE_COMPILATION.
10777 16 No Triggers on memory-optimized tables must use WITH NATIVE_COMPILATION.
10778 16 No Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported.
10779 16 No The durability option 'schema_only' is supported only with memory optimized tables.
10780 16 No There is no primary key in the referenced table '%.*ls' that matches the referencing column list in the foreign key '%.*ls'. Foreign keys in memory-optimized tables must reference primary keys.
10781 16 No Querytraceon %d and optimizer hint '%.*ls' specify conflicting behaviors. Remove one of them and rerun the query.
10782 16 No BEGIN ATOMIC is supported only in natively compiled modules.
10783 16 No The body of a natively compiled module must be an ATOMIC block.
10784 16 No The WITH clause of BEGIN ATOMIC statement must specify a value for the option '%ls'.
10785 15 No The %S_MSG '%ls' is supported only with %S_MSG.
10786 16 No The ALTER AVAILABILITY GROUP command failed because it contained multiple MODIFY REPLICA options: %ls. Enter a separate ALTER AVAILABILITY GROUP ... MODIFY REPLICA command for each replica option that you want to modify.
10787 16 No The REPEATABLEREAD and SERIALIZABLE hints are not permitted on Hekaton tables with columnstore indexes.
10788 15 No The option '%ls' is not supported with table types.
10789 15 No The option '%ls' must be specified for index '%.*ls' on table '%.*ls'. It is required for hash indexes.
10790 15 No The option '%ls' can be specified only for hash indexes.
10791 15 No Hash indexes are permitted only in memory optimized tables.
10792 15 No When used in a natively compiled module, the function '%.*ls' cannot appear outside of a catch block.
10793 16 No Both an index and a PRIMARY KEY constraint have been defined inline, with the definition of column '%.*ls', table '%.*ls'. Defining both an index and a PRIMARY KEY constraint inline with the column definition is not allowed.
10794 15 No The %S_MSG '%ls' is not supported with %S_MSG.
10795 15 No The variable '%.*ls' was declared as not null, and must be declared with an initial value.
10796 15 No The SCHEMABINDING option is supported only for natively compiled modules, and is required for those modules.
10797 15 No Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database.
10798 16 No This is not a valid data compression setting for this object. It can only be used with columnstore indexes. Please choose NONE, PAGE, or ROW compression.
10799 16 No This is not a valid data compression setting for a columnstore index. Please choose COLUMNSTORE or COLUMNSTORE_ARCHIVE compression.
10800 16 No The listener for the WSFC resource '%.*ls' failed to start, and returned error code %d, '%.*ls'. For more information about this error code, see "System Error Codes" in the Windows Development Documentation.
10801 16 No Failed to stop the listener for Windows Failover Cluster resource '%.*ls'. Error: %d. %.*ls
10802 10 No Failed to enqueue a task to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is added manually or SQL Server is restarted. SQLOS error code: %d.
10900 16 No 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 No User does not have permission to alter the resource governor configuration.
10902 16 No User-defined function '%s' does not exist in master database, or the user does not have permission to access it.
10903 16 No 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 No 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 No 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 No 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 No Attribute '%.*ls' with value of %u is greater than attribute '%.*ls' with value of %u.
10908 16 No Attribute '%.*ls' with value of %u is less than attribute '%.*ls' with value of %u.
10909 16 No The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools.
10910 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than or equal to 100.
10911 16 No Requested operation cannot be performed because the resource pool '%.*ls' does not exist.
10912 16 No The operation could not be completed. Dropping predefined %S_MSG is not allowed.
10913 16 No Users are not allowed to %S_MSG the workload group '%.*ls' in the '%.*ls' resource pool.
10914 16 No The name of the %S_MSG '%.*ls' cannot begin with # of ##.
10915 16 No The operation could not be completed. Altering '%.*ls' %S_MSG is not allowed.
10916 16 No 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 No ALTER WORKLOAD GROUP failed. Either a 'WITH' or 'USING' clause must be specified.
10918 16 No Cannot create %S_MSG '%.*ls' because it already exists.
10919 16 No 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 No Cannot %S_MSG user-defined function '%.*ls'. It is being used as a resource governor classifier.
10921 16 No The '%.*ls' %S_MSG cannot be moved out of '%.*ls' %S_MSG.
10922 16 No %ls failed. Rerun the statement.
10923 16 No %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 governor.
10924 16 No The pool affinity range is invalid. The lower bound %d must be less than the upper bound %d.
10925 16 No A %S_MSG value was specified more than one time in the pool affinity range list.
10926 16 No The %S_MSG range that specifies %S_MSG %d includes at least one %S_MSG that is not available to the current instance. The maximum %S_MSG number that is available to this instance is %d.
10927 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all workload groups using resource pool '%.*ls' to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.
10928 16 No Resource ID : %d. The %ls limit for the database is %d and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance.
10929 16 No Resource ID : %d. The %ls minimum guarantee is %d, maximum limit is %d and the current usage for the database is %d. However, the server is currently too busy to support %ls greater than %d for this database. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance. Otherwise, please try again later.
10930 16 No The service is currently too busy. Please try again later.
10931 16 No Cannot drop resource pool '%.*ls' because it is bound to a database. Remove all bindings to this resource pool before dropping it.
10932 16 No Resource governor configuration failed, because there is an active database in the resource pool being dropped. Take the database offline and try again.
10933 16 No A %S_MSG with id %d does not exist on this system. Use sys.dm_os_schedulers to locate valid %S_MSGs for this system.
10934 16 No Requested operation cannot be performed because the external resource pool '%.*ls' does not exist.
10935 16 No External resource pool does not allow more than one processor group.
10936 16 No Resource ID : %d. The %ls limit for the elastic pool is %d and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance.
10937 16 No Default workload group does not allow to alter attribute '%.*ls'.
10961 16 No The request has been aborted because its CPU usage exceeds the maximum configured limit for the workload group.
10981 10 No Resource governor reconfiguration succeeded.
10982 16 Yes Failed to run resource governor classifier user-defined function '%.*ls'. Last error %u, state %u. See previous errors in SQL Server error log from session ID %ld for details. Classifier elapsed time: %I64u ms.
10983 16 No Resource governor '%ls' operation was canceled by user.
10984 16 No Resource governor reconfiguration failed.
10985 10 No Resource governor reconfiguration encountered an issue (HRESULT code : 0x%lx, reason: %ls), while sending active external resource pool ids to launchpad. This will not fail reconfigure.
Error Severity Event logged Description
10000 16 No Unknown provider error.
10001 16 No The provider reported an unexpected catastrophic failure.
10002 16 No The provider did not implement the functionality.
10003 16 No The provider ran out of memory.
10004 16 No One or more arguments were reported invalid by the provider.
10005 16 No The provider did not support an interface.
10006 16 No The provider indicated an invalid pointer was used.
10007 16 No The provider indicated an invalid handle was used.
10008 16 No The provider terminated the operation.
10009 16 No The provider did not give any information about the error.
10010 16 No The data necessary to complete this operation was not yet available to the provider.
10011 16 No Access denied.
10021 16 No Execution terminated by the provider because a resource limit was reached.
10022 16 No The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.
10023 16 No The provider does not support the necessary method.
10024 16 No The provider indicates that the user did not have the permission to perform the operation.
10025 16 No Provider caused a server fault in an external process.
10026 16 No No command text was set.
10027 16 No Command was not prepared.
10028 16 No Authentication failed.
10032 16 No Cannot return multiple result sets (not supported by the provider).
10033 16 No The specified index does not exist or the provider does not support an index scan on this data source.
10034 16 No The specified table or view does not exist or contains errors.
10035 16 No No value was given for one or more of the required parameters.
10042 16 No Cannot set any properties while there is an open rowset.
10052 16 No The insertion was canceled by the provider during notification.
10053 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10054 16 No The data value for one or more columns overflowed the type used by the provider.
10055 16 No The data violated the integrity constraints for one or more columns.
10056 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10057 16 No Cannot create the row. Would exceed the total number of active rows supported by the rowset.
10058 16 No The consumer cannot insert a new row before releasing previously-retrieved row handles.
10062 16 No The change was canceled by the provider during notification.
10063 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10064 16 No The data value for one or more columns overflowed the type used by the provider.
10065 16 No The data violated the integrity constraints for one or more columns.
10066 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10067 16 No 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 No The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.
10069 16 No The consumer could not delete the row. The insertion has been transmitted to the data source.
10081 16 No The rowset uses integrated indexes and there is no current index.
10085 16 No RestartPosition on the table was canceled during notification.
10086 16 No The table was built over a live data stream and the position cannot be restarted.
10087 16 No The provider did not release some of the existing rows.
10088 16 No 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 No 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 columns.
10101 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TOP or OFFSET keyword. Consider removing the TOP or OFFSET or not indexing the view.
10102 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing the view.
10103 16 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
10106 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal system rowset provider. Consider not indexing this view.
10107 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it references a SQL Server internal table.
10109 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
10111 16 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the PIVOT operator. Consider not indexing this view.
10115 16 No Cannot create %S_MSG on view "%.*ls" because it uses the UNPIVOT operator. Consider not indexing this view.
10116 16 No 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 No Cannot create %S_MSG on view "%.*ls" because the view uses the "*" operator to select columns. Consider referencing columns by name instead.
10118 16 No Cannot create %S_MSG on view "%.*ls" because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
10119 16 No Cannot create %S_MSG on view "%.*ls" because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
10120 16 No Cannot create %S_MSG on view "%.*ls" because it contains the ROLLUP operator. Consider not indexing this view.
10121 16 No Cannot create %S_MSG on view "%.*ls" because it contains a HAVING clause. Consider removing the HAVING clause.
10122 16 No 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.
10124 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal SQL Server column.
10125 16 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because function "%.*ls" referenced by the view performs user or system data access.
10134 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the aggregate COUNT. Use COUNT_BIG instead.
10137 16 No 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 No 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 No 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 No Cannot create %S_MSG on view '%.*ls' because the view contains a table hint. Consider removing the hint.
10141 16 No 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 create index.
10142 16 No Cannot create %S_MSG on view "%.*ls" because it contains an APPLY. Consider not indexing the view, or removing APPLY.
10143 16 No 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 No Cannot create %S_MSG on view '%.*ls' because it uses the CHANGETABLE function.
10145 16 No 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.
10146 16 No Cannot create %S_MSG on the view '%.*ls' because it uses the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function.
10147 16 No Cannot create %S_MSG on the view '%.*ls' because it uses temporal FOR SYSTEM_TIME clause.
10148 16 No Cannot create %S_MSG on the view '%.*ls' because it uses OPENJSON.
10149 16 No Index that has SNAPSHOT_MATERIALIZATION cannot be created on view '%.*ls' because view definition contains memory-optimized table(s).
10150 16 No Cannot create %S_MSG on the view '%.*ls' because it references a scalar UDF that is inlineable.
10211 16 No Cannot invoke mutator on a null CLR type value.
10227 16 No Field "%.*ls" of type "%.*ls.%.*ls" cannot be updated because the field is "%.*ls".
10240 16 No Could not find UdtExtensions.dll. Please check your installation.
10300 16 No 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 failed (reason: %S_MSG). Please load the referenced assembly into the current database and retry your request.
10301 16 No 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 failed (reason: %s). Please load the referenced assembly into the current database and retry your request.
10302 16 No Could not get path for SQL Server: '%ls'.
10303 16 Yes Could not create AppDomain manager: '%.*ls'.
10304 16 No Failed to enter Common Language Runtime (CLR) with HRESULT 0x%x. This may due to low resource conditions.
10305 16 No The Init method for a CLR table-valued function must be annotated with SqlFunctionAttribute.
10306 16 No The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.
10307 16 No The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.
10308 10 No 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 routine may stop working. Please refer SQL Server Books Online for more details.
10309 10 No Warning: The SQL Server client assembly '%.*ls' you are registering is not fully tested in SQL Server hosted environment.
10310 10 Yes AppDomain %i (%.*ls) is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.
10311 10 Yes AppDomain %i (%.*ls) is marked for unload due to memory pressure.
10312 16 No .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.
10313 16 No 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 No 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. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error: %.*ls
10316 16 No The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found.
10317 16 No An error occurred trying to get file version info for the file '%s'.
10318 16 No '%.*ls' failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10319 16 No UserDefinedType method call failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10320 16 No Method name '%.*ls' is invalid for '%.*ls'.
10321 16 No Method name '%.*ls' is invalid for UserDefinedType method call.
10322 16 No Type %.*ls not found in database %.*ls
10323 16 Yes Invalid user code has been identified by .Net Framework Managed Debug Assistant %.*ls
10324 16 No WITH ENCRYPTION option of CREATE TRIGGER is only applicable to T-SQL triggers and not to CLR triggers.
10325 16 Yes The server is shutting down due to stack overflow in user's unmanaged code.
10326 16 Yes Two versions of assembly '%.*ls' cannot coexist in database '%.*ls'. Keep one version and drop the other.
10327 14 No %ls ASSEMBLY for assembly '%.*ls' failed because assembly '%.*ls' is not trusted. The assembly is trusted when either of the following is true: the assembly is signed with a certificate or an asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission, or the assembly is trusted using sp_add_trusted_assembly.
10328 16 No There is not enough stack to create appdomain '%.*ls'.
10329 16 No .Net Framework execution was aborted. %.*ls
10330 16 No 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 No Type '%ls' in assembly '%.*ls' derives from a generic type which is not supported for a CLR Type.
10332 16 No Assembly "%.*ls" was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s.
10333 16 Yes Failed to obtain ICLRAppDomainResourceMonitor interface from CLR. The error code from CLR was: 0x%x. As a result, resource monitoring won't work for AppDomain with ID %d.
10334 16 No Changing the database compatibility level has caused data to be marked as unchecked in one or more objects in database %s. Refer to the column has_unchecked_assembly_data in the sys.tables and sys.views to locate all such objects.
10335 16 No The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features.
10336 10 No Failed to enque task to start CLR during SQL server startup. Error code: %u. CLR will be started in an on-demand fashion.
10337 16 No An internal error occurred.
10338 16 No Verification of assembly failed. Could not open the physical file '%.*ls': %ls.
10339 16 No Verification of assembly failed. Could not read from the physical file "%.*ls": %ls.
10340 16 No DROP ASSEMBLY failed. Error code: 0x%x.
10341 16 No Assembly '%.*ls' cannot be loaded because Azure SQL Database does not support user-defined assemblies. Contact Azure Technical Support if you have questions.
10342 16 No Assembly '%.*ls' cannot be loaded because this edition of SQL Server only supports SAFE assemblies.
10343 14 No CREATE or ALTER ASSEMBLY for assembly '%.*ls' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly.
10344 16 No Internal table access error: failed to access the Trusted Assemblies internal table with HRESULT: 0x%x. Contact Customer Support Services.
10345 16 No The assembly hash '0x%.*ls' is already trusted.
10346 16 No The assembly hash '0x%.*ls' is not currently trusted. No action was taken.
10347 16 No Common Language Runtime(CLR) is not enabled on this instance.
10501 16 No Cannot create plan guide '%.*ls' because type '%.*ls' provided is not allowed.
10502 16 No 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 plan guide.
10503 16 No Operation '%.*ls' is not allowed.
10504 16 No Cannot create plan guide '%.*ls' because parameter @hints is incorrect. Use N'OPTION ( <query_hint> [ ,...n ] )'.
10505 16 No 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 No Cannot create plan guide '%.*ls' because parameter @stmt has more than one statement.
10507 16 No 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 module or batch.
10508 16 No 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 No 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 statement within the batch. To obtain a valid starting position, query the 'statement_start_offset' column in the sys.dm_exec_query_stats dynamic management function.
10510 16 No Cannot create plan guide '%.*ls' because there is already a plan guide with that name in the database. Use a unique name.
10511 16 No Cannot create plan guide '%.*ls' because @params is not NULL. @params must be NULL if @type is 'object'.
10512 16 No 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 No 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.
10514 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be large object when @type is object.
10515 16 No Cannot create plan guide '%.*ls' because the module '%.*ls' does not exist or you do not have needed permission.
10516 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be compiled.
10517 16 No Cannot create plan guide '%.*ls' because you do not have needed permission. Alter database permission required.
10518 16 No 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 No 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 No 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-NULL value for the parameter.
10521 16 No 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 for the parameter.
10522 16 No 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 No Cannot generate query template because @querytext does not contain a valid single query.
10524 16 No Cannot parameterize @querytext.
10525 10 No 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 this plan guide or removing RECOMPILE from it.
10526 16 No 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 No Cannot create plan guide '%.*ls' because the object '%.*ls' is a temporary object.
10528 16 No Cannot create plan guide '%.*ls' because its name is invalid. Plan guide name cannot begin with a '#' character.
10529 16 No Cannot create plan guide '%.*ls' because there is already a planguide '%.*ls' of @type 'template' on @stmt.
10530 16 No 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 No 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 No 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 No 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 No Cannot create plan guide '%.*ls' because the value specified for @params is invalid. Specify the value in the form <parameter_name> <parameter_type>, or specify NULL.
10535 16 No 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 No 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 value for each statement.
10537 16 No 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 No 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 context, and you have ALTER permission on the object referenced by the plan guide or ALTER DATABASE permission.
10539 16 No 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 database objects exist, and execute the statement before creating the plan guide.
10601 16 No Cannot specify included columns for a clustered index.
10602 16 No Mixing old and new syntax in CREATE/ALTER/DROP INDEX statement is not allowed.
10603 16 No 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 No Cannot convert a statistic to an index using DROP_EXISTING index option when ONLINE index option is also specified.
10605 16 No Cannot disable primary key index "%.*ls" on table "%.*ls" because the table is published for replication.
10606 16 No Cannot disable the clustered index "%.*ls" on view "%.*ls" because the indexed view is published for replication.
10607 16 No 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 No 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 before disabling the index.
10609 16 No 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 No 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 incorporated in the view definition.
10611 16 No 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 not supported for filtered %S_MSG. To resolve this error, explicitly convert the constant to the same data type and collation as the column '%.*ls'.
10612 16 No 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 this comparison.
10617 16 No 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 No 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 No 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 No 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 No 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 No The %S_MSG '%.*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 No Filtered statistics '%.*ls' cannot be created on object '%.*ls' because it is not a user table. Filtered statistics are only supported on user tables.
10629 16 No The data type specified for column '%.*ls' in table '%.*ls' cannot be used as a column in the distribution key of an index.
10631 16 No Index '%.*ls' could not be created or rebuilt. A unique or clustered index on a federated table must contain the federated column.
10632 16 No Index '%.*ls' could not be created. Views cannot be indexed in a federated database.
10633 16 No Invalid online index creation operation
10634 10 Yes An '%.*ls' statement was executed on object '%.*ls' by hostname '%.*ls', host process ID %d using the WAIT_AT_LOW_PRIORITY options with MAX_DURATION = %d and ABORT_AFTER_WAIT = BLOCKERS. Blocking user sessions will be killed after the max duration of waiting time.
10635 16 No An online operation cannot be performed for '%.*ls' because the index contains column of large object type, and in the same transaction there are update operations before this online operation. Put the online operation outside the transaction or put it before any updates in the transaction.
10636 16 No Ignore in Optimization cannot be set for '%.*ls' on '%.*ls.%.*ls' because it is only applicable to non-clustered B-tree or columnstore indexes.
10637 16 No Cannot perform this operation on '%.*ls' with ID %I64d as one or more indexes are currently in resumable index rebuild state. Please refer to sys.index_resumable_operations for more details.
10638 16 No ALTER INDEX '%S_MSG' failed. There is no pending resumable index operation for the index '%.*ls' on '%.*ls'.
10639 16 No Resumable index operation for %S_MSG '%.*ls' failed because the index contains column '%.*ls' of type timestamp as a key column.
10640 16 No Ignore in Optimization cannot be set for an index on '%.*ls.%.*ls' because it is only applicable to indexes on user defined disk-based tables.
10641 16 No ALTER INDEX PAUSE failed. There is no actively running resumable index operation for the index '%.*ls' on '%.*ls'.
10642 16 No SNAPSHOT_MATERIALIZATION cannot be set for index '%.*ls' on '%.*ls' because it is only applicable to indexes on views.
10643 16 No SNAPSHOT_MATERIALIZATION cannot be set for '%.*ls' on '%.*ls' because it is only applicable to clustered indexes on views.
10644 16 No Resumable index operation for %S_MSG '%.*ls' failed because the index contains the computed column '%.*ls' as a key or partitioning column. If this is a non clustered index, the column will be implicitly included as a key column if it is part of the clustered index key.
10645 10 No Warning: An existing resumable operation with the same options was identified for the same index on '%.*ls'. The existing operation will be resumed instead.
10646 16 No Index '%.*ls' on view '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be dropped using the DROP_EXISTING option.
10647 16 No Index '%.*ls' on '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be altered.
10648 16 No SNAPSHOT_MATERIALIZATION cannot be set for partitioned index '%.*ls' on '%.*ls'.
10649 16 No Nonclustered index '%.*ls' cannot be created on '%.*ls' that has clustered index '%.*ls' with SNAPSHOT_MATERIALIZATION.
10650 16 No Refresh of snapshot view(s) requires snapshot isolation to be enabled on the database.
10651 16 No Refresh of snapshot view failed because view '%.*ls.%.*ls' does not exist.
10652 16 No Refresh of snapshot view failed because '%.*ls.%.*ls' is not a snapshot view.
10653 16 No Refresh of snapshot view failed.
10654 16 No Refresh of snapshot view failed because lock could not be obtained on the database.
10655 16 No Refresh of snapshot view failed because view is not specified in two-part name format.
10656 10 Yes The resumable index operation for index '%.*ls' on object '%.*ls' was paused.
10657 10 No The resumable index '%.*ls' on object '%.*ls' has been paused for '%.2f' hours.
10658 16 No Stored procedure '%ls' is currently disabled.
10659 10 Yes An ALTER INDEX '%S_MSG' was executed for index '%.*ls' on object '%.*ls' by hostname '%.*ls'.
10660 13 Yes The online index build operation was chosen as a deadlock victim over 500 times while attempting to process a single row. Resolve the blocking concurrent operation, and rerun the query.
10661 10 Yes The refresh operation for all snapshot views failed because there was another refresh operation (either for all or a single snapshot view) in progress.
10662 10 Yes The refresh operation for snapshot view '%.*ls' failed because another refresh operation for the same snapshot view was already in progress.
10663 10 Yes The refresh operation for snapshot view '%.*ls' failed because refresh operation for all snapshot views was already in progress.
10664 16 No Cannot specify included columns for indexes on memory optimized tables.
10665 15 No '%.*ls' with DROP_EXISTING option is not supported with %S_MSG option.
10666 16 Yes Cannot resume index build as required DOP %d (DOP operation was started with) is not available. Please ensure sufficient DOP is available or abort existing index operation and try again.
10667 10 No Warning: Create Index was started with MAXDOP %d. The operation will resume with MAXDOP value %d.
10668 16 No The %S_MSG option is not supported for creating an index on a heap.
10669 16 No The %S_MSG option is not supported for creating a nonclustered index on clustered columnstore index.
10670 16 No Resumable index creation for %S_MSG '%.*ls' failed because the index includes a large object column '%.*ls'.
10671 16 No The %S_MSG option is not supported for creating a filtered index.
10672 16 No The %S_MSG option is not supported for creating a clustered index on a relation that has a filtered index.
10673 16 No Cannot resume index creation due to incorrect persisted state found. Please ABORT the operation and try again.
10674 16 No The %S_MSG option is not supported for creating a clustered index on a table containing nonclustered columnstore index.
10675 16 No Internal Query Processor Error: The query processor could not produce a query plan. The RESUMABLE option is not supported for this index build. Remove the RESUMABLE option and rerun the statement.
10681 16 No Cannot create a row of size %d which is greater than the allowable maximum row size of %d. Abort and retry the operation by specifying the RESUMABLE = OFF option.
10700 16 No The table-valued parameter "%.*ls" is READONLY and cannot be modified.
10701 15 No The READONLY option cannot be used in an EXECUTE or CREATE AGGREGATE statement.
10702 15 No The WITH CUBE and WITH ROLLUP options are not permitted with a ROLLUP, CUBE, or GROUPING SETS specification.
10703 15 No Too many grouping sets. The maximum number is %d.
10704 15 No To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.
10705 15 No Subqueries are not allowed in the OUTPUT clause.
10706 15 No Too many expressions are specified in the GROUP BY clause. The maximum number is %d when grouping sets are supplied.
10707 15 No 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 No DEFAULT is not allowed on the right hand side of "%.*ls"
10709 15 No The number of columns for each row in a table value constructor must be the same.
10710 15 No An action of type '%S_MSG' is not allowed in the 'WHEN NOT MATCHED' clause of a MERGE statement.
10711 15 No An action of type 'INSERT' is not allowed in the '%S_MSG' clause of a MERGE statement.
10712 15 No The pseudocolumn '%.*ls' cannot be part of an index or used as partitioning column.
10713 15 No A MERGE statement must be terminated by a semi-colon (;).
10714 15 No An action of type '%S_MSG' cannot appear more than once in a '%S_MSG' clause of a MERGE statement.
10715 15 No '%.*ls' is not a valid hint.
10716 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.
10717 15 No The %S_MSG clause is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10718 15 No Query hints are not allowed in nested INSERT, UPDATE, DELETE, or MERGE statements.
10719 16 No Foreign key relationships from a memory optimized table with DURABILITY set to SCHEMA_AND_DATA to a memory optimized table with DURABILITY set to SCHEMA_ONLY are not supported.
10720 15 No An OUTPUT INTO clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10721 15 No The WHERE CURRENT OF clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10722 15 No The DISTINCT keyword is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10723 15 No 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 MERGE statement. Modify the SET clause to only specify assignments of the form 'SET @variable = column' or 'SET @variable = expression'.
10724 15 No The FORCESEEK hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10725 15 No Cannot use the VARYING option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
10726 15 No User defined aggregates do not support default parameters.
10727 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a JOIN or APPLY operator.
10728 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed as the table source of a PIVOT or UNPIVOT operator.
10729 15 No 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 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the FROM clause of an UPDATE or DELETE statement.
10731 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed inside another nested INSERT, UPDATE, DELETE, or MERGE statement.
10732 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a UNION, INTERSECT, or EXCEPT operator.
10733 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the USING clause of a MERGE statement.
10734 16 No Variable assignment is not allowed in a statement containing a top level UNION, INTERSECT or EXCEPT operator.
10735 15 No Incorrect WHERE clause for filtered %S_MSG '%.*ls' on table '%.*ls'.
10736 15 No A full-text stoplist statement must be terminated by a semi-colon (;).
10737 15 No 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 rebuilt, even if only a subset is specified in the DATA_COMPRESSION clause.
10738 15 No The number of row value expressions in the INSERT statement exceeds the maximum allowed number of %d row values.
10739 15 No The insert column list used in the MERGE statement cannot contain multi-part identifiers. Use single part identifiers instead.
10740 15 No A search property list statement must end with a semicolon (;).
10741 15 No A TOP can not be used in the same query or sub-query as a OFFSET.
10742 15 No The offset specified in a OFFSET clause may not be negative.
10743 15 No The number of rows provided for a OFFSET clause must be an integer.
10744 15 No The number of rows provided for a FETCH clause must be greater then zero.
10745 15 No The FORCESCAN hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10746 15 No The FORCESCAN hint is specified simultaneously with the FORCESEEK hint. Remove one of the hints and resubmit the query.
10747 15 No 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 hints for each table or view.
10748 15 No There are multiple FORCESEEK hints specified on the same table or view. Remove the extra FORCESEEK hints and resubmit the query.
10749 15 No The FORCESEEK hint cannot be used with index 0. Correct the index provided to the FORCESEEK hint and resubmit the query.
10750 15 No The FORCESCAN hint cannot be used with more than one INDEX hint. Remove the extra INDEX hints and resubmit the query.
10751 15 No The ORDER BY in WITHIN GROUP clause of '%.*ls' function must have exactly one expression.
10752 15 No The function '%.*ls' may not have a window frame.
10753 15 No The function '%.*ls' must have an OVER clause.
10754 15 No The function '%.*ls' must have a WITHIN GROUP clause.
10755 15 No The function '%.*ls' takes between %d and %d arguments.
10756 15 No Window frame with ROWS or RANGE must have an ORDER BY clause.
10757 15 No The function '%.*ls' may not have a WITHIN GROUP clause.
10758 15 No The function '%.*ls' may not have ORDER BY in OVER clause.
10759 15 No Use of DISTINCT is not allowed with the OVER clause.
10760 16 No Scale argument is not valid. Valid expressions for data type %ls scale argument are integer constants and integer constant expressions.
10761 16 No Invalid data type %.*ls in function %.*ls.
10762 16 No The %.*ls function is not allowed in the current compatibility mode. It is only allowed in 110 mode or higher.
10763 15 No GROUP BY clause can only contain one query hint. Remove the extra hints and re-run the query.
10764 15 No Number of grouping columns in the query exceeded maximum number allowed. SQL Server allows 64k grouping columns. Reduce number of grouping columns and re-run the query.
10765 15 No DISTRIBUTED_AGG and CENTRAL_AGG hints cannot be used with a CUBE or ROLLUP clause. Modify the query and re-run it.
10766 15 No CENTRAL_AGG must be specified after all columns in the GROUP BY clause. Modify the query and re-run it.
10767 15 No DISTRIBUTED_AGG hint cannot be used when the GROUP BY clause contains the same column more than once. Modify the query and re-run it.
10768 15 No LABEL hint can only be used one time in the query. Modify the query and re-run it.
10769 15 No SET options are not supported inside ATOMIC blocks.
10770 15 No The SERVER option and one of CREDENTIAL or FEDERATED_SERVICE_ACCOUNT = ON options are required for setting REMOTE_DATA_ARCHIVE on a database.
10771 15 No The CREDENTIAL option cannot be used with the FEDERATED_SERVICE_ACCOUNT = ON option.
10772 15 No There are multiple REMOTE_DATA_ARCHIVE_OVERRIDE hints specified on the same table or view reference. Remove the extra REMOTE_DATA_ARCHIVE_OVERRIDE hint(s) and resubmit the query.
10773 15 No The REMOTE_DATA_ARCHIVE_OVERRIDE hint is not applicable to object '%.*ls' because it is not a table with REMOTE_DATA_ARCHIVE enabled. Remove the REMOTE_DATA_ARCHIVE_OVERRIDE hint and resubmit the statement.
10774 15 No Incorrect WHERE clause for filtered index.
10775 16 No Object '%.*ls' is not a memory optimized table or a natively compiled inline table-valued function and cannot be accessed from a natively compiled module.
10776 16 No Triggers on non-memory optimized tables cannot use WITH NATIVE_COMPILATION.
10777 16 No Triggers on memory-optimized tables must use WITH NATIVE_COMPILATION.
10778 16 No Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported.
10779 16 No The durability option 'schema_only' is supported only with memory optimized tables.
10780 16 No There is no primary key in the referenced table '%.*ls' that matches the referencing column list in the foreign key '%.*ls'. Foreign keys in memory-optimized tables must reference primary keys.
10781 16 No Querytraceon %d and optimizer hint '%.*ls' specify conflicting behaviors. Remove one of them and rerun the query.
10782 16 No BEGIN ATOMIC is supported only in natively compiled modules.
10783 16 No The body of a natively compiled module must be an ATOMIC block.
10784 16 No The WITH clause of BEGIN ATOMIC statement must specify a value for the option '%ls'.
10785 15 No The %S_MSG '%ls' is supported only with %S_MSG.
10786 16 No The ALTER AVAILABILITY GROUP command failed because it contained multiple MODIFY REPLICA options: %ls. Enter a separate ALTER AVAILABILITY GROUP ... MODIFY REPLICA command for each replica option that you want to modify.
10787 16 No The REPEATABLEREAD and SERIALIZABLE hints are not permitted on Hekaton tables with columnstore indexes.
10788 15 No The option '%ls' is not supported with table types.
10789 15 No The option '%ls' must be specified for index '%.*ls' on table '%.*ls'. It is required for hash indexes.
10790 15 No The option '%ls' can be specified only for hash indexes.
10791 15 No Hash indexes are permitted only in memory optimized tables.
10792 15 No When used in a natively compiled module, the function '%.*ls' cannot appear outside of a catch block.
10793 16 No Both an index and a PRIMARY KEY constraint have been defined inline, with the definition of column '%.*ls', table '%.*ls'. Defining both an index and a PRIMARY KEY constraint inline with the column definition is not allowed.
10794 15 No The %S_MSG '%ls' is not supported with %S_MSG.
10795 15 No The variable '%.*ls' was declared as not null, and must be declared with an initial value.
10796 15 No The SCHEMABINDING option is supported only for natively compiled modules, and is required for those modules.
10797 15 No Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database.
10798 16 No This is not a valid data compression setting for this object. It can only be used with columnstore indexes. Please choose NONE, PAGE, or ROW compression.
10799 16 No This is not a valid data compression setting for a columnstore index. Please choose COLUMNSTORE or COLUMNSTORE_ARCHIVE compression.
10800 16 No The listener for the WSFC resource '%.*ls' failed to start, and returned error code %d, '%.*ls'. For more information about this error code, see "System Error Codes" in the Windows Development Documentation.
10801 16 No Failed to stop the listener for Windows Failover Cluster resource '%.*ls'. Error: %d. %.*ls
10802 10 No Failed to enqueue a task to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is added manually or SQL Server is restarted. SQLOS error code: %d.
10900 16 No 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 No User does not have permission to alter the resource governor configuration.
10902 16 No User-defined function '%s' does not exist in master database, or the user does not have permission to access it.
10903 16 No 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 No 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 No 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 No 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 No Attribute '%.*ls' with value of %u is greater than attribute '%.*ls' with value of %u.
10908 16 No Attribute '%.*ls' with value of %u is less than attribute '%.*ls' with value of %u.
10909 16 No The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools.
10910 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than or equal to 100.
10911 16 No Requested operation cannot be performed because the resource pool '%.*ls' does not exist.
10912 16 No The operation could not be completed. Dropping predefined %S_MSG is not allowed.
10913 16 No Users are not allowed to %S_MSG the workload group '%.*ls' in the '%.*ls' resource pool.
10914 16 No The name of the %S_MSG '%.*ls' cannot begin with # of ##.
10915 16 No The operation could not be completed. Altering '%.*ls' %S_MSG is not allowed.
10916 16 No 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 No ALTER WORKLOAD GROUP failed. Either a 'WITH' or 'USING' clause must be specified.
10918 16 No Cannot create %S_MSG '%.*ls' because it already exists.
10919 16 No 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 No Cannot %S_MSG user-defined function '%.*ls'. It is being used as a resource governor classifier.
10921 16 No The '%.*ls' %S_MSG cannot be moved out of '%.*ls' %S_MSG.
10922 16 No %ls failed. Rerun the statement.
10923 16 No %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 governor.
10924 16 No The pool affinity range is invalid. The lower bound %d must be less than the upper bound %d.
10925 16 No A %S_MSG value was specified more than one time in the pool affinity range list.
10926 16 No The %S_MSG range that specifies %S_MSG %d includes at least one %S_MSG that is not available to the current instance. The maximum %S_MSG number that is available to this instance is %d.
10927 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all workload groups using resource pool '%.*ls' to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.
10928 16 No Resource ID : %d. The %ls limit for the database is %d and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance.
10929 16 No Resource ID : %d. The %ls minimum guarantee is %d, maximum limit is %d and the current usage for the database is %d. However, the server is currently too busy to support %ls greater than %d for this database. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance. Otherwise, please try again later.
10930 16 No The service is currently too busy. Please try again later.
10931 16 No Cannot drop resource pool '%.*ls' because it is bound to a database. Remove all bindings to this resource pool before dropping it.
10932 16 No Resource governor configuration failed, because there is an active database in the resource pool being dropped. Take the database offline and try again.
10933 16 No A %S_MSG with id %d does not exist on this system. Use sys.dm_os_schedulers to locate valid %S_MSGs for this system.
10934 16 No Requested operation cannot be performed because the external resource pool '%.*ls' does not exist.
10935 16 No External resource pool does not allow more than one processor group.
10936 16 No Resource ID : %d. The %ls limit for the elastic pool is %d and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance.
10937 16 No Default workload group does not allow to alter attribute '%.*ls'.
10961 16 No The request has been aborted because its CPU usage exceeds the maximum configured limit for the workload group.
10981 10 No Resource governor reconfiguration succeeded.
10982 16 Yes Failed to run resource governor classifier user-defined function '%.*ls'. Last error %u, state %u. See previous errors in SQL Server error log from session ID %ld for details. Classifier elapsed time: %I64u ms.
10983 16 No Resource governor '%ls' operation was canceled by user.
10984 16 No Resource governor reconfiguration failed.
10985 10 No Resource governor reconfiguration encountered an issue (HRESULT code : 0x%lx, reason: %ls), while sending active external resource pool ids to launchpad. This will not fail reconfigure.
Error Severity Event logged Description
10000 16 No Unknown provider error.
10001 16 No The provider reported an unexpected catastrophic failure.
10002 16 No The provider did not implement the functionality.
10003 16 No The provider ran out of memory.
10004 16 No One or more arguments were reported invalid by the provider.
10005 16 No The provider did not support an interface.
10006 16 No The provider indicated an invalid pointer was used.
10007 16 No The provider indicated an invalid handle was used.
10008 16 No The provider terminated the operation.
10009 16 No The provider did not give any information about the error.
10010 16 No The data necessary to complete this operation was not yet available to the provider.
10011 16 No Access denied.
10021 16 No Execution terminated by the provider because a resource limit was reached.
10022 16 No The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.
10023 16 No The provider does not support the necessary method.
10024 16 No The provider indicates that the user did not have the permission to perform the operation.
10025 16 No Provider caused a server fault in an external process.
10026 16 No No command text was set.
10027 16 No Command was not prepared.
10028 16 No Authentication failed.
10032 16 No Cannot return multiple result sets (not supported by the provider).
10033 16 No The specified index does not exist or the provider does not support an index scan on this data source.
10034 16 No The specified table or view does not exist or contains errors.
10035 16 No No value was given for one or more of the required parameters.
10042 16 No Cannot set any properties while there is an open rowset.
10052 16 No The insertion was canceled by the provider during notification.
10053 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10054 16 No The data value for one or more columns overflowed the type used by the provider.
10055 16 No The data violated the integrity constraints for one or more columns.
10056 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10057 16 No Cannot create the row. Would exceed the total number of active rows supported by the rowset.
10058 16 No The consumer cannot insert a new row before releasing previously-retrieved row handles.
10062 16 No The change was canceled by the provider during notification.
10063 16 No Could not convert the data value due to reasons other than sign mismatch or overflow.
10064 16 No The data value for one or more columns overflowed the type used by the provider.
10065 16 No The data violated the integrity constraints for one or more columns.
10066 16 No The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10067 16 No 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 No The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.
10069 16 No The consumer could not delete the row. The insertion has been transmitted to the data source.
10081 16 No The rowset uses integrated indexes and there is no current index.
10085 16 No RestartPosition on the table was canceled during notification.
10086 16 No The table was built over a live data stream and the position cannot be restarted.
10087 16 No The provider did not release some of the existing rows.
10088 16 No 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 No 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 columns.
10101 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TOP or OFFSET keyword. Consider removing the TOP or OFFSET or not indexing the view.
10102 16 No Cannot create %S_MSG on view "%.*ls" because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing the view.
10103 16 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
10106 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal system rowset provider. Consider not indexing this view.
10107 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it references a SQL Server internal table.
10109 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
10111 16 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the PIVOT operator. Consider not indexing this view.
10115 16 No Cannot create %S_MSG on view "%.*ls" because it uses the UNPIVOT operator. Consider not indexing this view.
10116 16 No 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 No Cannot create %S_MSG on view "%.*ls" because the view uses the "*" operator to select columns. Consider referencing columns by name instead.
10118 16 No Cannot create %S_MSG on view "%.*ls" because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
10119 16 No Cannot create %S_MSG on view "%.*ls" because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
10120 16 No Cannot create %S_MSG on view "%.*ls" because it contains the ROLLUP operator. Consider not indexing this view.
10121 16 No Cannot create %S_MSG on view "%.*ls" because it contains a HAVING clause. Consider removing the HAVING clause.
10122 16 No 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.
10124 16 No Cannot create %S_MSG on view "%.*ls" because it references an internal SQL Server column.
10125 16 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No 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 No Cannot create %S_MSG on view "%.*ls" because function "%.*ls" referenced by the view performs user or system data access.
10134 16 No 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 No Cannot create %S_MSG on view "%.*ls" because it uses the aggregate COUNT. Use COUNT_BIG instead.
10137 16 No 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 No 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 No 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 No Cannot create %S_MSG on view '%.*ls' because the view contains a table hint. Consider removing the hint.
10141 16 No 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 create index.
10142 16 No Cannot create %S_MSG on view "%.*ls" because it contains an APPLY. Consider not indexing the view, or removing APPLY.
10143 16 No 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 No Cannot create %S_MSG on view '%.*ls' because it uses the CHANGETABLE function.
10145 16 No 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.
10146 16 No Cannot create %S_MSG on the view '%.*ls' because it uses the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function.
10147 16 No Cannot create %S_MSG on the view '%.*ls' because it uses temporal FOR SYSTEM_TIME clause.
10148 16 No Cannot create %S_MSG on the view '%.*ls' because it uses OPENJSON.
10149 16 No Index that has SNAPSHOT_MATERIALIZATION cannot be created on view '%.*ls' because view definition contains memory-optimized table(s).
10150 16 No Cannot create %S_MSG on the view '%.*ls' because it references a scalar UDF that is inlineable.
10151 16 No Cannot create %S_MSG on view "%.*ls" because it uses a ANTISEMI or SEMI join, and no SEMI joins are allowed in indexed views. Consider using an INNER join instead.
10211 16 No Cannot invoke mutator on a null CLR type value.
10227 16 No Field "%.*ls" of type "%.*ls.%.*ls" cannot be updated because the field is "%.*ls".
10240 16 No Could not find UdtExtensions.dll. Please check your installation.
10300 16 No 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 failed (reason: %S_MSG). Please load the referenced assembly into the current database and retry your request.
10301 16 No 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 failed (reason: %s). Please load the referenced assembly into the current database and retry your request.
10302 16 No Could not get path for SQL Server: '%ls'.
10303 16 Yes Could not create AppDomain manager: '%.*ls'.
10304 16 No Failed to enter Common Language Runtime (CLR) with HRESULT 0x%x. This may due to low resource conditions.
10305 16 No The Init method for a CLR table-valued function must be annotated with SqlFunctionAttribute.
10306 16 No The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.
10307 16 No The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.
10308 10 No 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 routine may stop working. Please refer SQL Server Books Online for more details.
10309 10 No Warning: The SQL Server client assembly '%.*ls' you are registering is not fully tested in SQL Server hosted environment.
10310 10 Yes AppDomain %i (%.*ls) is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.
10311 10 Yes AppDomain %i (%.*ls) is marked for unload due to memory pressure.
10312 16 No .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.
10313 16 No 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 No 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. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error: %.*ls
10316 16 No The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found.
10317 16 No An error occurred trying to get file version info for the file '%s'.
10318 16 No '%.*ls' failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10319 16 No UserDefinedType method call failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10320 16 No Method name '%.*ls' is invalid for '%.*ls'.
10321 16 No Method name '%.*ls' is invalid for UserDefinedType method call.
10322 16 No Type %.*ls not found in database %.*ls
10323 16 Yes Invalid user code has been identified by .Net Framework Managed Debug Assistant %.*ls
10324 16 No WITH ENCRYPTION option of CREATE TRIGGER is only applicable to T-SQL triggers and not to CLR triggers.
10325 16 Yes The server is shutting down due to stack overflow in user's unmanaged code.
10326 16 Yes Two versions of assembly '%.*ls' cannot coexist in database '%.*ls'. Keep one version and drop the other.
10327 14 No %ls ASSEMBLY for assembly '%.*ls' failed because assembly '%.*ls' is not trusted. The assembly is trusted when either of the following is true: the assembly is signed with a certificate or an asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission, or the assembly is trusted using sp_add_trusted_assembly.
10328 16 No There is not enough stack to create appdomain '%.*ls'.
10329 16 No .Net Framework execution was aborted. %.*ls
10330 16 No 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 No Type '%ls' in assembly '%.*ls' derives from a generic type which is not supported for a CLR Type.
10332 16 No Assembly "%.*ls" was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s.
10333 16 Yes Failed to obtain ICLRAppDomainResourceMonitor interface from CLR. The error code from CLR was: 0x%x. As a result, resource monitoring won't work for AppDomain with ID %d.
10334 16 No Changing the database compatibility level has caused data to be marked as unchecked in one or more objects in database %s. Refer to the column has_unchecked_assembly_data in the sys.tables and sys.views to locate all such objects.
10335 16 No The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features.
10336 10 No Failed to enque task to start CLR during SQL server startup. Error code: %u. CLR will be started in an on-demand fashion.
10337 16 No An internal error occurred.
10338 16 No Verification of assembly failed. Could not open the physical file '%.*ls': %ls.
10339 16 No Verification of assembly failed. Could not read from the physical file "%.*ls": %ls.
10340 16 No DROP ASSEMBLY failed. Error code: 0x%x.
10341 16 No Assembly '%.*ls' cannot be loaded because Azure SQL Database does not support user-defined assemblies. Contact Azure Technical Support if you have questions.
10342 16 No Assembly '%.*ls' cannot be loaded because this edition of SQL Server only supports SAFE assemblies.
10343 14 No CREATE or ALTER ASSEMBLY for assembly '%.*ls' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly.
10344 16 No Internal table access error: failed to access the Trusted Assemblies internal table with HRESULT: 0x%x. Contact Customer Support Services.
10345 16 No The assembly hash '0x%.*ls' is already trusted.
10346 16 No The assembly hash '0x%.*ls' is not currently trusted. No action was taken.
10347 16 No Common Language Runtime(CLR) is not enabled on this instance.
10501 16 No Cannot create plan guide '%.*ls' because type '%.*ls' provided is not allowed.
10502 16 No 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 plan guide.
10503 16 No Operation '%.*ls' is not allowed.
10504 16 No Cannot create plan guide '%.*ls' because parameter @hints is incorrect. Use N'OPTION ( <query_hint> [ ,...n ] )'.
10505 16 No 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 No Cannot create plan guide '%.*ls' because parameter @stmt has more than one statement.
10507 16 No 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 module or batch.
10508 16 No 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 No 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 statement within the batch. To obtain a valid starting position, query the 'statement_start_offset' column in the sys.dm_exec_query_stats dynamic management function.
10510 16 No Cannot create plan guide '%.*ls' because there is already a plan guide with that name in the database. Use a unique name.
10511 16 No Cannot create plan guide '%.*ls' because @params is not NULL. @params must be NULL if @type is 'object'.
10512 16 No 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 No 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.
10514 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be large object when @type is object.
10515 16 No Cannot create plan guide '%.*ls' because the module '%.*ls' does not exist or you do not have needed permission.
10516 16 No Cannot create plan guide '%.*ls' because @module_or_batch can not be compiled.
10517 16 No Cannot create plan guide '%.*ls' because you do not have needed permission. Alter database permission required.
10518 16 No 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 No 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 No 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-NULL value for the parameter.
10521 16 No 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 for the parameter.
10522 16 No 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 No Cannot generate query template because @querytext does not contain a valid single query.
10524 16 No Cannot parameterize @querytext.
10525 10 No 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 this plan guide or removing RECOMPILE from it.
10526 16 No 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 No Cannot create plan guide '%.*ls' because the object '%.*ls' is a temporary object.
10528 16 No Cannot create plan guide '%.*ls' because its name is invalid. Plan guide name cannot begin with a '#' character.
10529 16 No Cannot create plan guide '%.*ls' because there is already a planguide '%.*ls' of @type 'template' on @stmt.
10530 16 No 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 No 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 No 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 No 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 No Cannot create plan guide '%.*ls' because the value specified for @params is invalid. Specify the value in the form <parameter_name> <parameter_type>, or specify NULL.
10535 16 No 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 No 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 value for each statement.
10537 16 No 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 No 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 context, and you have ALTER permission on the object referenced by the plan guide or ALTER DATABASE permission.
10539 16 No 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 database objects exist, and execute the statement before creating the plan guide.
10601 16 No Cannot specify included columns for a clustered index.
10602 16 No Mixing old and new syntax in CREATE/ALTER/DROP INDEX statement is not allowed.
10603 16 No 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 No Cannot convert a statistic to an index using DROP_EXISTING index option when ONLINE index option is also specified.
10605 16 No Cannot disable primary key index "%.*ls" on table "%.*ls" because the table is published for replication.
10606 16 No Cannot disable the clustered index "%.*ls" on view "%.*ls" because the indexed view is published for replication.
10607 16 No 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 No 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 before disabling the index.
10609 16 No 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 No 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 incorporated in the view definition.
10611 16 No 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 not supported for filtered %S_MSG. To resolve this error, explicitly convert the constant to the same data type and collation as the column '%.*ls'.
10612 16 No 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 this comparison.
10617 16 No 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 No 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 No 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 No 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 No 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 No The %S_MSG '%.*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 No Filtered statistics '%.*ls' cannot be created on object '%.*ls' because it is not a user table. Filtered statistics are only supported on user tables.
10629 16 No The data type specified for column '%.*ls' in table '%.*ls' cannot be used as a column in the distribution key of an index.
10633 16 No Invalid online index creation operation
10634 10 Yes An '%.*ls' statement was executed on object '%.*ls' by hostname '%.*ls', host process ID %d using the WAIT_AT_LOW_PRIORITY options with MAX_DURATION = %d and ABORT_AFTER_WAIT = BLOCKERS. Blocking user sessions will be killed after the max duration of waiting time.
10635 16 No An online operation cannot be performed for '%.*ls' because the index contains column of large object type, and in the same transaction there are update operations before this online operation. Put the online operation outside the transaction or put it before any updates in the transaction.
10636 16 No Ignore in Optimization cannot be set for '%.*ls' on '%.*ls.%.*ls' because it is only applicable to non-clustered B-tree or columnstore indexes.
10637 16 No Cannot perform this operation on '%.*ls' with ID %I64d as one or more indexes are currently in resumable index rebuild state. Please refer to sys.index_resumable_operations for more details.
10638 16 No ALTER INDEX '%S_MSG' failed. There is no pending resumable index operation for the index '%.*ls' on '%.*ls'.
10639 16 No Resumable index operation for %S_MSG '%.*ls' failed because the index contains column '%.*ls' of type timestamp as a key column.
10640 16 No Ignore in Optimization cannot be set for an index on '%.*ls.%.*ls' because it is only applicable to indexes on user defined disk-based tables.
10641 16 No ALTER INDEX PAUSE failed. There is no actively running resumable index operation for the index '%.*ls' on '%.*ls'.
10642 16 No SNAPSHOT_MATERIALIZATION cannot be set for index '%.*ls' on '%.*ls' because it is only applicable to indexes on views.
10643 16 No SNAPSHOT_MATERIALIZATION cannot be set for '%.*ls' on '%.*ls' because it is only applicable to clustered indexes on views.
10644 16 No Resumable index operation for %S_MSG '%.*ls' failed because the index contains the computed column '%.*ls' as a key or partitioning column. If this is a non clustered index, the column will be implicitly included as a key column if it is part of the clustered index key.
10645 10 No Warning: An existing resumable operation with the same options was identified for the same index on '%.*ls'. The existing operation will be resumed instead.
10646 16 No Index '%.*ls' on view '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be dropped using the DROP_EXISTING option.
10647 16 No Index '%.*ls' on '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be altered.
10648 16 No SNAPSHOT_MATERIALIZATION cannot be set for partitioned index '%.*ls' on '%.*ls'.
10649 16 No Nonclustered index '%.*ls' cannot be created on '%.*ls' that has clustered index '%.*ls' with SNAPSHOT_MATERIALIZATION.
10650 16 No Refresh of snapshot view(s) requires snapshot isolation to be enabled on the database.
10651 16 No Refresh of snapshot view failed because view '%.*ls.%.*ls' does not exist.
10652 16 No Refresh of snapshot view failed because '%.*ls.%.*ls' is not a snapshot view.
10653 16 No Refresh of snapshot view failed.
10654 16 No Refresh of snapshot view failed because lock could not be obtained on the database.
10655 16 No Refresh of snapshot view failed because view is not specified in two-part name format.
10656 10 Yes The resumable index operation for index '%.*ls' on object '%.*ls' was paused.
10657 10 No The resumable index '%.*ls' on object '%.*ls' has been paused for '%.2f' hours.
10658 16 No Stored procedure '%ls' is currently disabled.
10659 10 Yes An ALTER INDEX '%S_MSG' was executed for index '%.*ls' on object '%.*ls' by hostname '%.*ls'.
10660 13 Yes The online index build operation was chosen as a deadlock victim over 500 times while attempting to process a single row. Resolve the blocking concurrent operation, and rerun the query.
10661 10 Yes The refresh operation for all snapshot views failed because there was another refresh operation (either for all or a single snapshot view) in progress.
10662 10 Yes The refresh operation for snapshot view '%.*ls' failed because another refresh operation for the same snapshot view was already in progress.
10663 10 Yes The refresh operation for snapshot view '%.*ls' failed because refresh operation for all snapshot views was already in progress.
10664 16 No Cannot specify included columns for indexes on memory optimized tables.
10665 15 No '%.*ls' with DROP_EXISTING option is not supported with %S_MSG option.
10666 16 Yes Cannot resume index build as required DOP %d (DOP operation was started with) is not available. Please ensure sufficient DOP is available or abort existing index operation and try again.
10667 10 No Warning: Create Index was started with MAXDOP %d. The operation will resume with MAXDOP value %d.
10668 16 No The %S_MSG option is not supported for creating an index on a heap.
10669 16 No The %S_MSG option is not supported for creating a nonclustered index on clustered columnstore index.
10670 16 No Resumable index creation for %S_MSG '%.*ls' failed because the index includes a large object column '%.*ls'.
10671 16 No The %S_MSG option is not supported for creating a filtered index.
10672 16 No The %S_MSG option is not supported for creating a clustered index on a relation that has a filtered index.
10673 16 No Cannot resume index creation due to incorrect persisted state found. Please ABORT the operation and try again.
10674 16 No The %S_MSG option is not supported for creating a clustered index on a table containing nonclustered columnstore index.
10675 16 No Internal Query Processor Error: The query processor could not produce a query plan. The RESUMABLE option is not supported for this index build. Remove the RESUMABLE option and rerun the statement.
10676 10 No The resumable index '%.*ls' on object '%.*ls' is being auto aborted because it has remained paused for more than %d minutes. Refer to the PAUSED_RESUMABLE_INDEX_ABORT_DURATION_MINUTES DATABASE SCOPED CONFIGURATION option for configuring the threshold for automatically aborting paused index operations.
10677 10 No The index '%.*ls' on object '%.*ls' was rebuilt with valid data rows but null stats were found.
10678 16 No Could not create columnstore index '%.*ls' on table '%.*ls' since column '%.*ls' is computed column which is not supported in the ORDER list.
10679 16 No Online columnstore index is not supported with ORDER clause.
10680 16 No ALTER INDEX ALL '%S_MSG' failed. There is no pending resumable index operation on '%.*ls'.
10681 16 No Cannot create a row of size %d which is greater than the allowable maximum row size of %d. Abort and retry the operation by specifying the RESUMABLE = OFF option.
10700 16 No The table-valued parameter "%.*ls" is READONLY and cannot be modified.
10701 15 No The READONLY option cannot be used in an EXECUTE or CREATE AGGREGATE statement.
10702 15 No The WITH CUBE and WITH ROLLUP options are not permitted with a ROLLUP, CUBE, or GROUPING SETS specification.
10703 15 No Too many grouping sets. The maximum number is %d.
10704 15 No To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.
10705 15 No Subqueries are not allowed in the OUTPUT clause.
10706 15 No Too many expressions are specified in the GROUP BY clause. The maximum number is %d when grouping sets are supplied.
10707 15 No 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 No DEFAULT is not allowed on the right hand side of "%.*ls"
10709 15 No The number of columns for each row in a table value constructor must be the same.
10710 15 No An action of type '%S_MSG' is not allowed in the 'WHEN NOT MATCHED' clause of a MERGE statement.
10711 15 No An action of type 'INSERT' is not allowed in the '%S_MSG' clause of a MERGE statement.
10712 15 No The pseudocolumn '%.*ls' cannot be part of an index or used as partitioning column.
10713 15 No A MERGE statement must be terminated by a semi-colon (;).
10714 15 No An action of type '%S_MSG' cannot appear more than once in a '%S_MSG' clause of a MERGE statement.
10715 15 No '%.*ls' is not a valid hint.
10716 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.
10717 15 No The %S_MSG clause is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10718 15 No Query hints are not allowed in nested INSERT, UPDATE, DELETE, or MERGE statements.
10719 16 No Foreign key relationships from a memory optimized table with DURABILITY set to SCHEMA_AND_DATA to a memory optimized table with DURABILITY set to SCHEMA_ONLY are not supported.
10720 15 No An OUTPUT INTO clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10721 15 No The WHERE CURRENT OF clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.
10722 15 No The DISTINCT keyword is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
10723 15 No 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 MERGE statement. Modify the SET clause to only specify assignments of the form 'SET @variable = column' or 'SET @variable = expression'.
10724 15 No The FORCESEEK hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10725 15 No Cannot use the VARYING option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
10726 15 No User defined aggregates do not support default parameters.
10727 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a JOIN or APPLY operator.
10728 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed as the table source of a PIVOT or UNPIVOT operator.
10729 15 No 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 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the FROM clause of an UPDATE or DELETE statement.
10731 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed inside another nested INSERT, UPDATE, DELETE, or MERGE statement.
10732 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a UNION, INTERSECT, or EXCEPT operator.
10733 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the USING clause of a MERGE statement.
10734 16 No Variable assignment is not allowed in a statement containing a top level UNION, INTERSECT or EXCEPT operator.
10735 15 No Incorrect WHERE clause for filtered %S_MSG '%.*ls' on table '%.*ls'.
10736 15 No A full-text stoplist statement must be terminated by a semi-colon (;).
10737 15 No 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 rebuilt, even if only a subset is specified in the DATA_COMPRESSION clause.
10738 15 No The number of row value expressions in the INSERT statement exceeds the maximum allowed number of %d row values.
10739 15 No The insert column list used in the MERGE statement cannot contain multi-part identifiers. Use single part identifiers instead.
10740 15 No A search property list statement must end with a semicolon (;).
10741 15 No A TOP can not be used in the same query or sub-query as a OFFSET.
10742 15 No The offset specified in a OFFSET clause may not be negative.
10743 15 No The number of rows provided for a OFFSET clause must be an integer.
10744 15 No The number of rows provided for a FETCH clause must be greater then zero.
10745 15 No The FORCESCAN hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.
10746 15 No The FORCESCAN hint is specified simultaneously with the FORCESEEK hint. Remove one of the hints and resubmit the query.
10747 15 No 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 hints for each table or view.
10748 15 No There are multiple FORCESEEK hints specified on the same table or view. Remove the extra FORCESEEK hints and resubmit the query.
10749 15 No The FORCESEEK hint cannot be used with index 0. Correct the index provided to the FORCESEEK hint and resubmit the query.
10750 15 No The FORCESCAN hint cannot be used with more than one INDEX hint. Remove the extra INDEX hints and resubmit the query.
10751 15 No The ORDER BY in WITHIN GROUP clause of '%.*ls' function must have exactly one expression.
10752 15 No The function '%.*ls' may not have a window frame.
10753 15 No The function '%.*ls' must have an OVER clause.
10754 15 No The function '%.*ls' must have a WITHIN GROUP clause.
10755 15 No The function '%.*ls' takes between %d and %d arguments.
10756 15 No Window frame with ROWS or RANGE must have an ORDER BY clause.
10757 15 No The function '%.*ls' may not have a WITHIN GROUP clause.
10758 15 No The function '%.*ls' may not have ORDER BY in OVER clause.
10759 15 No Use of DISTINCT is not allowed with the OVER clause.
10760 16 No Scale argument is not valid. Valid expressions for data type %ls scale argument are integer constants and integer constant expressions.
10761 16 No Invalid data type %.*ls in function %.*ls.
10762 16 No The %.*ls function is not allowed in the current compatibility mode. It is only allowed in 110 mode or higher.
10763 15 No GROUP BY clause can only contain one query hint. Remove the extra hints and re-run the query.
10764 15 No Number of grouping columns in the query exceeded maximum number allowed. SQL Server allows 64k grouping columns. Reduce number of grouping columns and re-run the query.
10765 15 No DISTRIBUTED_AGG and CENTRAL_AGG hints cannot be used with a CUBE or ROLLUP clause. Modify the query and re-run it.
10766 15 No CENTRAL_AGG must be specified after all columns in the GROUP BY clause. Modify the query and re-run it.
10767 15 No DISTRIBUTED_AGG hint cannot be used when the GROUP BY clause contains the same column more than once. Modify the query and re-run it.
10768 15 No LABEL hint can only be used one time in the query. Modify the query and re-run it.
10769 15 No SET options are not supported inside ATOMIC blocks.
10770 15 No The SERVER option and one of CREDENTIAL or FEDERATED_SERVICE_ACCOUNT = ON options are required for setting REMOTE_DATA_ARCHIVE on a database.
10771 15 No The CREDENTIAL option cannot be used with the FEDERATED_SERVICE_ACCOUNT = ON option.
10772 15 No There are multiple REMOTE_DATA_ARCHIVE_OVERRIDE hints specified on the same table or view reference. Remove the extra REMOTE_DATA_ARCHIVE_OVERRIDE hint(s) and resubmit the query.
10773 15 No The REMOTE_DATA_ARCHIVE_OVERRIDE hint is not applicable to object '%.*ls' because it is not a table with REMOTE_DATA_ARCHIVE enabled. Remove the REMOTE_DATA_ARCHIVE_OVERRIDE hint and resubmit the statement.
10774 15 No Incorrect WHERE clause for filtered index.
10775 16 No Object '%.*ls' is not a memory optimized table or a natively compiled inline table-valued function and cannot be accessed from a natively compiled module.
10776 16 No Triggers on non-memory optimized tables cannot use WITH NATIVE_COMPILATION.
10777 16 No Triggers on memory-optimized tables must use WITH NATIVE_COMPILATION.
10778 16 No Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported.
10779 16 No The durability option 'schema_only' is supported only with memory optimized tables.
10780 16 No There is no primary key in the referenced table '%.*ls' that matches the referencing column list in the foreign key '%.*ls'. Foreign keys in memory-optimized tables must reference primary keys.
10781 16 No Querytraceon %d and optimizer hint '%.*ls' specify conflicting behaviors. Remove one of them and rerun the query.
10782 16 No BEGIN ATOMIC is supported only in natively compiled modules.
10783 16 No The body of a natively compiled module must be an ATOMIC block.
10784 16 No The WITH clause of BEGIN ATOMIC statement must specify a value for the option '%ls'.
10785 15 No The %S_MSG '%ls' is supported only with %S_MSG.
10786 16 No The ALTER AVAILABILITY GROUP command failed because it contained multiple MODIFY REPLICA options: %ls. Enter a separate ALTER AVAILABILITY GROUP ... MODIFY REPLICA command for each replica option that you want to modify.
10787 16 No The REPEATABLEREAD and SERIALIZABLE hints are not permitted on Hekaton tables with columnstore indexes.
10788 15 No The option '%ls' is not supported with table types.
10789 15 No The option '%ls' must be specified for index '%.*ls' on table '%.*ls'. It is required for hash indexes.
10790 15 No The option '%ls' can be specified only for hash indexes.
10791 15 No Hash indexes are permitted only in memory optimized tables.
10792 15 No When used in a natively compiled module, the function '%.*ls' cannot appear outside of a catch block.
10793 16 No Both an index and a PRIMARY KEY constraint have been defined inline, with the definition of column '%.*ls', table '%.*ls'. Defining both an index and a PRIMARY KEY constraint inline with the column definition is not allowed.
10794 15 No The %S_MSG '%ls' is not supported with %S_MSG.
10795 15 No The variable '%.*ls' was declared as not null, and must be declared with an initial value.
10796 15 No The SCHEMABINDING option is supported only for natively compiled modules, and is required for those modules.
10797 15 No Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database.
10798 16 No This is not a valid data compression setting for this object. It can only be used with columnstore indexes. Please choose NONE, PAGE, or ROW compression.
10799 16 No This is not a valid data compression setting for a columnstore index. Please choose COLUMNSTORE or COLUMNSTORE_ARCHIVE compression.
10800 16 No The listener for the WSFC resource '%.*ls' failed to start, and returned error code %d, '%.*ls'. For more information about this error code, see "System Error Codes" in the Windows Development Documentation.
10801 16 No Failed to stop the listener for Windows Failover Cluster resource '%.*ls'. Error: %d. %.*ls
10802 10 No Failed to enqueue a task to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is added manually or SQL Server is restarted. SQLOS error code: %d.
10900 16 No 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 No User does not have permission to alter the resource governor configuration.
10902 16 No User-defined function '%s' does not exist in master database, or the user does not have permission to access it.
10903 16 No 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 No 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 No 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 No 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 No Attribute '%.*ls' with value of %u is greater than attribute '%.*ls' with value of %u.
10908 16 No Attribute '%.*ls' with value of %u is less than attribute '%.*ls' with value of %u.
10909 16 No The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools.
10910 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than or equal to 100.
10911 16 No Requested operation cannot be performed because the resource pool '%.*ls' does not exist.
10912 16 No The operation could not be completed. Dropping predefined %S_MSG is not allowed.
10913 16 No Users are not allowed to %S_MSG the workload group '%.*ls' in the '%.*ls' resource pool.
10914 16 No The name of the %S_MSG '%.*ls' cannot begin with # of ##.
10915 16 No The operation could not be completed. Altering '%.*ls' %S_MSG is not allowed.
10916 16 No 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 No ALTER WORKLOAD GROUP failed. Either a 'WITH' or 'USING' clause must be specified.
10918 16 No Cannot create %S_MSG '%.*ls' because it already exists.
10919 16 No 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 No Cannot %S_MSG user-defined function '%.*ls'. It is being used as a resource governor classifier.
10921 16 No The '%.*ls' %S_MSG cannot be moved out of '%.*ls' %S_MSG.
10922 16 No %ls failed. Rerun the statement.
10923 16 No %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 governor.
10924 16 No The pool affinity range is invalid. The lower bound %d must be less than the upper bound %d.
10925 16 No A %S_MSG value was specified more than one time in the pool affinity range list.
10926 16 No The %S_MSG range that specifies %S_MSG %d includes at least one %S_MSG that is not available to the current instance. The maximum %S_MSG number that is available to this instance is %d.
10927 16 No The operation could not be completed. The specified '%.*ls' value, %u, causes the sum of minimums on all workload groups using resource pool '%.*ls' to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.
10928 16 No Resource ID : %d. The %ls limit for the database is %d and has been reached. See 'https://learn.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.
10929 16 No Resource ID : %d. The %ls minimum guarantee is %d, maximum limit is %d and the current usage for the database is %d. However, the server is currently too busy to support %ls greater than %d for this database. See 'https://learn.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance. Otherwise, please try again later.
10930 16 No The service is currently too busy. Please try again later.
10931 16 No Cannot drop resource pool '%.*ls' because it is bound to a database. Remove all bindings to this resource pool before dropping it.
10932 16 No Resource governor configuration failed, because there is an active database in the resource pool being dropped. Take the database offline and try again.
10933 16 No A %S_MSG with id %d does not exist on this system. Use sys.dm_os_schedulers to locate valid %S_MSGs for this system.
10934 16 No Requested operation cannot be performed because the external resource pool '%.*ls' does not exist.
10935 16 No External resource pool does not allow more than one processor group.
10936 16 No Resource ID : %d. The %ls limit for the elastic pool is %d and has been reached. See 'https://learn.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.
10937 16 No Default workload group does not allow to alter attribute '%.*ls'.
10961 16 No The request has been aborted because its CPU usage exceeds the maximum configured limit for the workload group.
10981 10 No Resource governor reconfiguration succeeded.
10982 16 Yes Failed to run resource governor classifier user-defined function '%.*ls'. Last error %u, state %u. See previous errors in SQL Server error log from session ID %ld for details. Classifier elapsed time: %I64u ms.
10983 16 No Resource governor '%ls' operation was canceled by user.
10984 16 No Resource governor reconfiguration failed.
10985 10 No Resource governor reconfiguration encountered an issue (HRESULT code : 0x%lx, reason: %ls), while sending active external resource pool ids to launchpad. This will not fail reconfigure.
10986 10 No Load resource governor configuration from replicated master failed to complete.
10987 10 No Load resource governor configuration from replicated master failed to start. Unable to submit async task.