CompatibilityLevel Property (Database)

2008-12-15

后续版本的 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.