Sql90ServiceBrokerOption Enumeration
Possible service broker options for the database.
Namespace: Microsoft.Data.Schema.Sql.SchemaModel
Assembly: Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
Syntax
'Declaration
Public Enumeration Sql90ServiceBrokerOption
public enum Sql90ServiceBrokerOption
public enum class Sql90ServiceBrokerOption
type Sql90ServiceBrokerOption
public enum Sql90ServiceBrokerOption
Members
| Member name | Description | |
|---|---|---|
| Unknown | Specifies that the service broker option is unknown. | |
| EnableBroker | Specifies that service broker is enabled for the specified database. | |
| DisableBroker | Specifies that service broker is disabled for the specified database. | |
| NewBroker | Creates a new service_broker_guid value in both sys.databases and the restored database and ends all conversation endpoints with cleanup. The broker is enabled, but no message is sent to the remote conversation endpoints. | |
| ErrorBrokerConversations | Ends all conversations with an error that states that the database is attached or restored. The broker is disabled until this operation is completed and then the broker is enabled. |