sql-server-2005sql-server-2000compatibility-level

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?


Solution

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