SQL Server Errors

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.

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

Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission.

Error Message: Msg 10515, Level 16, State 1, Procedure sp_create_plan_guide, Line 15 Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission. Severity level: 16. Description: This error message appears when you try to create a planguide, but the object specified in the @module_or_batch parameter does […]

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*ls’.

Error Message: Msg 4945, Level 16, State 1, Line 2 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to run an ALTER TABLE SWITCH statement for which columns in the base tables do […]

Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled.

Error Message: Msg 10516, Level 16, State 1, Procedure sp_create_plan_guide, Line 20 Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled. Severity level: 16. Description: This error message appears when you try to create a planguide, but the @module_or_batch parameter cannot be compiled. Consequences: The T-SQL statement can be parsed, but causes the […]

Cannot create plan guide ‘%.*ls’ because value ‘%.*ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’.

Error Message: Msg 10505, Level 16, State 1, Procedure sp_create_plan_guide, Line 15 Cannot create plan guide ‘%.*ls’ because value ‘%.*ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’. Severity level: 16. Description: This error message appears when you try to create a planguide, but the value provided for the @module_or_batch parameter is not […]

XML parsing: line %d, character %d, unexpected end of input

Error Message: Msg 9400, Level 16, State 1, Line 2 XML parsing: line %d, character %d, unexpected end of input Severity level: 16. Description: This error message appears when during XML parsing an unexpected end of input is found. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of […]

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, matches the existing plan guide ‘%.*ls’ in the database

Error Message: Msg 10502, 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, matches the existing plan guide ‘%.*ls’ in the database. Drop the existing plan guide before creating the new plan guide. Severity level: 16. Description: This error message […]

Cannot %S_MSG %S_MSG ‘%.*ls’ because it is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed.

Error Message: Msg 10513, Level 16, State 1, Line 3 Cannot %S_MSG %S_MSG ‘%.*ls’ because it is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed. Severity level: 16. Description: This error message appears when you try to drop an object […]

XML parsing: line %d, character %d, end tag does not match start tag

Error Message: Msg 9436, Level 16, State 1, Line 2 XML parsing: line %d, character %d, end tag does not match start tag Severity level: 16. Description: This error message appears when during XML parsing an end tag cannot be matched with a corresponding start tag. Consequences: The T-SQL statement can be parsed, but causes […]

Cannot create plan guide ‘%.*ls’ because type ‘%.*ls’ provided is not allowed.

Error Message: Msg 10501, Level 16, State 1, Procedure sp_create_plan_guide, Line 20 Cannot create plan guide ‘%.*ls’ because type ‘%.*ls’ provided is not allowed. Severity level: 16. Description: This error message appears when you try to create a planguide, but the type specified by @type is not a recognized type. Consequences: The T-SQL statement can […]
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 |