April 2006
Intermediate to advanced
1088 pages
24h 51m
English
Content preview from A Developer’s Guide to SQL Server 2005Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...