When setting up a linked server in SQL Server (we're on 2005), you can set two server options:
- Rpc Out
Looking at the MSDN article, all it states is:
RPC - Enables RPC from the specified server.
RPC Out - Enables RPC to the specified server.
My question is, why would I need to set these options? What can I do / not do by enabling Rpc on a linked server? Does setting these options to true have any drawbacks?
But to execute the remote stored procedure, you'd need the "RPC Out" setting enabled. When would you ever need the "RPC" setting enabled?