Tuesday, March 20, 2012

Copying Linked Server Config from one server to another

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 lik
e to avoid configuring them individually.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/scr...butions/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 th
e 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 av
oid configuring them individually.

No comments:

Post a Comment