Tag Archives: database Compatibility

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
Advertisements