1 Version 4.0 -- 1/15/89 sp_serveroption
______________________________________________________________________
NAME: sp_serveroption
FUNCTION:
Displays or changes server options.
SYNTAX:
sp_serveroption [server, optname, {true | false}]
EXAMPLES:
1) sp_serveroption
Displays a list of the server options:
sp_serveroption Version 4.0 -- 1/15/89 2
______________________________________________________________________
Settable server options.
server_option
------------------------
no timeouts
2) sp_serveroption GATEWAY, "no timeouts", true
Tells the server not to time out inactive physical connections
with the remote server GATEWAY.
3)sp_serveroption GATEWAY, "no timeouts", false
Tells the server to use the default timeouts for inactive physi-
cal connections with the remote server GATEWAY.
3 Version 4.0 -- 1/15/89 sp_serveroption
______________________________________________________________________
PARAMETERS:
server - is the name of the server for which you want to set the
option.
optname - is the name of the option you want to set or unset.
Currently there is only one option. The option no timeouts
only makes sense for remote servers. This option means that
the normal timeout code used by the local server is disabled
so the site connection handler will not automatically drop
the physical connection after a minute with no logical con-
nection. SQL Server understands any unique string that is
part of the option name. Use quotes around the option name
if it includes embedded blanks.
{true | false} - true if you want to set the option, false if
you want to unset the option.
COMMENTS:
sp_serveroption Version 4.0 -- 1/15/89 4
______________________________________________________________________
o To display a list of the user-settable server options, execute
sp_serveroption with no parameters.
o Once ``no timeouts'' is set to true, the site handlers will
continue to run until one of the two servers is shut down.
o The no timeouts option only makes sense for remote servers and
is currently the only user-settable server option.
o Only the System Administrator can set or unset particular
server options.
o See System Administration Guide for additional details on
server options.
MESSAGES:
No server with the supplied name exists. Run sp_helpserver to
get a list of servers.
Executing sp_serveroption with no parameters displays a list of
5 Version 4.0 -- 1/15/89 sp_serveroption
______________________________________________________________________
the user-settable options.
Run sp_serveroption with no parameters to see options. This mes-
sage is generated in two cases: either the option doesn't
exist, or the user does not have permission to set or unset
it. Run the procedure with no parameters to display a list
of the user-settable options.
The name supplied as the optname parameter is not unique. No
server option value was changed. The complete names that
match the string supplied are printed out so you can see how
to make the optname more specific.
Although all users can look at a list of the server options, only
the System Administrator can set or unset them. You aren't
the System Administrator.
You have tried to set an option on the local server.
Either the optname parameter was omitted or the optvalue parame-
ter was something other than true or false.
sp_serveroption Version 4.0 -- 1/15/89 6
______________________________________________________________________
PERMISSIONS:
Execute permission for no parameters (display options only) to
public. Execute permission for parameters (change an option) to
System Administrator.
TABLES USED:
master.dbo.spt_values, master.dbo.sysservers
SEE ALSO:
sp_helpserver