MSSQLSERVER_10509
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
|
Event ID |
10509 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
PG_INVALID_STMT |
Message Text |
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 obtain a valid starting position, query the statement_start_offset column in the sys.dm_exec_query_stats dynamic management function. |
Explanation
The statement specified by @stmt or @statement\_start\_offset either contains a syntax error or is ineligible for use in a plan guide.
User Action
Provide a single valid Transact-SQL statement or a valid starting position of the statement within the batch. To obtain a valid starting position, query the statement_start_offset column in the sys.dm_exec_query_stats dynamic management function.