Re: Copying Linked Server Config from one server to another
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/25/04
- Next message: Adam Machanic: "Re: The name 'guest' was not found in the Users collection"
- Previous message: Sue Hoegemeier: "Re: Generate SQL Script for Stored Procedures"
- In reply to: Joe: "Copying Linked Server Config from one server to another"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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.
- Next message: Adam Machanic: "Re: The name 'guest' was not found in the Users collection"
- Previous message: Sue Hoegemeier: "Re: Generate SQL Script for Stored Procedures"
- In reply to: Joe: "Copying Linked Server Config from one server to another"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
