Try the new Dynamic Management View

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

Both comments and trackbacks are currently closed.
%d bloggers like this: