top of page

SQL Script to find SQL Service Information

Writer: Kunal RanpuraKunal Ranpura

-- 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);

Recent Posts

See All

SQL Server Profiler Trace

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

Find All Primary Key in SQL Server

select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...

Comments


bottom of page