sys.services (Transact-SQL)

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

Column name

Data type

Description

name

sysname

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

service_id

int

Identifier of the service. Not NULLABLE.

principal_id

int

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

service_queue_id

int

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

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Concepts