Using the Graphical Administration Tools

SQL Server 2005 provides several types of tools for administration. The graphical administration tools are the ones you will use most often. You can access these tools by selecting Start, choosing Programs or All Programs, and then using the Microsoft SQL Server 2005 menu.

SQL Server 2005 has several new graphical tools that replace or combine the features of the graphical tools in previous SQL Server editions. SQL Server Management Studio replaces SQL Server Enterprises Manager, Query Analyzer, and Analysis Manager. This means that you can use SQL Server Management Studio to perform most of your core SQL Server administration tasks.

SQL Server Management Studio provides several different views. When you ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.