Thursday, 6 December 2012

SQL Server

ALTER DATABASE Compatibility Level (Transact-SQL) (Ex: Enable pivot table)

ALTER DATABASE database_name 
SET COMPATIBILITY_LEVEL = 100

Note:


        80 = SQL Server 2000 

        90 = SQL Server 2005 

        100 = SQL Server 2008 and SQL Server 2008 R2


        110 = SQL Server 2012

Subscribe to: Comments (Atom)