Microsoft® SQL Server 2012 Unleashed

sp_serveroption

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:

Click here to view code image

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 ...