Compartir a través de

  • Artículo

DatabaseGuid Propiedad

Obtiene el valor Guid que identifica de forma única la base de datos.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property DatabaseGuid As Guid
    Get
'Uso
Dim instance As Database
Dim value As Guid

value = instance.DatabaseGuid

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public Guid DatabaseGuid { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property Guid DatabaseGuid {
    Guid get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DatabaseGuid : Guid

function get DatabaseGuid () : Guid

Valor de la propiedad

Tipo: System. . :: . .Guid
Valor del objeto del sistema Guid que identifica de forma única la base de datos.

Ejemplos

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")

'Display the database GUIDs.
Console.WriteLine("Database GUID is " + _
db.DatabaseGuid.ToString)
Console.WriteLine("Service Broker GUID is " + _
db.ServiceBrokerGuid.ToString)
Console.WriteLine("Recovery Fork GUID is " + _
db.RecoveryForkGuid.ToString)

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

Write-Host "Database GUID is" $db.DatabaseGuid
Write-Host "Service Broker GUID is" $db.ServiceBrokerGuid
Write-Host "Recovery Fork GUID is" $db.RecoveryForkGuid