Επεξεργασία

Κοινή χρήση μέσω


MSSQLSERVER_10502

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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)