Setting Database Compatibility Level for Microsoft SQL Server 2008

Change the database compatibility level to 100 for all existing databases that will be upgraded from an earlier version of Microsoft SQL Server. All new configurations created against Microsoft SQL Server 2008 databases will have the correct value.

To set the database compatibility level:

Log on to the database instance.
Execute the command:
```
sp_dbcmptlevel @dbname = name,@new_cmptlevel = version]
```
@dbname=name

Database name for which you are changing the compatibility level. Database names must conform to the identifier rules.

@new_cmptlevel=version

Microsoft SQL Server version with which to make the database compatible. The value must be set to 100.