CompatibilityLevel Property (Database)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The CompatibilityLevel property controls the behavior of an instance of Microsoft SQL Server, setting behavior to match a specified version of Microsoft SQL Server.

Syntax

object.CompatibilityLevel [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • value
    A long integer that specifies an instance of SQL Server as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetCompatibilityLevel(
SQLDMO_COMP_LEVEL_TYPE* pRetVal);
HRESULT SetCompatibilityLevel(
SQLDMO_COMP_LEVEL_TYPE NewValue);

Settings

Set CompatibilityLevel using these SQLDMO_COMP_LEVEL_TYPE values.

Constant

Value

Description

SQLDMOCompLevel_60

60

Forces SQL Server version 6.0 behavior.

SQLDMOCompLevel_65

65

Forces SQL Server version 6.5 behavior.

SQLDMOCompLevel_70

70

Forces SQL Server version 7.0 behavior.

SQLDMOCompLevel_80

80

The instance behaves as documented for SQL Server 2000.

SQLDMOCompLevel_90

90

Default. The instance behaves as documented for SQL Server 2005.

SQLDMOCompLevel_Unknown

0

The value is not valid.

Warning

SQL Server Management Studio and SQL Server Management Objects (SMO) do not support a SQLDMO_COMP_LEVEL_TYPE value of 60. If you use SMO or SQL Server Management Studio with a database set to a SQLDMO_COMP_LEVEL_TYPE value of 60, some operations will produce errors.

Applies To:

See Also

Other Resources