• 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"