MS SQL Basics Tutorial: SQL Server Configuration

Configuring the properties of a server is important for managing SQL Server. You can configure them in two ways.

1, with Enterprise Manager configuration

When you right-click in Enterprise Manager and select the Properties option from the shortcut menu, the dialog box shown in Figure 5-13 appears, which allows you to set the server's properties.

2, with the Control Panel configuration

The services shortcut under Administrative Tools (Administrative Tools) can be selected from Control Panel in Win2000 and Windows NT (server Management Services in the Win2000 Professional operating system) option), the page appears as shown in Figure 5-3. Right-click the name of the service you want to set and select the Properties option from the shortcut menu to start the dialog shown in Figure 5-14, which can be categorized for configuration.

See the full set of "MS SQL Basics Tutorials"