Using SQL Server

Using SQL Server In this section, youll explore some of the tools you use to manage SQL Server. Specifically, youll learn how to start and stop SQL Server
Nội dung trích xuất từ tài liệu:
Using SQL Server Using SQL ServerIn this section, youll explore some of the tools you use to manage SQL Server.Specifically, youll learn how to start and stop SQL Server using the Service Manager anduse the Enterprise Manager to administer SQL Server.Starting and Stopping SQL ServerTo start and stop SQL Server, you use the Service Manager tool. To open the ServiceManager, you select Start ➣ Programs ➣ Microsoft SQL Server ➣ Service Manager.The Service Manager is shown in Figure 2.1.Figure 2.1: The Service ManagerYou select the name of the server computer on which SQL Server is running in the Serverdrop-down list box. To start SQL Server, you click the Start/Continue button. To stopSQL Server, you click the Stop button. You can also use the Service Manager to pauseSQL Server, and select whether you want to automatically start SQL Server when theoperating system (OS) starts.Once youve started SQL Server, other programs can access the databases managed bythat SQL Server installation.Using Enterprise ManagerTo 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. Toopen the Enterprise Manager, you select Start ➣ Programs ➣ Microsoft SQL Server ➣Enterprise Manager. The Enterprise Manager is shown in Figure 2.2.Figure 2.2: The Enterprise ManagerOn the left pane of Enterprise Manager, youll see a tree that shows the accessible SQLServer installations. The contents of the right pane of Enterprise Manager displaydifferent information based on what you select in the left pane. For example, I selectedthe Databases folder and the North-wind database in the left pane when preparing Figure2.2. As you can see, the right pane displays icons that allow you to edit the items storedin 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 Transformation Services Provides access to tools that allow you to move data from one database to another. You can also programmatically modify the data as it is moved. For example, you might want to move data from SQL Server database to an Oracle database, or vice versa. • Management Contains tools that allow you to back up your databases, monitor current database activity, and other tasks. • Replication Provides access tools that allow you to copy information from one database to another in near real time using a process known as replication. For example, you might want to move data from a database running at a branch office of a company to a database at headquarters. • Security Contains tools that allow you to manage logins and built-in roles that contain permissions. You can also manage linked servers and remote servers. Linked servers are databases that you can access over a network. These databases dont have to be SQL Server databases; they could also be Oracle databases, for example. The only limitation is that there must be an OLE DB (Object Linking and Embedding for Databases) provider for that database. Remote servers are SQL Server databases that you can access over a network and run stored procedures on. • Support Services Provides access to tools that allow you to manage the Distributed Transaction Coordinator, Full-Text Search, and SQL Mail services. The Distributed Transaction Coordinator service allows you to manage transactions that use more than one database. The Full Text Search service allows you to perform searches for phrases through large amounts of text. The SQL Mail service allows you to send electronic mail from SQL Server. • Meta Data Services Contains tools that allow you to manage the information stored in the local repository. This information contains details about databases, users, tables, columns, views, stored procedures, and so on. This information is primarily used by data-warehousing applications.Note Since this is a book on database programming, I wont cover too many details on database administration; Ill just focus on the Databases folder. Typically, your organization will have a database administrator, or DBA, who takes care of administering your databases and will use the other folders to perform their tasks. If you need more details on administering SQL Server, I recommend the book Mastering SQL Server 2000 by Mike Gunderloy and Joseph L. Jorden (Sybex, 2000).Lets take a closer look at the Databases folder, which contains the databases that aremanaged by a particular SQL Server installation. For example, my SQL Serverinstallation manages six databases named master, model, msdb, Northwi ...