writing table to remote

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

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

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