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