Organizing the Interface

Management Studio includes a wide variety of functionality organized into thirteen tools, which you can open from the View menu, from the standard toolbar, or from the associated hotkey:

  • Object Explorer (F8): Used for administering and developing SQL Server database objects. The Object Explorer Details page presents a list of objects under the selected node.
  • Registered Servers (Ctrl+Alt+G): Used to manage the connections to multiple SQL Server engines ranging from SQL Server 2005 all the way up to SQL Server 2012. You can register database engines, Analysis Services, Report Servers, SQL Server Express, SQL Server Express LocalDB, and Integration Services servers.
  • Utility Explorer: Opens the Utility Explorer dashboard. Allows you to create a Utility Control Point (UCP) and enroll instances and monitor health states of those servers at a holistic level.
  • Template Explorer (Ctrl+Alt+T): Used to create and manage T-SQL code templates.
  • Solution Explorer (Ctrl+Alt+L): Organizes projects and manages source code control.
  • Properties window (F4): Displays properties for the selected object.
  • Bookmarks window (Ctrl+K, Ctrl+W): Lists current bookmarks from within the Query Editor.
  • Web Browser (Ctrl+Alt+R): Used by the Query Editor to display XML or HTML results.
  • Output window (Ctrl+Alt+O): Displays messages from Management Studio's integrated development tools.
  • Query Editor: The descendant of SQL Server 2000's Query Analyzer, the Query Editor is used to create, edit, ...

Get Microsoft SQL Server 2012 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.