SQL Server Errors

Cannot create plan guide ‘%.*ls’ because its name is invalid. Plan guide name cannot begin with a ‘#’ character.

Error Message: Msg 10528, Level 16, State 1, Procedure sp_create_plan_guide, Line 15 Cannot create plan guide ‘%.*ls’ because its name is invalid. Plan guide name cannot begin with a ‘#’ character. Severity level: 16. Description: This error message appears when you try to create a plan guide with an invalid name. Consequences: The T-SQL statement […]

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

Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,...n ] )’.

Error Message: Msg 10504, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( <query_hint> [ ,...n ] )’. Severity level: 16. Description: This error message appears when you try to create a planguide, but the @hints parameter is incorrect. Consequences: The T-SQL statement can be […]

Cannot specify included columns for a clustered index.

Error Message: Msg 10601, Level 16, State 1, Line 1 Cannot specify included columns for a clustered index. Severity level: 16. Description: This error message appears when you try to use the INCLUDE clause for a clustered index. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the […]

Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint.

Error Message: Msg 10112, Level 16, State 1, Line 2 Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint. Severity level: 16. Description: This error message appears when you try to create an index on a view that contains a JOIN hint. […]

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch.

Error Message: Msg 10507, Level 16, State 1, Line 1 Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch. Modify the values to match a statement in the module or batch. Severity level: 16. Description: […]

COMPUTE clause #%d, aggregate expression #%d is not in the select list.

Error Message: Msg 411, Level 16, State 1, Line 6 COMPUTE clause #%d, aggregate expression #%d is not in the select list. Severity level: 16. Description: This error message appears when you try to use an aggregate expression in a COMPUTE clause that does not appear in the SELECT list. Consequences: The T-SQL statement can […]

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 […]
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 |