Home Forums SQL Server 2008 T-SQL (SS2K8) Prevent Stored Procedure using bad execution plan RE: Prevent Stored Procedure using bad execution plan

  • Are you allowed to modify the underlying procedure?

    If you aren't allowed to modify it and you have Enterprise edition you can use sys.sp_create_plan_guide to start changing things. But it has a bunch of caveats and can (among other things) break later software upgrades. https://technet.microsoft.com/en-us/library/ms190417(v=sql.110).aspx