Configuring SQL Server with Stored Procedures
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. 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.
Using SQL Server Management ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
