SQL Server Errors

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 Message: Msg 10113, Level 16, State 1, Line 2 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. Severity level: 16. Description: This error message appears when you try to create an […]

Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.

Error Message: Msg 10506, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement. Severity level: 16. Description: This error message appears when you try to create a planguide, but the @stmt parameter contains more than one statement. Consequences: The T-SQL statement can be parsed, but […]

FIPS Warning: Line %d has the non-ANSI statement ‘%ls’.

Error Message: FIPS Warning: Line %d has the non-ANSI statement ‘%ls’. FIPS Warning: Line %d has the non-ANSI statement ‘%ls’. Severity level: 10. Description: This informational error message appears when you try to use a non-ANSI compliant statement while the FIPS FLAGGER is activated. Consequences: Resolution: Error of this severity level are informational errors that […]

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 Message: Msg 10116, Level 16, State 1, Line 2 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. Severity level: 16. Description: […]

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide.

Error Message: Msg 10509, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide. Provide a single valid Transact-SQL statement or a valid starting position of the statement within the batch. To […]

FIPS Warning: Line %d has the non-ANSI clause ‘%ls’.

Error Message: FIPS Warning: Line %d has the non-ANSI clause ‘%ls’. FIPS Warning: Line %d has the non-ANSI clause ‘%ls’. Severity level: 10. Description: This informational error message appears when you try to use a non-ANSI compliant statement while the FIPS FLAGGER is activated. Consequences: Resolution: Error of this severity level are informational errors that […]

Cannot create %S_MSG on view “%.*ls” because it contains a HAVING clause. Consider removing the HAVING clause.

Error Message: Msg 10121, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it contains a HAVING clause. Consider removing the HAVING clause. Severity level: 16. Description: This error message appears when you try to create an index on a view that contains a HAVING clause. Consequences: The T-SQL statement can […]

Cannot create plan guide ‘%.*ls’ because the hints specified in @hints cannot be applied to the statement specified by either @stmt or @statement_start_offset. Verify that the hints can be applied to the statement.

Error Message: Msg 10519, Level 16, State 1, Procedure p, Line 2 Cannot create plan guide ‘%.*ls’ because the hints specified in @hints cannot be applied to the statement specified by either @stmt or @statement_start_offset. Verify that the hints can be applied to the statement. Severity level: 16. Description: This error message appears when you […]

FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18.

Error Message: FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18. FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18. Severity level: 10. Description: This informational error message appears when you try to use an identifier that exceeds the length of 18 characters. Consequences: Resolution: Error of this severity level are informational errors that do […]

Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.

Error Message: Msg 10119, Level 16, State 1, Line 2 Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view. Severity level: 16. Description: This error message appears when you try to create an index on a view that contains a CUBE, ROLLUP, or […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |