sys.dm_server_services (Transact-SQL)
Returns information about the SQL Server, Full-Text, and SQL Server Agent services in the current instance of SQL Server. Use this dynamic management view to report status information about these services.
Column name |
Data type |
Description |
||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
servicename |
nvarchar(256) |
Name of the SQL Server, Full-text, or SQL Server Agent service. Cannot be null. |
||||||||||||||||
startup_type |
int |
Indicates the start mode of the service.
Is nullable. |
||||||||||||||||
startup_desc |
nvarchar(256) |
Describes the start mode of the service.
Cannot be null. |
||||||||||||||||
status |
int |
Indicates the current status of the service.
Is nullable. |
||||||||||||||||
status_desc |
nvarchar(256) |
Describes the current status of the service.
Cannot be null. |
||||||||||||||||
process_id |
int |
The process ID of the service. Cannot be null. |
||||||||||||||||
last_startup_time |
datetimeoffset(7) |
The date and time the service was last started. Is nullable. |
||||||||||||||||
service_account |
nvarchar(256) |
The account authorized to control the service. This account can start or stop the service, or modify service properties. Cannot be null. |
||||||||||||||||
filename |
nvarchar(256) |
The path and filename of the service executable. Cannot be null. |
||||||||||||||||
is_clustered |
nvarchar(1) |
Indicates whether the service is installed as a resource of a clustered server. Cannot be null. |
||||||||||||||||
cluster_nodename |
nvarchar(256) |
The name of the cluster node on which the service is installed. Is nullable. |
Security
Permissions
Requires VIEW SERVER STATE permission on the server.