Class ServiceBrokerSchema.Service

sys.services (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

This catalog view contains a row for each service in the database.

[Table(Schema = "sys", Name = "services", IsView = true)]
public class ServiceBrokerSchema.Service

Properties

Case-sensitive name of service, unique within the database. Not NULLABLE.

[Column("name")]
[NotNull]
public string Name { get; set; }

Identifier for the database principal that owns this service. NULLABLE.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Identifier of the service. Not NULLABLE.

[Column("service_id")]
[NotNull]
public int ServiceID { get; set; }

Object id for the queue that this service uses. Not NULLABLE.

[Column("service_queue_id")]
[NotNull]
public int ServiceQueueID { get; set; }