title: how to get sql server service information using tsql
body: <p>In SQL Server 2008 R2 SP1, we have a new dmv - <code>sys.dm_server_services</code> which is great for grabbing SQL Server services related info easily.</p>
  
  <p>Is there any similar sys view/catalog or a tsql hack that I can query easily for earlier version of SQL Server, like SQL Server 2005 or SQL Server 2008?</p>
  
  <p>Thanks a bunch!</p>