아티클
04/01/2012

CompatibilityLevel Property (Database)

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 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

다음을 통해 공유