sp_serveroption (version 6.5)

Sets server options. You can set the server as a DSN server.

For additional syntax information for sp_serveroption, see the Microsoft SQL Server Transact-SQL Reference.

Syntax

sp_serveroption [server_name, optname, {true | false}]

where

optname

Is the type of server. Can be one of these:

dist	Distribution server
dpub	Remote publisher to this distribution server
dsn	DSN server
fallback	Fallback server
pub	Publication server
rpc	Remote server
sub	Subscription server

The default is rpc.

true | false

Specifies whether to set the option. Choose true to set the option; choose false to turn it off.

Remarks

The DSN is the ODBC data source name for the server. A DSN is a server that receives replication data through ODBC. This DSN can be accessed only through Microsoft SQL Server because replication is being used.

Example

This example identifies the ACCOUNTS server as a DSN server.

sp_serveroption ACCOUNTS, dsn, true
  

Permission

Only the system administrator can use this procedure to set server options.