Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.