Database.CompatibilityLevel Property

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

Database Class
Database Members
Microsoft.SqlServer.Management.Smo Namespace

其他資源

How to: Create, Alter, and Remove a Database in Visual Basic .NET
Creating, Altering, and Removing Databases
CREATE DATABASE (Transact-SQL)