O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Image server—The linked server affected by this option.

option_name—The name of the option ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required