What is sp_config command?

 Posted by Rajni.Shekhar on 4/19/2012 | Category: Sql Server Interview questions | Views: 2554 | Points: 40
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 

Comments or Responses

Login to post response