B. SQL Server Management Studio

Introduction

SQL Server Management Studio, SSMS for short, is a GUI application that is used by database administrators and developers alike to interact with SQL Server, Analysis Services, Integration Services, Reporting Services, SQL Server Mobile, and SQL Express. This appendix focuses on features used by developers working with SQL Server.

For developers, SSMS revolves around projects used to build queries and managing databases that will run those queries. The queries themselves may end up being run as stand-alone scripts or as commands executed by ADO.NET in client and middle-tier applications.

The main screen of SSMS, shown in Figure B-1, is configurable. Figure B-1 shows a typical configuration a developer ...

Get A Developer’s Guide to SQL Server 2005 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.