Database.ServiceBroker Database.ServiceBroker Database.ServiceBroker Property

정의

가져옵니다는 ServiceBroker Service Broker를 나타내는 개체입니다. Gets the ServiceBroker object that represents the Service Broker.

public:
 property Microsoft::SqlServer::Management::Smo::Broker::ServiceBroker ^ ServiceBroker { Microsoft::SqlServer::Management::Smo::Broker::ServiceBroker ^ get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObject(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObjectRelationship.Object, Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObjectCardinality.One)]
public Microsoft.SqlServer.Management.Smo.Broker.ServiceBroker ServiceBroker { get; }
Public ReadOnly Property ServiceBroker As ServiceBroker
속성 값

A ServiceBroker Service Broker를 나타내는 개체입니다. A ServiceBroker object that represents the Service Broker.

예제

VBVB

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

PowerShellPowerShell

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

Write-Host "Is database snapshot :" $db.IsDatabaseShapshot  
Write-Host "Is database snapshot base :" $db.IsDatabaseShapshotBase  
Write-Host "User is Administrator :" $db.IsDbAccessAdmin  
Write-Host "User is backup operator :" $db.IsDbBackupOperator  
Write-Host "User is data rader :" $db.IsDbDataReader  
Write-Host "User is data writer :" $db.IsDbDataWriter  
Write-Host "User is DDL administrator :" $db.IsDbDdlAdmin  
Write-Host "User denied data reader :" $db.IsDbDenyDatareader  
Write-Host "User denied data writer :" $db.IsDbDenyDatawriter  
Write-Host "User dis database owner :" $db.IsDbOwner  
Write-Host "User security administrator :" $db.IsDbSecurityAdmin  
Write-Host "Full text is enabled :" $db.FullTextEnabled  
Write-Host "Database is a mail host :" $db.IsMailHost  
Write-Host "Mirroring is enabled :" $db.IsMirroringEnabled  
Write-Host "Database is a system object :" $db.IsSystemObject  
Write-Host "Database is updateable :" $db.IsUpdateable  

설명

Service Broker와 연결된 모든 개체는 ServiceBroker 개체 계층에 있습니다.All the objects associated with the Service Broker are found in the ServiceBroker object hierarchy. ServiceBroker 속성을 사용하여 모든 Service Broker 개체에 액세스할 수 있습니다.All Service Broker objects can be accessed by using the ServiceBroker property.

적용 대상