MSSQLSERVER_10502

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

Details

Attribute	Value
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

Plan Guides
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)