發行項
09/24/2010

CompatibilityLevel 屬性

Gets or sets the compatibility level for the database.

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public Property CompatibilityLevel As CompatibilityLevel
    Get
    Set
'用途
Dim instance As Database
Dim value As CompatibilityLevel

value = instance.CompatibilityLevel

instance.CompatibilityLevel = value

[SfcPropertyAttribute(SfcPropertyFlags.Expensive)]
public CompatibilityLevel CompatibilityLevel { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Expensive)]
public:
virtual property CompatibilityLevel CompatibilityLevel {
    CompatibilityLevel get () sealed;
    void set (CompatibilityLevel value) sealed;
}

[<SfcPropertyAttribute(SfcPropertyFlags.Expensive)>]
abstract CompatibilityLevel : CompatibilityLevel with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.Expensive)>]
override CompatibilityLevel : CompatibilityLevel with get, set

final function get CompatibilityLevel () : CompatibilityLevel
final function set CompatibilityLevel (value : CompatibilityLevel)

屬性值

型別：Microsoft.SqlServer.Management.Smo. . :: . .CompatibilityLevel
A CompatibilityLevel object value that specifies the compatibility level of the database.

實作

IDatabaseOptions. . :: . .CompatibilityLevel

備註

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

[!附註]

SMO does not support compatibility level 60. If you use SMO with a database set to compatibility level 60, some operations will produce errors. Additionally, if the CompatibilityLevel property for the MSDB database is set to Version70, SMO might throw an exception with a COLLATE error.

範例

'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()