[Script Of July 24] How to get detailed information of a SQL Server (T-SQL)

  • Article
image image
July
24
 image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com/How-to-get-detailed-ac767add.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This T-SQL script will demo how to get detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

As many people ask how to get general information of SQL Server, this script will demo how to get detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery