if your other SQL server has a dynamic IP, and you need a real hostname for it, look at the free services at dyndns.org.
you run a service on your remote server, and any time it's extranl ip changes, due to dialup, or DSL or CABLE changes, it updates the ip to the hostname;
for example, you might get a free account for the hostname PhillipCoxSQLServer.dydns.org
and the service just updates DYNDNS.ORG whenever the ip changes; that way your static IP server can always find PhillipCoxSQLServer.dydns.org
I use it all the time.
if the server is INTERNAL on your LAN, you do not need this service.
you can pay extra for your own domain name, and you can try it for free as explained above.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!