Database.ServiceBrokerGuid Database.ServiceBrokerGuid Database.ServiceBrokerGuid Property

Definition

Gets the Guid object that uniquely identifies the instance of Service Broker.

public:
 property Guid ServiceBrokerGuid { Guid get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase)]
public Guid ServiceBrokerGuid { get; }
Public ReadOnly Property ServiceBrokerGuid As Guid
Property Value

A Guid object that uniquely identifies Service Broker.

Examples

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

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

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

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

Applies to