Should I change my upgraded database's compatibility level from 8 to 9?

I am planning to upgrade a SQL Server 2000 instance to a SQL Server 2005 instance.

I am not going to change any database code, so I won't be taking advantage of any SQL2005 specific syntax. Is there any reason to set my compatibility higher (to level 9)? Or is it ok to leave at compatibility level 8?

There are two ways to look at this:

• If you want to change your code (or install some collaborating SQL2005/2008 servers) in the future, your compatibility mode will affect that decision
• If you haven't run the Upgrade Adviser, you may not be able to upgrade :) compatibility level 9 disables certain syntaxes and features that were available in 8.

So, simple answer is no you don't have to increase your compat level, but then you've to consider your future with this box too :)