How to change database compatible level in SQL Server Management Studio: right click the database, open Properties, then Options, and pick the level you need.
SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility
Use sp_dbcmptlevel to change the database compatible level, like 80 for SQL Server 2000 or 90 for 2005, plus the three step best practice to do it.