2 Replies Latest reply on May 24, 2010 9:28 AM by Stu McNeill

    OOTB: Change Compatibility level

    ewid Apprentice



      Our customer ask following question :

      1. Why OOTB 7.2 running in SQL Server 2005 with Compatibility Level 2000 (80) ?

      2. Can OOTB 7.2 changing to Compatibility Level 2005 (90).


      I have tried in my virtual machine its so easy just change the parameter but I worried if database change succesfully. Did any script need?


      Please advice. Thanks in advance.

        • 1. Re: OOTB: Change Compatibility level


          yeah, we had been looking at this as well in our company on recommendation from our dba who spotted the compatability level was out. in contacting Landesk directly their recommedation was to change it but try it on a test system first. for 7.2+ (we were on 7.2.6 at the time). 7.2 specifically mentions sql 2005 as a supported platform so unless you have done some customised work in the form of scripts, stored procedures etc. it should be fine. but test, test , test!


          • 2. Re: OOTB: Change Compatibility level
            Stu McNeill Employee



            Just to add to Dave's comment SQL 2005 is officially supported, and SQL 2008 from version 7.2.6.  This will be regardless of the compatibility level and from personal experience I've not seen any issues with either 2005 or 2008 levels so far.