MSSQLSERVER_10502
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Details
Product Name |
SQL Server |
Event ID |
10502 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
PG_DUP_FOUND |
Message Text |
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. |
Explanation
A plan guide exists for the specified statement.
User Action
Drop the existing plan guide before creating the new plan guide.
See Also
Reference
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)