Version propriété
Gets the version of the instance of SQL Server that was used to create 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 ReadOnly Property Version As Integer
Get
'Utilisation
Dim instance As Database
Dim value As Integer
value = instance.Version
[SfcPropertyAttribute(SfcPropertyFlags.Expensive)]
public int Version { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Expensive)]
public:
property int Version {
int get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Expensive)>]
member Version : int
function get Version () : int
Valeur de la propriété
Type : System. . :: . .Int32
An Int32 value that specifies version of the instance of SQL Server that was used to create the database.
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")
'Display information about the database.
Console.WriteLine("Is Database snapshot : " + _
db.IsDatabaseSnapshot.ToString)
Console.WriteLine("Is Database snapshot base : " + _
db.IsDatabaseSnapshotBase.ToString)
Console.WriteLine("User is Aministrator : " + _
db.IsDbAccessAdmin.ToString)
Console.WriteLine("User is backup operator : " + _
db.IsDbBackupOperator.ToString)
Console.WriteLine("User is data reader : " + _
db.IsDbDatareader.ToString)
Console.WriteLine("User is data writer : " + _
db.IsDbDatawriter.ToString)
Console.WriteLine("User is DDL administrator : " + _
db.IsDbDdlAdmin.ToString)
Console.WriteLine("User denied data reader : " + _
db.IsDbDenyDatareader.ToString)
Console.WriteLine("User denied data writer : " + _
db.IsDbDenyDatawriter.ToString)
Console.WriteLine("User is database owner : " + _
db.IsDbOwner.ToString)
Console.WriteLine("User security administrator : " + _
db.IsDbSecurityAdmin.ToString)
Console.WriteLine("Full text is enabled : " + _
db.IsFullTextEnabled.ToString)
Console.WriteLine("Database is a mail host : " + _
db.IsMailHost.ToString)
Console.WriteLine("Mirroring is enabled : " + _
db.IsMirroringEnabled.ToString)
Console.WriteLine("Database is a system object : " + _
db.IsSystemObject.ToString)
Console.WriteLine("Database is updateable : " + _
db.IsUpdateable.ToString)