Enabling and disabling SQL Server features can be configured using facets in SQL Server Management Studio.
To configure surface area using facets
In Management Studio connect to a component of SQL Server.
In Object Explorer, right-click the server, and then click Facets.
In the View Facets dialog box, expand the Facet list, and select the appropriate Surface Area Configuration facet (Surface Area Configuration, Surface Area Configuration for Analysis Services, or Surface Area Configuration for Reporting Services).
In the Facet properties area, select the values that you want for each property.
Click OK.
To periodically check the configuration of a facet, use Policy-Based Management. For more information about Policy-Based Management, see
Administer Servers by Using Policy-Based Management.
You can also set Database Engine options using the sp_configure stored procedure. For more information, see
Server Configuration Options (SQL Server).
Partager