Try the new Dynamic Management View

By SQLRx Admin | SQL Administration

Jan 10

Image(SQL
2008 R2 and SQL 2012) Use the new dynamic management view sys.dm_server_services
to see information about SQL Server services such as when service last started,
running status, service account, etc… For more information, check out Books
Online or http://msdn.microsoft.com/en-us/library/hh204542.aspx

About the Author

>