question

Anyone else try to query [sys.dm_server_services][1] and get funny results? I actually get 2 rows returned on one of my servers and both rows are for the SQL Server Service. Where it should be row for the SQL Server service and SQL Server Agent. I was going to submit a connect item for it, if other folks are having the same results. I checked Connect and there are [3 submissions][2] that reference this DMV by Aaron Bertrand, but none of them reference not getting Agent Service returned at all. He does have one where he returned 3 rows, 2 being for SQL Agent but that was with SQL Denali CTP3. SELECT servicename, startup_desc, status_desc, last_startup_time FROM sys.dm_server_services [1]: http://msdn.microsoft.com/en-us/library/hh204542.aspx [2]: https://connect.microsoft.com/SQLServer/SearchResults.aspx?SearchQuery=sys.dm_server_services