Re: Copying Linked Server Config from one server to another

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/25/04

Date: Thu, 25 Mar 2004 07:40:08 -0700

You wouldn't want to copy the system tables to accomplish
There is a script on SQL Server Central that scripts out
remote, linked servers. Check the following on their site:


On Thu, 25 Mar 2004 05:41:06 -0800, Joe
<> wrote:

>Is it advisable to copy the sysservers table and sysoledbusers view from the master DB on one server to master on a 2nd server?
>I have 20 linked servers that I need to add to 2 new servers and I would like to avoid configuring them individually.