Setting Configuration Options with SQL Enterprise Manager

As mentioned previously, you can set SQL Server configuration options by using SQL Server Enterprise Manager. Simply invoke Enterprise Manager from the Microsoft SQL Server program group and right-click on the Server folder. Figure 40.4 shows the SQL Server Properties (Configure) dialog box and the different tabs available. Don't be misled: Some of these tab options are not configuration options that correspond to sp_configure, such as the Security tab and some functions under the Database tab. However, as you will see, Microsoft has done a nice job of organizing and presenting the option information. You will also see that several of the configuration options cannot be managed from this ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.