show advanced options 服务器配置选项show advanced options Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

“显示高级选项”选项用来显示 sp_configure 系统存储过程高级选项。Use the show advanced options option to display the sp_configure system stored procedure advanced options. 当“显示高级选项”设置为 1 时,可以使用 sp_configure 列出高级选项。When you set show advanced options to 1, you can list the advanced options by using sp_configure. 默认值为 0。The default is 0.

该设置将立即生效,无需重新启动服务器。The setting takes effect immediately without a server restart.

另请参阅See Also

RECONFIGURE (Transact-SQL) RECONFIGURE (Transact-SQL)
服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)sp_configure (Transact-SQL)