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

Share
Tweet
Share
Share

About the Author

Previous Post Get a List of CLR’s Registered to a Database Next Post SQL 2012 IIF() Function and CASE Expression
>
The owner of this website has made a commitment to accessibility and inclusion, please report any problems that you encounter using the contact form on this website. This site uses the WP ADA Compliance Check plugin to enhance accessibility.