Page 48 - DCAP508_DATABASE_ADMINISTRATION
P. 48

Database Administration




                    Notes          3.2.2 Permissions

                                   Requires membership in the securityadmin fixed server role.

                                   Self Assessment

                                   State true or false:
                                   8.  You cannot open Log File Viewer in several ways, depending on the information that you
                                       want to view.
                                   9.  Log File Viewer in SQL Server Management Studio is used to access information about
                                       errors and events.

                                   10.  Remote Maintenance Plans are Windows events that can also be accessed from Event
                                       Viewer apart from Log File Viewer.

                                   3.3 Summary


                                       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.

                                       Management Studio presents information in windows dedicated to specific types of
                                       information. Database information is shown in Object Explorer and document windows.
                                       The tools in SQL Server Management Studio work together.

                                       Object Explorer is a tree view of all the database objects in a server. This can include the
                                       databases of the SQL Server Database Engine, Analysis Services, Reporting Services,
                                       Integration Services, and SQL Server 2005 Compact Edition.

                                       The document window is the largest portion of Management Studio. The document
                                       windows can contain query editors and browser windows.
                                       Log File Viewer in SQL Server Management Studio is used to access information about
                                       errors and events. You can open Log File Viewer in several ways, depending on the
                                       information that you want to view.

                                   3.4 Keywords

                                   Log File Viewer: Log File Viewer in SQL Server Management Studio is used to access information
                                   about errors and events.
                                   Management Studio: Management Studio presents information in windows dedicated to specific
                                   types of information.

                                   Object Explorer: Object Explorer is a tree view of all the database objects in a server.

                                   3.5 Review Questions

                                   1.  Explain the use of SQL server tools.
                                   2.  Briefly describe various types of sql server tools.
                                   3.  Explain the concept of “Management Studio” in SQL server.







          42                                LOVELY PROFESSIONAL UNIVERSITY
   43   44   45   46   47   48   49   50   51   52   53