Advertisement

Find Server Information by TSQL script

Share the blog:

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.

Advertisement

Simply run the below script and get the information.

Download Server Information

Output

Source: https://sqlmentalist.com

Facebook Comments Box
Share the blog:

Comments

Leave a Reply

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

Advertisement