Merk
Tilgang til denne siden krever autorisasjon. Du kan prøve å logge på eller endre kataloger.
Tilgang til denne siden krever autorisasjon. Du kan prøve å endre kataloger.
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)