Display all Server Information by using TSQL script

The below listed all SQL Server Information can be retrieved by a TSQL script. But before that, we need to Enable xp_cmdshell with sp_configure.

Turns on advanced options and enable configure xp_cmdshell using below TSQL query.

Simply run the below script and get the information.

Download Server Information

Output

Source: https://sqlmentalist.com


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *