The CompatibilityLevel property controls Microsoft® SQL Server™ behavior, setting behavior to match either the current or earlier version.
object.CompatibilityLevel [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying a SQL Server version as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOCompLevel_60 | 60 | Version 6.0 |
| SQLDMOCompLevel_65 | 65 | Version 6.5 |
| SQLDMOCompLevel_70 | 70 | Default (version 7.0) |
| SQLDMOCompLevel_Unknown | 0 | Unknown |
Long, enumerated.
Read/write
HRESULT GetCompatibilityLevel(
SQLDMO_COMP_LEVEL_TYPE* pRetVal);
HRESULT SetCompatibilityLevel(
SQLDMO_COMP_LEVEL_TYPE NewValue);