sp_serveroption configures the type of SQL Server. : sp_serveroption « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_serveroption
The syntax for this stored procedure is sp_serveroption [servername.option,{truefalse}]    


sp_serveroption SQL,DIST,TRUE   
GO








25.55.sp_serveroption
25.55.1.sp_serveroption configures the type of SQL Server.