Though there is an option in Windows to get SQL Server services information by typing Services.msc in Start - > Search Programs
From SQL Server 2008R2, DMV is available to get SQL Server services information.
sys.dm_server_services - Returns information about the SQL Server, Full-Text, and SQL Server Agent services in the current instance of SQL Server.
From SQL Server 2008R2, DMV is available to get SQL Server services information.
sys.dm_server_services - Returns information about the SQL Server, Full-Text, and SQL Server Agent services in the current instance of SQL Server.
No comments:
Post a Comment