using Linked servergreenspun.com : LUSENET : SQL Server Database Administration : One Thread
how to use linked server in dial up?performance wise is it good?is it reliable?
-- Anonymous, January 29, 2005
It seems that you can refer to a linked server by IP Address. You will need to modify your sql server's host file by setting a static hostname for that IP address and use that in setting up your linked server. For this you can use an alias created with the client network utility (clinconfg.exe). Using this tool you alias the "name" to an IP address.
I'm sure that there will be performance and reliability issues with this type of connection. I wouldn't recommend it if you have an alternative.
-- Anonymous, February 07, 2005