Page 44 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Sartaj Singh, Lovely Professional University

Notes Unit 3: SQL Server Tools

CONTENTS
Objectives
Introduction
3.1 Management Studio

3.1.1 To Open SQL Server Management Studio
3.1.2 Management Studio Components
3.1.3 Showing Additional Windows

3.2 Log File Viewer
3.2.1 Opening Log File Viewer
3.2.2 Permissions
3.3 Summary
3.4 Keywords

3.5 Review Questions
3.6 Further Readings

Objectives

After studying this unit, you will be able to:

Learn about SQL server tools
Understand the meaning and usage of management studio
Know about various components of management studio
Discuss the concept of Log File Viewer
Comprehend how Log File Viewer can be used to view various types of information
Introduction

Microsoft SQL Server includes a complete set of graphical tools and command line utilities that
allow users, programmers, and administrators to increase their productivity. This unit will help
you learn to get the most out of SQL Server tools so you can work efficiently, right from the start.

3.1 Management Studio

Management Studio is a new tool for SQL Server database administrators and developers.
Hosted inside Microsoft Visual Studio, it brings graphical tools for database management together
with a rich development environment. Management Studio includes the functions of SQL Server
2000 Enterprise Manager, Analysis Manager, and SQL Query Analyzer in one tool, along with
the ability to write MDX, XMLA, and XML statements.
This unit will help you understand the presentation of information in Management Studio and
how to take advantage of the features that were not available in Enterprise Manager.

38 LOVELY PROFESSIONAL UNIVERSITY