I've writen a stored procedure that is supposed to load 4 tables in a database that are to be used by a vendor to load their tables for an application we purchased from them. being that our data is on multiple servers, the query must read from two servers other than the one in which this db (with the 4 tables) exist.

server 1 - data i'm pulling
server 2 - data i'm pulling
server 3 - contains db with tables that i'm loading

initially i tried running this stored procedure from server 3. but i have a table valued function in the query and i recieved...

"Remote table-valued function calls are not allowed."

the table valued function is on server 1.
after some research, i found where someone had suggested creating a stored procedure on server 3 to call the load procedure from server 1.

when i attempt this i get...

"Server 'Server 1' is not configured for RPC."

I've looked around for the answer to this error and cannot find it anywhere.

any help would be appreciated.

I figured it out. i just put another version of the table valued function onto server 3 so i can just run it from that server.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.