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

sp_serveroption configures the type of SQL Server.

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

sp_serveroption SQL,DIST,TRUE   
GO