The syntax for this stored procedure is sp_serveroption [servername.option,{true¦false}] sp_serveroption SQL,DIST,TRUE GO