| Author |
writing table to remote
|
|
| tony-icwgroup 2005-10-28, 8:23 pm |
| I have 3 servers: A,B and C.
On server A I will be executing a procedure that get data from
server B I will then write the result table to server C. All the servers
are linked and I have all security necessary. Can I do that and how?
Thanks for the help.
Tony
| |
| Aleksandar Grbic 2005-10-29, 11:23 am |
| yes
-I-
1. create stored procedure that return rows from server B
2. insert into #t exec sp (create #t before insert)
3. insert into server C select * from #t
-II- (without sp)
1. insert into server c select ... from server b
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"tony-icwgroup" wrote:
> I have 3 servers: A,B and C.
>
> On server A I will be executing a procedure that get data from
> server B I will then write the result table to server C. All the servers
> are linked and I have all security necessary. Can I do that and how?
>
> Thanks for the help.
> Tony
| |
| John Bell 2005-10-29, 8:23 pm |
| Hi
Have you tried using linked servers (See the topic "Configuring Linked
Servers" in books online) and 4 part names (See "Using Identifiers as Object
Names" in Books online) or openquery possibly to call a remote stored
procedure.
John
"tony-icwgroup" < tonyicwgroup@discuss
ions.microsoft.com> wrote in message
news:571EA413-3FB8-40A2-97D8- 300D35E20892@microso
ft.com...
>I have 3 servers: A,B and C.
>
> On server A I will be executing a procedure that get data from
> server B I will then write the result table to server C. All the servers
> are linked and I have all security necessary. Can I do that and how?
>
> Thanks for the help.
> Tony
|
|
|
|