Administer Servers with SQL Server Management Studio

Microsoft SQL Server Management Studio is a rich, integrated administrative client designed to meet the SQL Server administrator's server management requirements. In Management Studio, administrative tasks are accomplished using Object Explorer, which allows you to connect to any server in the SQL Server family and graphically browse its contents. A server can be an instance of the Database Engine, Analysis Services, or Reporting Services, Integration Services.

The tool components of Management Studio include Registered Servers, Object Explorer, Solution Explorer, Template Explorer, the Object Explorer Details page, and the document window. To display a tool, on the View menu, click the tool name. To display the Query Editor tool, click the New Query button on the toolbar.