Database.CompatibilityLevel Property

2008-12-15

Gets or sets the compatibility level for the database.

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Property CompatibilityLevel As CompatibilityLevel

public CompatibilityLevel CompatibilityLevel { get; set; }

public:
property CompatibilityLevel CompatibilityLevel {
    CompatibilityLevel get ();
    void set (CompatibilityLevel value);
}

/** @property */
public CompatibilityLevel get_CompatibilityLevel ()

/** @property */
public void set_CompatibilityLevel (CompatibilityLevel value)

public function get CompatibilityLevel () : CompatibilityLevel

public function set CompatibilityLevel (value : CompatibilityLevel)

属性值

A CompatibilityLevel object value that specifies the compatibility level of the database.

备注

已更新的文本：2006 年 7 月 17 日

This property specifies an earlier version of Microsoft SQL Server for which certain database actions are to be compatible. This property works just like the sp_dbcmptlevel system stored procedure.

注意：
SQL Server Management Objects (SMO) does not support compatibility level 60. If you use SMO with a database set to compatibility level 60, some operations will produce errors.

注意：
If the CompatibilityLevel property for the MSDB database is set to Version70 SMO may throw an exception with a COLLATE error.

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

'Get the current compatibility level.
Dim cl As CompatibilityLevel
cl = db.CompatibilityLevel

'Display the compatibility level of the database.
Console.WriteLine("Compatibility level = " + cl.ToString)

'Set the compatibility level to a different value.
db.CompatibilityLevel = CompatibilityLevel.Version80
db.Alter()

'Restore the compatibility level to original value.
db.CompatibilityLevel = cl
db.Alter()

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.