show advanced options
Type: Basic
Default value: 0
By default, you do not see the advanced configuration parameters of SQL Server. If you set show advanced options
to 1
, you can see all the SQL Server parameters that can be set by the sp_configure
command.
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.