SQL Script to find SQL Service Information
- Kunal Ranpura
- Jul 29, 2019
- 1 min read
-- SQL Server Services information (SQL Server 2008 R2 SP1 or greater)
SELECT servicename, startup_type_desc, status_desc,
last_startup_time, service_account, is_clustered, cluster_nodename
FROM sys.dm_server_services OPTION (RECOMPILE);
Comentários