How to change the compatibility level of a database

If any feature is not supported in your current database compatibility level, you will get a syntax error saying you can change it in SSMS.

1. In SSMS 2008, go to the database in object explorer under Databases folder.
2. Right click the database you want to change the compatibility level.
3. In Properties, Options select the option you want in Compatibility level drop down.