Hi,

Can anyone help me on how to transfer a linked server
from one sql server (remote server) to another sql server
(local server) ?

Regards,
Anand

You should be able to build up the adding of a linked server statement using
data from the sysservers table. You can then output the results to a text
file

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Anand" <anonymous (AT) discussions (DOT) microsoft.com> wrote