One of the cool features that’s got introduced from SQL 2008 R2 is ability of getting the running status of various SQL Server services like SQL Server, Full-Text, and SQL Server Agent by means of T-SQL query. This is made possible…
Category: sys.dm_server_services
