What is sp_configure commands and set commands? | SansSQL

Thursday, June 12, 2008

What is sp_configure commands and set commands?

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.

Ads