Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Database.ServiceBrokerGuid Property

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

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public Guid ServiceBrokerGuid { get; }

Property Value

Type: Guid
A Guid object that uniquely identifies Service Broker.

'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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft