For SQL Server 6.5 information, see sp_serveroption in What's New for SQL Server 6.5.
Sets server options.
sp_serveroption [server_name, optname, {true | false}]
where
dist | Distribution server |
dpub | Combination publisher/subscriber |
pub | Publication server |
rpc | Remote server |
sub | Subscription server |
The default is rpc.
To display a list of the server options, execute sp_serveroption with no parameters.
This example lists the server options.
sp_serveroption go Settable server options. server_option -------------------------------- dist dpub pub rpc sub
This example sets the server as a combination publisher/subscriber server.
sp_serveroption ACCOUNTS, dpub, TRUE
Only the system administrator can use sp_serveroption to set server options.
master.dbo.sp_values, master.dbo.sysserver
sp_addpublisher | sp_helpserver |
sp_droppublisher. |