Script to change the database compatibility level

Use below script to change the database compatibility level

ALTER DATABASE DatabaseName
SET SINGLE_USER
GO
EXEC sp_dbcmptlevel DatabaseName, 90;
GO
ALTER DATABASE DatabaseName
SET MULTI_USER
GO


SQL Server Version	Compatibility Level
SQL Server 6.5	65
SQL Server 7.0	70
SQL Server 2000	80
SQL Server 2005	90
SQL Server 2008	100