SQL SERVER: Test connectivity to server from sql server

TestSQLServerConnectivity.ps1

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;

/************************************************************
** Change the value of the @server variable here
*************************************************************/
DECLARE @Server VARCHAR(255) = 'servername'

DECLARE @nslookup VARCHAR(500) = CONCAT('nslookup ', @Server),
	@ping VARCHAR(500) = CONCAT('ping ', @Server),
	@PSScript VARCHAR(8000) = CONCAT('powershell.exe -Command "try { Test-Connection -ComputerName \"', @Server, '\" -Count 2 } catch { Write-Host \"Error: $($_.Exception.Message)\" }"')

SELECT @nslookup AS [Command]
EXEC [sys].[xp_cmdshell] @nslookup

SELECT @ping AS [Command]
EXEC [sys].[xp_cmdshell] @ping

SELECT @PSScript AS [Command]
EXEC [sys].[xp_cmdshell] @PSScript

EXEC sp_configure 'xp_cmdshell', 0;
RECONFIGURE;
EXEC sp_configure 'show advanced options', 0;
RECONFIGURE;