Using SQL Server Management Studio

The SQL Server Management Studio graphical point-and-click interface makes server, database, and resource management easy to do. Using SQL Server Management Studio, you can manage both local and remote server instances by establishing a connection to SQL Server and then administering its resources. If you have disabled remote server connections to a particular server, however, you can only work with the server locally (by logging on to the system at the keyboard or by establishing a remote Terminal Server session in Windows and then running the local management tools) or through a Telnet session.

Getting Started with SQL Server Management Studio

To run SQL Server Management Studio, click the Start button, point ...

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.