| title | show advanced options Server Configuration Option | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/02/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | high-availability | ||
| ms.reviewer | |||
| ms.suite | sql | ||
| ms.technology | configuration | ||
| ms.tgt_pltfrm | |||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 7572372a-24b6-428f-84ae-48560430b159 | ||
| caps.latest.revision | 22 | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
Use the show advanced options option to display the sp_configure system stored procedure advanced options. When you set show advanced options to 1, you can list the advanced options by using sp_configure. The default is 0.
The setting takes effect immediately without a server restart.
RECONFIGURE (Transact-SQL)
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)