Cannot create %1!s! on view "%2!s!" 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.
Cannot create %1!s! on view "%2!s!" because it contains a ranking or aggregate window function. Remove the function from ...
Cannot create %1!s! on view "%2!s!" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER ...
Cannot create %1!s! on view "%2!s!" because it contains more than one APPLY. Consider not indexing the view, or using only ...
Cannot create %1!s! on view "%2!s!" because it contains one or more subqueries. Consider changing the view to use only joins ...
Cannot create %1!s! on view "%2!s!" because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or ...
Cannot create %1!s! on view "%2!s!" because it contains the TABLESAMPLE clause. Consider removing TABLESAMPLE or not indexing ...
Cannot create %1!s! on view "%2!s!" because it contains the TOP keyword. Consider removing TOP or not indexing the view. ...
Cannot create %1!s! on view "%2!s!" because it references a table using a CONTAINSTABLE or FREETEXTTABLE full-text function. ...
Cannot create %1!s! on view "%2!s!" because it references an internal system rowset provider. Consider not indexing this ...