Export (0) Print
Expand All

DatabaseCompatibilityLevel Enumeration

Enumerates the SQL Server database compatibility levels.

Namespace:  Microsoft.SqlServer.Management.SqlParser.Common
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

public enum DatabaseCompatibilityLevel

Member nameDescription
CurrentCompatible with the latest version of SQL Server.
Version100A database compatibility level of 100, or SQL Server 2008.
Version110A database compatibility level of 110, or SQL Server 2012.
Version120A database compatibility level of 120, or SQL Server 2014.
Version80A database compatibility level of 80.
Version90A database compatibility level of 90, or SQL Server 2005.

A compatibility level sets certain database behaviors to be compatible with the specified version of SQL Server. For more information, see ALTER DATABASE Compatibility Level (Transact-SQL).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft