Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hardik Doshi Query text during caching in SQL 2005 RE: Query text during caching in SQL 2005

  • November 15, 2010 at 9:39 am

    #1250821

    Carlo Romagnano (11/14/2010)

    In sql2005, I get an error:

    "plan_handle" is not a recognized table hints option.

    Carlo,

    Please check compat level of your SQL Server 2005 AdventureWorks database. If the level is 80 then you should get "plan_handle" is not a recognized table hints option error, but if it is 90 as it should be then the script should run just fine.

    Oleg