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:
The elements of the syntax are as follows:
• server
—The linked server affected by this option.
• option_name
—The name of the option to be configured. The valid option names follow:
• option_value
—The value of this option. Valid values are TRUE
(or ON
) and ...
Get Microsoft® SQL Server 2008 R2 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.