Compartilhar via


CompatibilityLevel Property (Database)

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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

Sintaxe

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.

Observação sobre cuidadosCuidado

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:

Consulte também

Outros recursos