Anyone else try to query sys.dm_server_services 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] 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.
asked Sep 19 '11 at 07:01 AM in Default