Partager via

  • Article

CompatibilityLevel propriété

Gets or sets the compatibility level for the database.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (dans Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public Property CompatibilityLevel As CompatibilityLevel
    Get
    Set
'Utilisation
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)

Valeur de la propriété

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

Implémente

IDatabaseOptions. . :: . .CompatibilityLevel

Notes

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.

[!REMARQUE]

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.

Exemples

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