| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.services (Transact-SQL) |
sys.services (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.