declare @vPing varchar(100) ,@desServerName varchar(50) ,@iReturn int set @desServerName='IPAddress/ServerName' create table #Connect(ConnectInfo varchar(200)) set @vPing='ping '+@desServerName+' -a -n 1 -l 1' insert into #Connect(connectInfo) exec @iReturn=master..xp_cmdshell @vPing select *,@iReturn from #Connect delete from #Connect if(@iReturn<>0) begin print 'err: Unknown host '+@desServerName+' and not connecting.' end drop table #Connect
,@desServerName varchar(50)
,@iReturn int set @desServerName='IPAddress/ServerName'
create table #Connect(ConnectInfo varchar(200)) set @vPing='ping '+@desServerName+' -a -n 1 -l 1'
insert into #Connect(connectInfo)
exec @iReturn=master..xp_cmdshell @vPing
select *,@iReturn from #Connect
delete from #Connect
if(@iReturn<>0)
begin
print 'err: Unknown host '+@desServerName+' and not connecting.'
end
drop table #Connect
用主机名不存在这个问题,测试正常。
再次感谢提供帮助的各位朋友。