May 26, 2015 at 7:43 am
Which tables should I access to list out all the SQL Services on an instance.
LIst all 2008 services as the list below in the URL.
http://blogs.technet.com/b/fort_sql/archive/2010/05/31/list-of-sql-server-service-names.aspx
Thanks
May 26, 2015 at 1:32 pm
Does it have to be through tables? All SQL Server services for a machine are listed in SQL Server Configuration Manager.
You can query sys.dm_server_services, but it will only return information on the SQL Server, agent and full-text daemon services.
MSSQL Tips had a series of articles on alternative ways inside of SQL Server on how to do this.
Checking SQL Services Status - An Evolution Part 1[/url]
SQL Services Status Check - An Evolution Part 2[/url]
SQL Services Status Check - An Evolution Part 3[/url]
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply