Answer: sp_config is a system stored procedure which is used to displays or changes global configuration settings for the current server.
Syntax:
sp_configure [ [ @configname = ] 'option_name'
[ , [ @configvalue = ] 'value' ] ]
Example:
--change configuration option 0 to 1
EXEC sp_configure 'show advanced option', '1';
Asked In: Many Interviews |
Alert Moderator