O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required