contract key icon Contract: http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic

Properties

Property Value
Name http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
ID 5
Owner dbo
System Object true

Extended Properties

No extended properties defined.

Messages Mappings

Message name Message owner name Is sent by initiator Is sent by target
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description dbo false true
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query dbo true false
http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status dbo false true

Permissions

No object level permissions defined.

SQL

Script
CREATE CONTRACT [http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic] AUTHORIZATION [dbo] ([http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description] SENT BY TARGET, [http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query] SENT BY INITIATOR, [http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status] SENT BY TARGET)

See also

List of Contracts