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


Source: https://sqlmentalist.com

Facebook Comments Box


Leave a Reply

Your email address will not be published.