Stored procedure access remote database

From: Cliff Martin <cliff.martin_at_gmail.com>
Date: 26 Mar 2007 07:44:17 -0700
Message-ID: <1174920257.212475.95640@p15g2000hsd.googlegroups.com>

Hi,

I am trying to write a stored procedure that can access a table on a remote database to insert some data on the calling server.

Stored procedure would reside on Server A, establish some sort of database link to Server B, query the remote table, switch context back to the local server and insert data into a local table.

Is this possible? What should I be searching for to get more information on how to do this?

Any help is appreciated.

Cliff Received on Mon Mar 26 2007 - 09:44:17 CDT