What are sp_configure commands and set commands?

 Posted by Blessybaby on 1/6/2010 | Category: Sql Server Interview questions | Views: 3673

Use sp_configure to display or change server-level settings. To change database-level settings, use ALTER DATABASE. To change settings that affect only the current user session, use the SET statement.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response