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. |
.gif "警告注意事項") 警告 |
|---|
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. |