use master
EXEC master..xp_cmdshell 'ping 168.0.1.8'
DECLARE @result int
EXEC @result = master..xp_cmdshell 'ping 168.0.1.8' --168.0.1.8
IF (@result = 0)
PRINT 'Success'
ELSE
PRINT 'Failure'
select @result
use master
EXEC master..xp_cmdshell 'ping 168.0.1.8'
DECLARE @result int
EXEC @result = master..xp_cmdshell 'ping 168.0.1.8' --168.0.1.8
IF (@result = 0)
PRINT 'Success'
ELSE
PRINT 'Failure'
select @result