SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

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

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

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

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

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.

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

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

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

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.

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

Page 17 of 82
<
1
...
12
13
14
15
16
17
18
19
20
21
...
82
>

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 |