CompatibilityLevel Property (Database)

發行項
12/15/2008

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

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

語法

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.

注意：
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.