What are sp_configure commands and set commands?

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

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