Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm not talking about "RPC Out". That setting works as I expect it to: when "false", I can't call stored procedures on my linked server. When it's "true", I can.

The specific option I am referring to is in the GUI (SQL Server Management Studio) on the Linked Server Properties window for any linked server (under "Server Options" on the left). Or, you may also set this option by calling sp_serveroption @optname='rpc'.

"RPC" can be set to either true or false. However, I can't find solid documentation on what this actually means in practice. I can't find any situation in my experimentation that behaves differently depending on whether "RPC" is set to true or false.

Can anyone give an example of what behaves differently depending on this setting?

Thanks!

share|improve this question
add comment

1 Answer

One allows A=>B the other allows B=>A. In other words just because server A can call a proc on B doesn't mean B can call a proc on A.

http://msdn.microsoft.com/en-us/library/ms186839.aspx

RPC Enables RPC from the specified server.

RPC Out Enables RPC to the specified server.

share|improve this answer
    
That makes sense in theory, except I couldn't find a scenario experimentally where the RPC setting had any effect. I created a linked server B on server A. However, the RPC setting seems to have no effect on server B calling server A. (That call happens via another linked server A defined on server B.) –  Dan May 17 '11 at 21:43
    
I'm just guessing here but from what you posted... if A is linked to B from A, and B is linked to A from B then the links are going both ways through two different pipes. The settings above likely only apply when A is linked to B on A ONLY. –  RThomas May 18 '11 at 18:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.