You can configure many areas of SQL Server using the SQL Server Properties dialog box, which will be discussed in Chapter 5. As you have learned in this chapter, you can also configure SQL Server with stored procedures, such as sp_configure and sp_dboption. You execute stored procedures and other queries in SQL Server Management Studio. SQL Server Management Studio has a built-in client tool that sends commands to a SQL Server instance, which in turn parses, compiles, and executes the commands.
The following sections explain how to configure SQL Server using SQL Server Management Studio and stored procedures. You will find more detailed coverage of SQL Server Management Studio in other chapters.