Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Practice Test
Tip of the Day : SQL Server Database Design - Internet Movie Database (IMDb)
Error Messages
Home > Tips & Tricks > Error Messages 10001 to 10500
SQL Server Error Messages - Errors 10001 to 10500

A message number uniquely identifies each error message and the error message text describes the problem.  The error message text often includes placeholders for information (such as object names) to be inserted in the error message when it is displayed.  Unfortunately, the error message text does not tell you how to solve or work around the problem.  In this series of Error Messages list, we will try to provide you with ways on how to overcome or work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as "Invalid object name".  Others are harder to fix or work around, especially by those who are new to SQL Server.  It is the intent of this page and succeeding pages (to come) to assist you in addressing or working around SQL Server error messages.

Error Severity Description
10001 16 The provider reported an unexpected catastrophic failure.
10002 16 The provider did not implement the functionality.
10003 16 The provider ran out of memory.
10004 16 One or more arguments were reported invalid by the provider.
10005 16 The provider did not support an interface.
10006 16 The provider indicated an invalid pointer was used.
10007 16 The provider indicated an invalid handle was used.
10008 16 The provider terminated the operation.
10009 16 The provider did not give any information about the error.
10010 16 The data necessary to complete this operation was not yet available to the provider.
10011 16 Access denied.
10021 16 Execution terminated by the provider because a resource limit was reached.
10022 16 The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.
10023 16 The provider does not support the necessary method.
10024 16 The provider indicates that the user did not have the permission to perform the operation.
10025 16 Provider caused a server fault in an external process.
10026 16 No command text was set.
10027 16 Command was not prepared.
10028 16 Authentication failed.
10032 16 Cannot return multiple result sets (not supported by the provider).
10033 16 The specified index does not exist or the provider does not support an index scan on this data source.
10034 16 The specified table or view does not exist or contains errors.
10035 16 No value was given for one or more of the required parameters.
10042 16 Cannot set any properties while there is an open rowset.
10052 16 The insertion was canceled by the provider during notification.
10053 16 Could not convert the data value due to reasons other than sign mismatch or overflow.
10054 16 The data value for one or more columns overflowed the type used by the provider.
10055 16 The data violated the integrity constraints for one or more columns.
10056 16 The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10057 16 Cannot create the row. Would exceed the total number of active rows supported by the rowset.
10058 16 The consumer cannot insert a new row before releasing previously-retrieved row handles.
10062 16 The change was canceled by the provider during notification.
10063 16 Could not convert the data value due to reasons other than sign mismatch or overflow.
10064 16 The data value for one or more columns overflowed the type used by the provider.
10065 16 The data violated the integrity constraints for one or more columns.
10066 16 The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.
10067 16 The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
10068 16 The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.
10069 16 The consumer could not delete the row. The insertion has been transmitted to the data source.
10081 16 The rowset uses integrated indexes and there is no current index.
10085 16 RestartPosition on the table was canceled during notification.
10086 16 The table was built over a live data stream and the position cannot be restarted.
10087 16 The provider did not release some of the existing rows.
10088 16 The order of the columns was not specified in the object that created the rowset. The provider had to reexecute the command to reposition the next fetch position to its initial position, and the order of the columns changed.
10100 16 Cannot create %S_MSG on view "%.*ls" because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or not indexing the view. Alternatively, consider replacing DISTINCT with GROUP BY or COUNT_BIG(*) to simulate DISTINCT on grouping col
10101 16 Cannot create %S_MSG on view "%.*ls" because it contains the TOP or OFFSET keyword. Consider removing the TOP or OFFSET or not indexing the view.
10102 16 Cannot create %S_MSG on view "%.*ls" because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing the view.
10103 16 Cannot create %S_MSG on view "%.*ls" because it uses OPENROWSET, OPENQUERY, or OPENDATASOURCE. Consider not indexing the view, or eliminating OPENQUERY, OPENROWSET, and OPENDATASOURCE.
10104 16 Cannot create %S_MSG on view "%.*ls" because it references a table using a CONTAINSTABLE or FREETEXTTABLE full-text function. Consider removing use of these functions or not indexing the view.
10105 16 Cannot create %S_MSG on view "%.*ls" because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
10106 16 Cannot create %S_MSG on view "%.*ls" because it references an internal system rowset provider. Consider not indexing this view.
10107 16 Cannot create %S_MSG on view "%.*ls" because it uses table variable "%.*ls". Consider not indexing this view or removing the reference to the table variable.
10108 16 Cannot create %S_MSG on view "%.*ls" because it references a SQL Server internal table.
10109 16 Cannot create %S_MSG on view "%.*ls" because it references derived table "%.*ls" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.
10110 16 Cannot create %S_MSG on view "%.*ls" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
10111 16 Cannot create %S_MSG on view "%.*ls" because it contains a join using an ODBC standard escape syntax. Consider using an ANSI join syntax instead.
10112 16 Cannot create %S_MSG on view '%.*ls' because it contains an INNER join that specifies a join hint. Consider removing the join hint.
10113 16 Cannot create %S_MSG on view "%.*ls" because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead.
10114 16 Cannot create %S_MSG on view "%.*ls" because it uses the PIVOT operator. Consider not indexing this view.
10115 16 Cannot create %S_MSG on view "%.*ls" because it uses the UNPIVOT operator. Consider not indexing this view.
10116 16 Cannot create %S_MSG on view '%.*ls' because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view.
10117 16 Cannot create %S_MSG on view "%.*ls" because the view uses the "*" operator to select columns. Consider referencing columns by name instead.
10118 16 Cannot create %S_MSG on view "%.*ls" because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
10119 16 Cannot create %S_MSG on view "%.*ls" because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
10121 16 Cannot create %S_MSG on view "%.*ls" because it contains a HAVING clause. Consider removing the HAVING clause.
10124 16 Cannot create %S_MSG on view "%.*ls" because it references an internal SQL Server column.
10125 16 Cannot create %S_MSG on view "%.*ls" because it uses aggregate "%.*ls". Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG.
10126 16 Cannot create %S_MSG on view "%.*ls" because it uses aggregate "%.*ls" with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.
10127 16 Cannot create %S_MSG on view "%.*ls" because it contains one or more subqueries. Consider changing the view to use only joins instead of subqueries. Alternatively, consider not indexing this view.
10128 16 Cannot create %S_MSG on view "%.*ls" because it uses a CONTAINS or FREETEXT full-text predicate. Consider eliminating CONTAINS or FREETEXT, or not indexing the view.
10129 16 Cannot create %S_MSG on view "%.*ls" because it references the inline or multistatement table-valued function "%.*ls". Consider expanding the function definition by hand in the view definition, or not indexing the view.
10130 16 Cannot create %S_MSG on view "%.*ls" because it uses non-deterministic common language runtime (CLR) table-valued function "%.*ls". Consider not indexing the view or changing it to not use this function.
10131 16 Cannot create %S_MSG on view "%.*ls" because it references imprecise common language runtime (CLR) table-valued function "%.*ls". Consider not indexing the view.
10132 16 Cannot create %S_MSG on view "%.*ls" because it references table valued common language runtime (CLR) function "%.*ls". Consider removing reference to the function or not indexing the view.
10133 16 Cannot create %S_MSG on view "%.*ls" because function "%.*ls" referenced by the view performs user or system data access.
10134 16 Cannot create %S_MSG on view "%.*ls" because it contains more than one APPLY. Consider not indexing the view, or using only one APPLY.
10136 16 Cannot create %S_MSG on view "%.*ls" because it uses the aggregate COUNT. Use COUNT_BIG instead.
10137 16 Cannot create %S_MSG on view "%.*ls" because it references common table expression "%.*ls". Views referencing common table expressions cannot be indexed. Consider not indexing the view, or removing the common table expression from the view definition.
10138 16 Cannot create %S_MSG on view '%.*ls' because its select list does not include a proper use of COUNT_BIG. Consider adding COUNT_BIG(*) to select list.
10139 16 Cannot create %S_MSG on view '%.*ls' because the view uses an implicit conversion from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style value.
10140 16 Cannot create %S_MSG on view '%.*ls' because the view contains a table hint. Consider removing the hint.
10141 16 Cannot create %S_MSG on view '%.*ls' because it references CLR routine (function or method) '%.*ls' outside non-key columns of SELECT list. Recreate or alter view so it does not reference CLR routines except in non-key columns of SELECT list, and then cre
10142 16 Cannot create %S_MSG on view "%.*ls" because it contains an APPLY. Consider not indexing the view, or removing APPLY.
10143 16 Cannot create %S_MSG on view "%.*ls" because it contains a ranking or aggregate window function. Remove the function from the view definition or, alternatively, do not index the view.
10144 16 Cannot create %S_MSG on view '%.*ls' because it uses the CHANGETABLE function.
10145 16 Cannot create %S_MSG on the view '%.*ls' because it references a sparse column set. Views that contain a sparse column set cannot be indexed. Consider removing the sparse column set from the view or not indexing the view.
10146 16 Cannot create %S_MSG on the view '%.*ls' because it uses the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function.
10211 16 Cannot invoke mutator on a null CLR type value.
10227 16 Field "%.*ls" of type "%.*ls.%.*ls" cannot be updated because the field is "%.*ls".
10240 16 Could not find UdtExtensions.dll. Please check your installation.

Error Severity Description
10300 16 Assembly '%.*ls' references assembly '%.*ls', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has fai
10301 16 Assembly '%.*ls' references assembly '%.*ls', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has fai
10302 16 Could not get path for SQL Server: '%ls'.
10303 16 Could not create AppDomain manager: '%.*ls'.
10304 16 Failed to enter Common Language Runtime (CLR) with HRESULT 0x%x. This may due to low resource conditions.
10305 16 The Init method for a CLR table-valued function must be annotated with SqlFunctionAttribute.
10306 16 The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.
10307 16 The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.
10308 10 Warning: The Microsoft .NET Framework assembly '%.*ls' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration ro
10309 10 Warning: The SQL Server client assembly '%.*ls' you are registering is not fully tested in SQL Server hosted environment.
10310 10 AppDomain %i (%.*ls) is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.
10311 10 AppDomain %i (%.*ls) is marked for unload due to memory pressure.
10312 16 .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.
10313 16 An error occurred while using the .NET Framework during %S_MSG. The server may be running out of resources. Try running the query again. If the problem persist, contact a support professional. %.*ls
10314 16 An error occurred in the Microsoft .NET Framework while trying to load assembly id %d. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentat
10316 16 The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found.
10317 16 An error occurred trying to get file version info for the file '%s'.
10318 16 '%.*ls' failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10319 16 UserDefinedType method call failed because parameter %d of method '%.*ls' of type '%.*ls' is annotated with unsupported attribute System.ParamArrayAttribute.
10320 16 Method name '%.*ls' is invalid for '%.*ls'.
10321 16 Method name '%.*ls' is invalid for UserDefinedType method call.
10322 16 Type %.*ls not found in database %.*ls
10323 16 Invalid user code has been identified by .Net Framework Managed Debug Assistant %.*ls
10324 16 WITH ENCRYPTION option of CREATE TRIGGER is only applicable to T-SQL triggers and not to CLR triggers.
10325 16 The server is shutting down due to stack overflow in user's unmanaged code.
10326 16 Two versions of assembly '%.*ls' cannot coexist in database '%.*ls'. Keep one version and drop the other.
10327 14 %ls ASSEMBLY for assembly '%.*ls' failed because assembly '%.*ls' is not authorized for PERMISSION_SET = %ls. The assembly is authorized when either of the following is true: the database owner (DBO) has %ls permission and the database has the TRUSTWORTH
10328 16 There is not enough stack to create appdomain '%.*ls'.
10329 16 .Net Framework execution was aborted. %.*ls
10330 16 ALTER ASSEMBLY failed because serialization layout of type '%s' would change as a result of a change in type '%s' in the updated assembly. Persisted types are not allowed to change serialization layout.
10331 16 Type '%ls' in assembly '%.*ls' derives from a generic type which is not supported for a CLR Type.
10332 16 Assembly "%.*ls" was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s.
10333 16 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 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 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
10336 10 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 An internal error occurred.
10338 16 Verification of assembly failed. Could not open the physical file '%.*ls': %ls.
10339 16 Verification of assembly failed. Could not read from the physical file "%.*ls": %ls.

Related Articles :