[Script of Apr. 21] How to get information of SQL Server and databases (SQL)

  • Article

Script Download:  

The script is available for download in Microsoft Script Browser for Windows PowerShell ISE.You need to install the Script Browser application first, and search for the script sample title.

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

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

image image
image

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