call a remote procedure

how can i call a remote procedure

with out using linked server

can i use open rowset or something

I need to return a temp table

have you tried creating a connection string to this server?

If not then have a look at the following thread, it has your scenario http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=974075&SiteID=1|||

hi barry,

I have an SP and i need this SP to call another SP

in one of my remote Sql server. I'm caaling the remote Sp

with my local Sp

thanks,

joey

|||Have you tried using a Full Qualified Name?

[servername\instancename].database.owner.object|||

those are used in conjuction of a linked server

i'm thinking of opendatasource or openrowset

|||

Joey:

Would it be acceptable to implment this with a "linked server" but without full linked server capability -- similar to the "remote server" of old SQL 7? You could do this by only allowing the "RPC" feature and NOT allowing the "Data" feature available from "linked server". I realize this is a compromise to your request but this might be a good option in this case. Then you could execute the procedures as described by Barry.

Dave