Prev: Need field uniqueness but don't want index
Next: Varchar to datetime conversion
From: Tom Ashby - Panam Tom Ashby - on 11 Feb 2010 16:34
When configuring a Linked Server the Server Options tab has check boxes for
RPC and RPC OUT. Can someone explain why you would or wouldn't need to
enable either of these options? Thanks!
From: Erland Sommarskog on 11 Feb 2010 17:52
Tom Ashby - Panam (Tom Ashby - Panam(a)discussions.microsoft.com) writes:
> When configuring a Linked Server the Server Options tab has check boxes
> for RPC and RPC OUT. Can someone explain why you would or wouldn't need
> to enable either of these options?

One of them, has no function at all, as far as I know. The other controls
whether you are permitted to make Remote Procedure Calls over the linked
server. That is, call remote stored procedures or EXEC() AT. I don't
remember which is which, but I think RPC OUT is the useful one.

As for why you would not enable a server for RPC. Hm, beats me. Well, some
data sources may not support RPC, but you need to have a server option to
turn somthing off which does not work anyway. But, OK, if you turn off
RPC OUT, you do reduce what is possible to do on the other side. Or at
least make some thing like updating more difficult.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Need field uniqueness but don't want index
Next: Varchar to datetime conversion