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
this.
There is a script on SQL Server Central that scripts out
remote, linked servers. Check the following on their site:
http://www.sqlservercentral.com/scripts/contributions/620.asp

-Sue

On Thu, 25 Mar 2004 05:41:06 -0800, Joe
<anonymous@discussions.microsoft.com> 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.