This topic has not yet been rated - Rate this topic

DatabaseCompatibilityLevel Enumeration

SQL Server 2012

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 name	Description
	Current	Compatible with the latest version of SQL Server.
	Version100	A database compatibility level of 100, or SQL Server 2008.
	Version110	A database compatibility level of 110, or SQL Server 2012.
	Version80	A database compatibility level of 80.
	Version90	A 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).

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions