CompatibilityLevel Property (Database)

Article
12/15/2008

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

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

Syntaxe

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.

Attention :
SQL Server Management Studio and SQL 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.