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:
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 :)