You can configure linked servers by using
sp_serveroption. This affects how distributed queries behave at the linked server provider level. In other words, the options you set with the
sp_serveroption procedure are for a particular linked server entry only. Only users with the sysadmin or setupadmin fixed server roles can run this procedure, which has the following syntax:
sp_serveroption [[@server =] 'server'] [,[@optname =] 'option_name'] [,[@optvalue =] 'option_value']
The elements of the syntax are as follows:
server—The linked server affected by this option.
option_name—The name of the option ...