SQL Server Errors or Failures from Error: 10104 to Error: 10126

SQLServerF1

 

Error: 10104, Severity: 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.
Error: 10105, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it uses the OPENXML rowset provider. Consider removing OPENXML or not indexing the view.
Error: 10106, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it references an internal system rowset provider. Consider not indexing this view.
Error: 10107, Severity: 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.

Error: 10108, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it references a SQL Server internal table.
Error: 10109, Severity: 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.
Error: 10110, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY.
Error: 10111, Severity: 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.
Error: 10112, Severity: 16, Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint.

Error: 10113, Severity: 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.
Error: 10114, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it uses the PIVOT operator. Consider not indexing this view.
Error: 10115, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it uses the UNPIVOT operator. Consider not indexing this view.
Error: 10116, Severity: 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.
Error: 10117, Severity: 16, Cannot create %S_MSG on view “%.*ls” because the view uses the “*” operator to select columns. Consider referencing columns by name instead.
Error: 10118, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it contains a GROUP BY ALL. Consider using a GROUP BY instead.
Error: 10119, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.
Error: 10121, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it contains a HAVING clause. Consider removing the HAVING clause.
Error: 10124, Severity: 16, Cannot create %S_MSG on view “%.*ls” because it references an internal SQL Server column.
Error: 10125, Severity: 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.
Error: 10126, Severity: 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.

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 *