SQL Server/T-SQL Tutorial/System Functions/sp serveroption

sp_serveroption configures the type of SQL Server.

   <source lang="sql">

The syntax for this stored procedure is sp_serveroption [servername.option,{true�false}]

sp_serveroption SQL,DIST,TRUE GO</source>