| 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. |