OK, so I am trying to figure out what the purpose of the RPC option for sp_serveroption is for.
I understand what RPC is, but I have a deeper question.
When sp_serveroption rpc is set to false, I can still add a linked server, turn it on there (in the linked server properties) and get it to work.
Why is that?
1.) How can I disable RPC in such a way that a server does not allow it even when added as a linked server?
2.) Why can RPC be disabled at the sp_serveroption level and still work through the linked server properties?
3.) What is the best way to tell if RPC is enabled at the server level, and ensure it's disabled?
Any help is appreciated.