Export (0) Print
Expand All
Expand Minimize
13 out of 27 rated this helpful - Rate this topic

show advanced options Server Configuration Option

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.