Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Friday, 14 February 2014

To change compatibility level in SQL Server

To change compatibility level in SQL Server

To set compatibility for a DB in SQL Server 2005:

exec sp_dbcmptlevel dbname, {80|90|100}

To set compatibility for a DB in SQL Server 2000:

ALTER DATABASE AdventureWorks
SET COMPATIBILITY_LEVEL = 90;

To set compatibility for a DB in SQL Server