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:
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 ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
