In SQL Server Mangement Studio there are some built-in reports, but they do not cover everything…
In SQL Server Mangement Studio there are some built-in reports, but they do not cover everything you might want to know about your server, databases, tables, indexes or statistics. In addition to the built-in reports, I will create some useful custom reports for SQL Server 2012, and my 6:th report is the “Service account” report. This report will show information about :
- When the SQL Server services was started
- Startup type
- State of the service
- The name of the service account
- Name of the cluster node, if the service is clustered
Download SQL Server 2012 Management Studio Report: SQLServiceMonitor_Service_accounts.zip
I will post all my custom reports at this link : www.sqlservice.se/ssms/custom_reports.aspx
If you have any feature requests, feel free to send me a tweet.
Best regards
Håkan Winther
Twitter: @h_winther