SQL Server Errors or Failures from Error: 10127 to Error: 10211

SQLServerF1

 

Error: 10127, Severity: 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.
Error: 10128, Severity: 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.
Error: 10129, Severity: 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.
Error: 10130, Severity: 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.
Error: 10131, Severity: 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.
Error: 10132, Severity: 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.

Error: 10133, Severity: 16, Cannot create %S_MSG on view “%.*ls” because function “%.*ls” referenced by the view performs user or system data access.
Error: 10134, Severity: 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.
Error: 10136, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it uses the aggregate COUNT. Use COUNT_BIG instead.
Error: 10137, Severity: 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.
Error: 10138, Severity: 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.
Error: 10139, Severity: 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.
Error: 10140, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’ because the view contains a table hint. Consider removing the hint.
Error: 10141, Severity: 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
Error: 10142, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it contains an APPLY. Consider not indexing the view, or removing APPLY.
Error: 10143, Severity: 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.
Error: 10144, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’ because it uses the CHANGETABLE function.
Error: 10145, Severity: 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.
Error: 10146, Severity: 16, Cannot create %S_MSG on the view ‘%.*ls’ because it uses the SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE or SEMANTICSIMILARITYDETAILSTABLE function.
Error: 10211, Severity: 16, Cannot invoke mutator on a null CLR type value.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *