Using SQL Server

Using SQL Server In this section, you'll explore some of the tools you use to manage SQL Server. Specifically, you'll learn how to start and stop SQL Server | Using SQL Server In this section you ll explore some of the tools you use to manage SQL Server. Specifically you ll learn how to start and stop SQL Server using the Service Manager and use the Enterprise Manager to administer SQL Server. Starting and Stopping SQL Server To start and stop SQL Server you use the Service Manager tool. To open the Service Manager you select Start Programs Microsoft SQL Server Service Manager. The Service Manager is shown in Figure . Figure The Service Manager You select the name of the server computer on which SQL Server is running in the Server drop-down list box. To start SQL Server you click the Start Continue button. To stop SQL Server you click the Stop button. You can also use the Service Manager to pause SQL Server and select whether you want to automatically start SQL Server when the operating system OS starts. Once you ve started SQL Server other programs can access the databases managed by that SQL Server installation. Using Enterprise Manager To administer a database you use the Enterprise Manager tool. You can create databases create and edit tables create and edit users and so on using Enterprise Manager. To open the Enterprise Manager you select Start Programs Microsoft SQL Server Enterprise Manager. The Enterprise Manager is shown in Figure . Figure The Enterprise Manager On the left pane of Enterprise Manager you ll see a tree that shows the accessible SQL Server installations. The contents of the right pane of Enterprise Manager display different information based on what you select in the left pane. For example I selected the Databases folder and the North-wind database in the left pane when preparing Figure . As you can see the right pane displays icons that allow you to edit the items stored in that database. Each SQL Server installation contains the following seven folders shown in the left pane Databases Contains tools that allow you to access the databases managed by SQL Server. Data .