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:24 pm

    #1251080

    Oleg Netchaev (11/15/2010)

    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

    Thanks for resolving the issue, due to project work not able to answer.

    Thanks