CompatibilityLevel Property (Database)
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The CompatibilityLevel property controls the behavior of an instance of Microsoft SQL Server, setting behavior to match a specified version of Microsoft SQL Server.
Sintassi
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. |