Artigo
09/28/2010

Propriedade CompatibilityLevel

Gets or sets the compatibility level for the database.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public Property CompatibilityLevel As CompatibilityLevel
    Get
    Set
'Uso
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)

Valor da propriedade

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

Implementa

IDatabaseOptions. . :: . .CompatibilityLevel

Comentários

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.

Observação
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.

Exemplos

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