CompatibilityLevel Property (Database)
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The CompatibilityLevel property controls the behavior of an instance of Microsoft SQL Server, setting behavior to match a specified version of Microsoft SQL Server.
Syntax
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 "Vorsichtshinweis") Vorsicht |
|---|
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. |