Compartir a través de

  • Artículo

CompatibilityLevel Property (Database)

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

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

Sintaxis

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.
Nota de advertenciaAdvertencia

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:

Database Object

Vea también

Otros recursos

Backward Compatibility