using Linked server

greenspun.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

Answers

Sanoop,

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.

Good Luck,

Eric

-- Anonymous, February 07, 2005


Moderation questions? read the FAQ