Check for existence of another server

[jazerr]

I am performing a bind to another server inside a Stored Proc. This works well. But I need to make sure that I add a check to find out if the server I am trying to bind to actually exists.

Does anybody know of a way, in a Stored Proc to check the existence of a server that I wish to bind to?

 

[johnherman]

You might try using a "ping", capturing the results and parsing them to determine if the ping succeeded.

Good Luck.

Sometimes the grass is greener on the other side because there is more manure there - original.