Code to list all settings of a server

exec master..xp_cmdshell '"c:\Program Files\Microsoft SQL Server\MSSQL$SERVER1SQL02\Binn\sqldiag.exe" -I 131.97.101.87,1621 -O c:\test3.txt –E -C-U sa -P yuqiong'


This gives you a lot of information about the servern and the database. There will be a report on c:\test3.txt.

Its good to have when you speak to Microsoft regarding any problem about the server n different versions of files, settings etc.